Patching An Oracle RAC 11g/12c Grid(GI) / Database

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

Process to patch an Oracle 11G/12C RAC Grid infrastructure and or database

Note1: Starting with OPatch version 11.2.0.3.14 , 12.1.0.2.12 and higher OCM Is Not bundled with OPatch .OPatch utility may be not look for ocm response file while patching in silent mode .

Note2: In older versions the emocmrsp might be located under OPatch or in /u01/db/12.1.0.1/db_1/ccr/bin/emocmrsp

Download the latest opatch and extract in the ORACLE_HOOM or GI_HOME

Download the latest PSU (quarterly relase) and extract

Stop the DB

SQL> shutdown immediate;

or

srvctl stop database –d DB_NAME

Generate the ocm file. As the GI user

$ORACLE_HOME/OPatch/ocm/bin/emocmrsp  -no_banner -output grid_ocm.rsp

As the oracle user

$ORACLE_HOME/OPatch/ocm/bin/emocmrsp  -no_banner -output db_ocm.rsp

As root patch the GI first – make sure to set all GI variables

opatch auto /installs/11.2.03/db_patch/PSU_11.2.0.3.10 -oh $GI_HOME -ocmrf /usr/grid/grid_ocm.rsp

Note: The PSU_11.2.0.3.10 is the location of the PSU unziped patch

Once done patch the DB as the root user

Note: Make sure to set the proper variables as oracle user

opatch auto /installs/11.2.03/db_patch/PSU_11.2.0.3.10  -oh $ORACLE_HOME -ocmrf db_ocm.rsp

Start the Database

SQL>startup;

Now completed the Database patch

cd $ORACLE_HOME/rdbms/admin
SQL> sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catbundle.sql psu apply
SQL> QUIT

Leave a Reply

avatar
3000
  Subscribe  
Notify of