Upgrade
Upgrade
Upgrade
Shut down Oracle database Login to the system as software owner (oracle user) Stop listeners if they are running from Oracle Home. If RAC, stop listener on each node.
Run slibclean if the OS is AIX (4 to 5 times) Backup System Backup ORACLE_HOME which are being upgraded to 10205 Ex: /oracle/product/10.2.0 Backup Inventory Locations: P.S: To find inventory location, follow the steps mentioned. Confirm that, we have latest valid level 0 backup for the database. Software upgrade
Run the setdb_<file> for any 10g databases Open the script install_db_patchset_10205.sh and edit the variable SOFTWAREDIR to <stage_loc> Run the script: install_db_patchset_10205.sh After successful completion of Step 14, run the root.sh as root user Database Upgrade Steps Start the listener (follow this step only if Step 5 was run). If RAC, start the listener on each node Single instance database Login as sys user as with sysdba privs RAC Database (only on one node)
Shut down the instance Common steps for Single instance or Rac Database Start the database in upgrade mode Run the upgrade script. Review the upgrade_10205.log file for errors and inspect the list of components that is displayed at the end of catupgrd.sql script Shut down the database and restart Recompile all the invalid packages Run the following command to check the status of all the components after the upgrade: Only for Rac Database Set the CLUSTER_DATABASE initialization parameter to TRUE Restart the database
$ . Setdb_db03pdv $ echo $ORACLE_HOME $ ./install_db_patchset_10205.sh 10 <node1> <node2> <node3> $ sudo /oracle/product/10.2.0/root.sh Database Upgrade Steps $ lsnrctl start LISTENER_NAME Single instance database $. setdb_db03pdv $ sqlplus / as sysdba SQL> RAC Database (only on one node) $. setdb_db03pdv $sqlplus / as sysdba SQL> startup nomount; SQL> ALTER SYSTEM SET CLUSTER_DATABASE=FALSE SCOPE=spfile;
SQL> shut immediate; Common steps for Single instance or Rac Database SQL> startup upgrade; SQL> spool upgrade_10205.log SQL> @?/rdbms/admin/catupgrd.sql SQL> spool off; Component Oracle Database Server Oracle Workspace Manager SQL> shut immediate; SQL> startup SQL>@?/rdbms/admin/utlrp.sql SQL> SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY; Only for Rac Database SQL> ALTER SYSTEM SET CLUSTER_DATABASE=TRUE SCOPE=spfile; SQL> shutdown immediate; SQL> exit; $ srvctl start database -d $ORACLE_DB $ srvctl start service -d $ORACLE_DB Total Status VALID VALID Version 10.2.0.5.0 10.2.0.5.0 HH:MM:SS 00:08:02 00:00:35
Time in Mins
1 2
15 5 2
10
1 20 3
5 10
5 5
Time in Mins
1 1 2
15
2 1 3 10
$ cat catrelod.out SQL> STARTUP SQL> @?/rdbms/admin/utlrp.sql SQL> SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY; For RAC databases only SQL> ALTER SYSTEM SET CLUSTER_DATABASE=TRUE SCOPE=spfile
5 1 1
SQL> SHUTDOWN SQL> EXIT $ srvctl start database -d $ORACLE_DB $ srvctl start service -d $ORACLE_DB Total
5 75 1 hr 15 m
Stop Oracle Database ( One node at a time) Stop the database which is being patched Stop listener if running from ORACLE_HOME Run slibclean if OS is AIX. ( 4 to 5 times) Apply PSU on 10205 Unzip PSU patch 12419392 on stage_loc Run the opatch command to apply patch After successful completetion of Step 13, start the instance Run the catbundle (only on one node, not required on other 2 nodes)
Time in Mins
$ srvctl start instance -d $ORACLE_DB -I $ORACLE_SID $ sqlplus / as sysdba SQL> @?/rdbms/admin/catbundle psu apply SQL> exit; Total 20 mins