20760982--->>>DB PSU 11.2.0.4.7 (INCLUDES CPUJUL2015)--->>>Both DB Homes and Grid Home
20831122--->>>OCW PSU 11.2.0.4.7--->>>Both DB Homes and Grid Home
20299019--->>>ACFS PSU 11.2.0.4.7--->>>Only Grid Home
5 Manual Steps for Apply/Rollback Patch
2.Run the pre root script. If this is a GI Home, as the root user execute:
#
/crs/install/rootcrs.pl -unlock
$GRID_HOME/crs/install/rootcrs.pl -unlock
3.Apply the CRS patch using. As the GI home owner execute:
$
/OPatch/opatch napply -oh
-local
/
/
$GRID_HOME/OPatch/opatch napply -oh $GRID_HOME -local /tmp/patch/20996923/20831122
As the GI home owner execute:
$
/OPatch/opatch napply -oh
-local
/
/
$GRID_HOME/OPatch/opatch napply -oh $GRID_HOME -local /tmp/patch/20996923/20299019
$GRID_HOME/OPatch/opatch rollback -local -id 20299019 -oh $GRID_HOME
As the GI home owner execute:
$
/OPatch/opatch apply -oh
-local
/
/
$GRID_HOME/OPatch/opatch apply -oh $GRID_HOME -local /tmp/patch/20996923/20760982
4.Run the pre script for DB component of the patch. As the database home owner execute:
$
/
/
/custom/server/
/custom/scripts/prepatch.sh -dbhome
/tmp/patch/20996923/20831122/custom/server/20831122/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME
5.Apply the DB patch. As the database home owner execute:
$
/OPatch/opatch napply -oh
-local
/
/
/custom/server/
$
/OPatch/opatch apply -oh
-local
/
/
$ORACLE_HOME/OPatch/opatch rollback -local -id 20831122 -oh $ORACLE_HOME
$ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /tmp/patch/20996923/20831122/custom/server/20831122
$ORACLE_HOME/OPatch/opatch apply -oh $ORACLE_HOME -local /tmp/patch/20996923/20760982
6.Run the post script for DB component of the patch. As the database home owner execute:
$
/
/
/custom/server/
/custom/scripts/postpatch.sh -dbhome
/tmp/patch/20996923/20831122/custom/server/20831122/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME
7.Run the post script. As the root user execute:
#
/rdbms/install/rootadd_rdbms.sh
$GRID_HOME/rdbms/install/rootadd_rdbms.sh
If this is a GI Home, as the root user execute:
#
/crs/install/rootcrs.pl -patch
$GRID_HOME/crs/install/rootcrs.pl -patch
8.If the message, "A system reboot is recommended before using ACFS??? is shown, then a reboot must be issued before continuing. Failure to do so will result in running with an unpatched ACFS\ADVM\OKS driver.
9.Start the CRS managed resources that were earlier running from DB homes. If this is a GI Home environment, as the database home owner execute:
$
/bin/sr
vctl start home -o
-s
-n
$ORACLE_HOME/bin/srvctl start home -o $ORACLE_HOME -s
-n
2.5.2 Loading Modified SQL Files into the Database
The following steps load modified SQL files into the database. For an
Oracle RAC environment, perform these steps on only one node.
For each database instance running on the Oracle home being patched, connect to the database using SQL*Plus. Connect as SYSDBA and run the catbundle.sql script as follows:
cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catbundle.sql psu apply
SQL> QUIT
[grid@elvis111 patch]$ opatch lsinv
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation. All rights reserved.
Oracle Home : /g01/grid/app/11.2.0/grid
Central Inve |