Hi,
Upgrade 9i -> 10g will not be too bad. The total downtime will be for full
backup and upgrade process itself. Export/Import only works for a small
database but why do you want to endure the pains. The upgrade process will
be average about 1 - 2 hours per database depending on the size of the DB.
1) Setup new 10g ORACLE_HOME, and make a temporary .profile_10g or whatever
you want to call.
2) Install 10g (10.2.0.1...then 10.2.0.3 or and companion if needed).
You could do this any time during the day under .profile_10g
3) Copy the listener.ora, tnsnames.ora, ... to new location (10g HOME)
4) Create create_SYSAUX_tabsp.sql script
5) Make change to pfile initSID.ora from spfil, .profile...
(but put comments in them because your 9i databases are still running
at this movement)
6) Make changes to all runtime environment scripts (but put them in
Comments for later use)
7) Review the check list on note: 316889.1 (installed products, Role
Invalid objects,...)
8) Shutdown all 9i Databases, perform a full backup or a cold backup.
For Each database, bring them up under UPGRADE mode under 10g
Environement
Sqlplus /nolog
>Connect /as sysdba
>startup pfile=..... UPGRADE;
9) >@create_SYSAUX_tabsp.sql
>@?/rdbms/admin/catupgrd.sql -- This is the real Upgrade process
>@?/rdbms/admin/utlu102s.sql TEXT
>@?/rdbms/admin/utlrp.sql
11) Shutdown and Start up the 10g DB
10) Install and apply interim patch, CPU,...
11) Upgrade RMAN catalog (if needed)
rman catalog rman/<password>@Alias
rman> upgrade catalog;
-- enter UPGRADE CATALOG command again to confirm catalog upgrade
RMAN> upgrade catalog; -- Validate the RMAN Catalog
revision
recovery catalog upgraded to version 10.02.00.02
12) Recreate symbolic link for the Veritas Netbackup Client library
(if needed)
Regards
Phong Le
-----Original Message-----
From: Absalom Alcaraz
[mailto:oracledba-ezmlmshield-x31937290.[Email address protected]
Sent: Tuesday, April 29, 2008 1:54 PM
To: LazyDBA Discussion
Subject: Re: upgrade from 9.2.0.5.0 to 10g
I always use migration using utilities export/import.
I used these uitilities to migrate from 8i to 9i and from 9i to 10g.
They worked great.
----- Original Message -----
From: Gauri Thakar <oracledba-ezmlmshield-x95507160.[Email address
protected]
To: LazyDBA Discussion <[Email address protected]
Sent: Tue Apr 29 10:26:47 2008
Subject: upgrade from 9.2.0.5.0 to 10g
Hi,
I am still confused for upgrade from 9.2.0.5.0 to 10g.
Migrating or upgrading the database - what is used normally?
http://www.oracle.com/technology/obe/obe10gdb/install/9i10g/9i10g.htm#o
<http://www.oracle.com/technology/obe/obe10gdb/install/9i10g/9i10g.htm#o
>
This link shows that prerequisite is to have 10g installed.
Even if I want to upgrade - do I still need to have 10g downloaded?
Sorry I am still confused....
Gauri
Oracle DBA - INTERN
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is
for the sole use of the intended recipient(s) and may contain confidential
and privileged information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the intended recipient, please
contact the sender by reply e-mail and destroy all copies of the original
message.
Oracle LazyDBA home page