Rollback Patch 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)

If after Applying 21352635: DATABASE PATCH SET UPDATE 11.2.0.4.8 (INCLUDES CPUOCT2015), there are any post patching issues for which a patch rollback is needed, please follow below steps. 

Please note these steps are for NON RAC. (For RAC, steps vary slightly, refer to patch README.TXT for details)

Patch rollback

- Start DB services including listener
- Run the roll back scripts

cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catbundle_PSU_<database SID>_ROLLBACK.sql
SQL> QUIT

- If the OJVM PSU was applied for a previous PSU patch, you may see invalid Java classes after execution of the catbundle.sql script in the previous step. If this is the case, run utlrp.sql to re-validate these Java classes.

cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> @utlrp.sql

- Start all remaining services after patch roll back and do the health checks

Related Posts:

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

Checking for Patch conflicts - 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)

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)

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

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

Before applying patch 21352635: DATABASE PATCH SET UPDATE 11.2.0.4.8 (INCLUDES CPUOCT2015), check for patch conflicts with any existing patches on the Database where patch 21352635 is to be applied.


- cd /sid/PATCH_TOP/21352635 

where PATCH_TOP is the directory where patch is copied

Check for conflicts with existing patches as below

$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph .

- Rollback any conflicting patches highlighted during one-off patch conflict detection.

- Follow patch conflict resolution steps as necessary in the conflict report. Also refer to Section 3.1.4 for more details.

Related Posts:

Rollback Patch 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)

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)