{{parent page="Oracle"}}

Apply the Universal Installer Patch OPatch 10.2.0.3.4, courtesy of Paul Cheung

1. Put the scheduled RMAN backup on hold
00 1 * * 1-6 $HOME/rman_scripts/run_rman_script $HOME/rman_scripts/10g_arclogs.rcv PPS &> /dev/null

2. Shut down Enterprise Manager and listener
export ORACLE_SID=PPS
emctl stop dbconsole
export ORACLE_SID=PMS
emctl stop dbconsole

3. Shut down the Oracle instance "PPS" & "PMS"
export ORACLE_SID=PPS
sqlplus '/as sysdba'
shutdown immediate;
export ORACLE_SID=PMS
sqlplus '/as sysdba'
shutdown immediate;

4. Apply the CPUJan2008 patches
cd /home/oralce/CPUJan2008_software/6646853
opatch napply -skip_subset -skip_duplicate
opatch lsinventory

5. Start database instance "PPS" & "PMS" and apply the catcpu.sql script to each database instance.
cd $ORACLE_HOME/cpu/CPUJan2008
export ORACLE_SID=PPS
sqlplus '/as sysdba'
startup
@catcpu.sql
@$ORACLE_HOME/rdbms/admin/utlrp.sql

export ORACLE_SID=PMS
sqlplus '/as sysdba'
startup
@catcpu.sql
@$ORACLE_HOME/rdbms/admin/utlrp.sql

6. Start listener
lsnrctl start
lsnrctl status

7. Start Enterprise Manager
export ORACLE_SID=PPS
emctl start dbconsole
emctl status dbconsole
export ORACLE_SID=PMS
emctl start dbconsole
emctl status dbconsole

8. Run the scheduled RMAN backup on hold
$HOME/rman_scripts/run_rman_script $HOME/rman_scripts/10g_arclogs.rcv PPS &> /dev/null