9 Replies Latest reply: Apr 5, 2013 9:23 AM by MartinKlier RSS

    Jan-2013 PSU on 11.2.0.3 over GI & RDBMS Homes (StandAlone Server),

    DBA2013
      Hello Experts,

      Please excuse me if it fetches your precious time to read such a long request.

      I need your help in applying patch over 11.2.0.3 Grid and 11.2.0.3 on single node stand alone databases.

      I downloaded the two patches as given below and unzipped it under the directory /export/psu_grid and /export/PSU_Patch respectively. When I unzipped the grid patch I was little disturbed to see two numbers highlighted(So checked oracle documents and found it is a bundle for both rdbms and GI homes).
      But I want to apply grid and rdbms homes seperatly, because I get confused when i read its readme.html file, because it talks about RAC only.

      If I apply to GI home seperatly, Should I select 15876003 instead of 14727310 , Please check the below document which I have framed and guide me accordingly.

      asm@dat-stb-ora05 /export/psu_grid > ls

      14727310 bundle.xml README.html
      15876003 p14727347_112030_AIX64-5L.zip README.txt

      oracle@dat-stb-ora05 /export/PSU_Patch > ls

      14727310 p14727310_112030_AIX64-5L.zip


      Got from Oracle docs: For 11.2.0.3.5
      BUG 14727347 - GRID INFRASTRUCTURE PATCH SET UPDATE 11.2.0.3.5 contains
      BUG 15876003 - GRID INFRASTRUCTURE PATCH SET UPDATE 11.2.0.3.5 (GI COMPONENTS)
      BUG 14727310 - DATABASE PATCH SET UPDATE 11.2.0.3.5
      In this example, the <GI_PSU_number> is 14727347; the <GI_Components_number> is 15876003; and the <DB_PSU_number> is 14727310.

      Here is my document: Please rectify me if I am going wrong in any way.

      Grid home: /u01/app/asm/product/11.2.0.3/grid

      Oracle Home: /u01/app/oracle/product/11.2.0.3/db_1

      Opatch version is : 11.2.0.3.0 ( SO I am good to go with Jan PSU patch i guess)
      Grid patch (14727347) > 15876003(GI component) and 14727310(DB_PSU_Number) > I guess for grid the patch# 15876003
      RDBMS Patch (14727310)

      I will follow the following steps.

      1. Validate the Oracle Inventory.
      /opt/grid/11.2.0/grid/OPatch/opatch lsinventory -detail -oh /u01/app/asm/product/11.2.0.3/grid

      OPatch version : 11.2.0.3.0

      2. Shut down the databases.

      3. Run the prepatch script

      cd /export/psu_gird

      ./15876003/custom/server/15876003/custom/scripts/prepatch.sh

      4. Shutdown the ASM.

      5. Will Run the below command to stop CSS etc.

      /u01/app/asm/product/11.2.0.3/grid/crs/install/roothas.pl -unlock

      (since it is not a RAC, do i still need to run rootcrs.pl -unlock, please correct me if i go wrong)

      6. Will Apply grid patch.

      /u01/app/asm/product/11.2.0.3/grid/OPatch/opatch napply -oh /u01/app/asm/product/11.2.0.3/grid -id 15876003 (Please verify if this is the right patch# I'm mentioning)

      7. Will Apply psu patch on Oracle home

      /u01/app/oracle/product/11.2.0.3/db_1/OPatch/opatch napply -oh /u01/app/oracle/product/11.2.0.3/db_1 -id 14727310

      8. Run the postpatch script

      ./15876003/custom/server/15876003/custom/scripts/postpatch.sh

      9. Run the following script to enable CSS etc.

      /u01/app/asm/product/11.2.0.3/grid/roothas.pl -patch
      /u01/app/asm/product/11.2.0.3/grid/bin/crsctl check has
      /u01/app/asm/product/11.2.0.3/grid/bin/crsctl check css

      10. If CSS is not online ran the below command.
      /u01/app/asm/product/11.2.0.3/grid/bin/crsctl modify resource "ora.cssd" -attr "AUTO_START=1"
      /u01/app/asm/product/11.2.0.3/grid/bin/crsctl modify resource "ora.diskmon" -attr "AUTO_START=1"
      /u01/app/asm/product/11.2.0.3/grid/bin/crsctl stop has
      /u01/app/asm/product/11.2.0.3/grid/bin/crsctl start has

      11. Bring Up the ASM and apply as shown below and same way for Databases.

      @catbundle.sql psu apply

      12. Finally will run the below command on grid and Oracle.

      /u01/app/asm/product/11.2.0.3/grid/OPatch/opatch lsinventory
      /u01/app/oracle/product/11.2.0.3/db_1/OPatch/opatch lsinventory


      If steps are different please provide the right steps.

      THanks in anticipation

      Edited by: 982955 on Jan 25, 2013 7:56 AM