This discussion is archived
9 Replies Latest reply: Apr 5, 2013 7:23 AM by MartinKlier RSS

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

DBA2013 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points