Thursday, 29 October 2015

Applying 21352635: DATABASE PATCH SET UPDATE 11.2.0.4.8 (INCLUDES CPUOCT2015)

Applying 21352635: DATABASE PATCH SET UPDATE 11.2.0.4.8 (INCLUDES CPUOCT2015)

- Download patch 21352635 (p21352635_112040_Linux-x86-64.zip) (chose zip file for relevant platform) 

- Copy and unzip the patch onto the server at a location with appropriate permissions say PATCH_TOP

- Ensure all patch pre-requisites are met as documented in the patch README.TXT file

- Shutdown Mid-Tier and DB services and take a cold backup before applying the patch (recommended)

Check for patch conflicts:

Refer to Checking for Patch conflicts - 21352635: DATABASE PATCH SET UPDATE 11.2.0.4.8 (INCLUDES CPUOCT2015) for details.


Apply latest OPatch

- Backup existing OPatch directory

cd $ORACLE_HOME
mv OPatch OPatch_<ddmmyy>

- $ unzip /sid/PATCH_TOP/p6880880_112000_Linux-x86-64.zip
- $ copy /sid/PATCH_TOP/OPatch $ORACLE_HOME/
- $ export PATH=$ORACLE_HOME/OPatch:$PATH
- $ opatch version

Apply DB PSU Patch 21352635

- $ cd /sid/PATCH_TOP/21352635
- $ opatch apply

Any existing previous PSU patches will be rolledback by OPatch

- Start DB services including listener

Post patching steps

- $cd $ORACLE_HOME/rdbms/admin

sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catbundle.sql psu apply

- Run utlrp.sql

SQL> @utlrp.sql
SQL> QUIT

- Check the following log files in $ORACLE_HOME/cfgtoollogs/catbundle or $ORACLE_BASE/cfgtoollogs/catbundle for any errors:

catbundle_PSU_<database SID>_APPLY_<TIMESTAMP>.log
catbundle_PSU_<database SID>_GENERATE_<TIMESTAMP>.log

- Start all services and verify no post patching issues by doing quick post patching health checks

Related Posts:

Checking for Patch conflicts - 21352635: DATABASE PATCH SET UPDATE 11.2.0.4.8 (INCLUDES CPUOCT2015)

Rollback Patch 21352635: DATABASE PATCH SET UPDATE 11.2.0.4.8 (INCLUDES CPUOCT2015)

libserver11.a:/qksbg.o Patch 12942119 conflicts when applying Oracle 11.2.0.3.0 Patch 20760997: DATABASE PATCH SET UPDATE 11.2.0.3.15 (INCLUDES CPUJUL2015)

No comments:

Post a Comment