PSU(PATCH SET UPDATE) FROM 11.2.0.1.7 to 11.2.0.3.0

PSU(PATCH SET UPDATE):

§  Per –request is satisfied   on  DBGALE instance Oracle  home 

o   Opatch Version should  be 11.2.0.3.0

§  This  is  not  satisfied we need to upgrade  the OPATCH  version  from  11.2.0.1.7  to 11.2.0.3.0

§  Download the OPatch utility (Patch 6880880) to a temporary directory.

§  For each Oracle RAC database home and the GI home that are being patched, run the following commands as the home owner to extract the OPatch utility.

·        zip <OPATCH-ZIP> -d <ORACLE_HOME>

·        $ <ORACLE_HOME>/OPatch/opatch version

o   Validation of Oracle Inventory

§  <ORACLE_HOME>/OPatch/opatch lsinventory -detail -oh <ORACLE_HOME>

o   Unzipping the Patch

o   Check Inventory on Both Nodes -

§  ./opatch lsinventory -bugs_fixed | egrep 'PSU|PATCH SET UPDATE'

o   Loading Modified SQL Files into the Database

§  cd $ORACLE_HOME/rdbms/admin

§  sqlplus /nolog

§  SQL> CONNECT / AS SYSDBA

§  SQL> STARTUP

§  SQL> @catbundle.sql psu apply

§  SQL> QUIT

o   Check the following log files in $ORACLE_BASE/cfgtoollogs/catbundle for any errors:

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

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