Oracle 10g upgradation Outline

Platform: Sun Solaris 5.8
Architecture: Sun Sparc 64bit
Oracle Version: 10.1.0.2.0 64bit
Upgradation path: 10.1.0.2.0 --> 10.2.0.1.0 --> 10.2.0.4.0
How to get RDBMS: Download from OTN / Metalink

Upgradation Steps:

1. Shutdown oracle db [shutdown immediate]

2. Take complete backup [cold backup]

3. Stop all services

Listener, OEM console, Cronjobs

4. Backup oracle home and inventory files

a. $ tar -cvf 10102.tar $OH/10102

b. $ tar –cvf Inventory.tar $OH/oraInventory

c. Save it in backup location

5. Install new Oracle home 10.2.0.1 in separate folder

6. Startup database with previous home [10.1.0.2.0]

a. Export ORACLE_HOME=/u01/app/oracle/product/10.1.0

b. Startup normal;

7. Check the compatibility

a. sql> @/u01/app/oracle/product/10.2.0/rdbms/admin/utlu102i.sql

b. Examine spool file and correct if any errors.

8. Startup db with new home 10.2.0.1.0 in upgrade mode.

a. $ export ORACCLE_HOME=/u01/app/oracle/product/10.2.0

b. Sql> Startup upgrade; (copy spfile from pervious to new home)

9. Upgrade the database

a. Sql> @/u01/app/oracle/product/10.2.0/rdbms/admin/catupgrade.sql

b. Verify the spool file and correct the errors if any. c. Bounce the database.

10. Examine and compile invalid object

a. Sql> @/u01/app/oracle/product/10.2.0/rdbms/admin/utlrp.sql

b. Examine spool file and re-compaile if any invalid objects.

11. Database has upgraded to 10.2.0.1.0 and now want to apply the patchset 10.2.0.4.0 on top of 10.2.0.1.0.

12. Omit step 5 and 6. Repeat remaining steps. Before install 10.2.0.4 patchset backup the following files " utlu102i.sql and catupgrade.sql "