Monday, July 16, 2012

Apply PSU on 11.2.0.1 Grid Infrastructure & Database Homes

1) Install New Opatch on each node------------(Do it for GI/DB home on each node)
2) Check new Opatch version / Inventory-------(Do it for GI/DB home on each node)
3) If GI/DB home are not shared make sure cluster is running on each nodes.
4) Generate OCM response file on each node----(Do it for GI/DB home on each node)
5) copy/unzip Patch into
6) Apply patch for GI Home--------------------(For each node as root)
7) Apply patch for DB Home--------------------(For each node as root - No Resource must be up from DB home)
8) Verify Patch is Applied.
9) Run catbundle.sql on Database.



Install New OPATCH on each node (Do it for GI/DB home on each node)
copy p6880880_112000_Linux-x86-64.zip to /u00/app/11.2.0/grid which is GRID_HOME

login as: root
root@192.168.100.126's password:
Last login: Fri Jul 13 09:37:48 2012 from 192.168.100.1
[root@PNETN1 ~]# . oraenv
ORACLE_SID = [root] ? +ASM1
The Oracle base for ORACLE_HOME=/u00/app/11.2.0/grid is /u00/app/oracle

[root@PNETN1 test]# cd /u00/app/11.2.0/grid
[root@PNETN1 grid]# mv OPatch/ Opatch_old
[root@PNETN1 grid]# unzip p6880880_112000_Linux-x86-64.zip
[root@PNETN1 grid]# chmod -R 777 Opatch 
[root@PNETN1 grid]# cd /u01/app/oracle/11.2.0/db_1/
[root@PNETN1 db_1]# mv OPatch/ Opatch_old
[root@PNETN1 db_1]# cp -R /u00/app/11.2.0/grid/OPatch/ /u01/app/oracle/11.2.0/db_1/
[root@PNETN1 db_1]# chmod -R 777 Opatch 


===================================================================

Check new Opatch version / Inventory. (Do it for GI/DB home on each node)

PNETN1@:/home/grid : $. oraenv
ORACLE_SID = [grid] ? +ASM1
The Oracle base for ORACLE_HOME=/u00/app/11.2.0/grid is /u00/app/oracle
PNETN1@:/home/grid :+ASM1 $$ORACLE_HOME/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.0
Copyright (c) 2012, Oracle Corporation.  All rights reserved.


Oracle Home       : /u00/app/11.2.0/grid
Central Inventory : /u00/app/oraInventory
   from           : /u00/app/11.2.0/grid/oraInst.loc
OPatch version    : 11.2.0.3.0
OUI version       : 11.2.0.1.0
Log file location : /u00/app/11.2.0/grid/cfgtoollogs/opatch/opatch2012-07-15_09-34-31AM_1.log

Lsinventory Output file location : /u00/app/11.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2012-07-15_09-34-31AM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (1):

Oracle Grid Infrastructure                                           11.2.0.1.0
There are 1 products installed in this Oracle Home.


There are no Interim patches installed in this Oracle Home.


Rac system comprising of multiple nodes
  Local node = PNETN1
  Remote node = PNETN2
  Remote node = PNETN3
--------------------------------------------------------------------------------
OPatch succeeded.

===================================================================

If GI/DB home are not shared make sure cluster is running on each nodes.

--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.CRS.dg
               ONLINE  ONLINE       pnetn1
               ONLINE  ONLINE       pnetn2
               ONLINE  ONLINE       pnetn3
ora.LISTENER.lsnr
               ONLINE  ONLINE       pnetn1
               ONLINE  ONLINE       pnetn2
               ONLINE  ONLINE       pnetn3
ora.asm
               ONLINE  ONLINE       pnetn1                   Started
               ONLINE  ONLINE       pnetn2                   Started
               ONLINE  ONLINE       pnetn3                   Started
ora.eons
               ONLINE  ONLINE       pnetn1
               ONLINE  ONLINE       pnetn2
               ONLINE  ONLINE       pnetn3
ora.gsd
               OFFLINE OFFLINE      pnetn1
               OFFLINE OFFLINE      pnetn2
               OFFLINE OFFLINE      pnetn3
ora.net1.network
               ONLINE  ONLINE       pnetn1
               ONLINE  ONLINE       pnetn2
               ONLINE  ONLINE       pnetn3
ora.ons
               ONLINE  ONLINE       pnetn1
               ONLINE  ONLINE       pnetn2
               ONLINE  ONLINE       pnetn3
ora.registry.acfs
               ONLINE  ONLINE       pnetn1
               ONLINE  ONLINE       pnetn2
               ONLINE  ONLINE       pnetn3
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       pnetn3
ora.LISTENER_SCAN2.lsnr
      1        ONLINE  ONLINE       pnetn1
ora.LISTENER_SCAN3.lsnr
      1        ONLINE  ONLINE       pnetn2
ora.oc4j
      1        OFFLINE OFFLINE
ora.pnetn1.vip
      1        ONLINE  ONLINE       pnetn1
ora.pnetn2.vip
      1        ONLINE  ONLINE       pnetn2
ora.pnetn3.vip
      1        ONLINE  ONLINE       pnetn3
ora.scan1.vip
      1        ONLINE  ONLINE       pnetn3
ora.scan2.vip
      1        ONLINE  ONLINE       pnetn1
ora.scan3.vip
      1        ONLINE  ONLINE       pnetn2

--------------------------------------------------------------------------------

===================================================================

Generate OCM response file on each node (Do it for GI/DB home)
This files will be generated into local directory if specific file-name are not given.

PNETN1@:/home/grid :+ASM1 $$ORACLE_HOME/OPatch/ocm/bin/emocmrsp

OCM Installation Response Generator 10.3.4.0.0 - Production
Copyright (c) 2005, 2010, Oracle and/or its affiliates.  All rights reserved.

Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name:

You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]:  y
The OCM configuration response file (ocm.rsp) was successfully created.

===================================================================

Its good to copy patch into shared file-system if you have one.
copy patch into directory /u01/PATCH/ (Do it for each Node if filesystem is not shared).

[root@PNETN1 ~]# cd /u01/PATCH/
[root@PNETN1 ~]# chmod -R 777 PATCH
[root@PNETN1 ~]# unzip p9655006_112010.zip

which will be /u01/PATCH/p9655006_112010.

===================================================================

Apply patch on GI/DB home as root user , on each node one-by-one

Apply patch for GI Home as root user.

[root@PNETN1 ~]# . oraenv
ORACLE_SID = [+ASM1] ? +ASM1
The Oracle base for ORACLE_HOME=/u01/app/oracle/11.2.0/db_1 is /u00/app/oracle
[root@PNETN1 ~]# /u00/app/11.2.0/grid/OPatch/opatch auto /u01/PATCH/p9655006_112010 -oh /u00/app/11.2.0/grid
Executing /usr/bin/perl /u00/app/11.2.0/grid/OPatch/crs/patch112.pl -patchdir /u01/PATCH -patchn p9655006_112010 -oh /u00/app/11.2.0/grid -paramfile /u00/app/11.2.0/grid/crs/install/crsconfig_params
opatch auto log file location is /u00/app/11.2.0/grid/OPatch/crs/../../cfgtoollogs/opatchauto2012-07-15_15-50-28.log
Detected Oracle Clusterware install
Using configuration parameter file: /u00/app/11.2.0/grid/crs/install/crsconfig_params
OPatch  is bundled with OCM, Enter the absolute OCM response file path:
/home/grid/ocm.rsp

Unable to determine if /u00/app/11.2.0/grid is shared oracle home
Enter 'yes' if this is not a shared home or if the prerequiste actions are performed to patch this shared home (yes/no):yes
Successfully unlock /u00/app/11.2.0/grid
patch /u01/PATCH/p9655006_112010/9655006  apply successful for home  /u00/app/11.2.0/grid
patch /u01/PATCH/p9655006_112010/9654983  apply successful for home  /u00/app/11.2.0/grid
ACFS-9300: ADVM/ACFS distribution files found.
ACFS-9312: Existing ADVM/ACFS installation detected.
ACFS-9314: Removing previous ADVM/ACFS installation.
ACFS-9315: Previous ADVM/ACFS components successfully removed.
ACFS-9307: Installing requested ADVM/ACFS software.
ACFS-9308: Loading installed ADVM/ACFS drivers.
ACFS-9321: Creating udev for ADVM/ACFS.
ACFS-9323: Creating module dependencies - this may take some time.
ACFS-9327: Verifying ADVM/ACFS devices.
ACFS-9309: ADVM/ACFS installation correctness verified.
CRS-4123: Oracle High Availability Services has been started.

===================================================================

Apply patch for DB Home - Make sure if any resource are running for DB home is shut-down.


[root@PNETN1 ~]# . oraenv
ORACLE_SID = [+ASM1] ? test
The Oracle base for ORACLE_HOME=/u01/app/oracle/11.2.0/db_1 is /u00/app/oracle
[root@PNETN1 ~]# /u01/app/oracle/11.2.0/db_1/OPatch/opatch auto /u01/PATCH/p9655006_112010 -oh /u01/app/oracle/11.2.0/db_1
Executing /usr/bin/perl /u01/app/oracle/11.2.0/db_1/OPatch/crs/patch112.pl -patchdir /u01/PATCH -patchn p9655006_112010 -oh /u01/app/oracle/11.2.0/db_1 -paramfile /u00/app/11.2.0/grid/crs/install/crsconfig_params
opatch auto log file location is /u01/app/oracle/11.2.0/db_1/OPatch/crs/../../cfgtoollogs/opatchauto2012-07-15_16-56-48.log
Detected Oracle Clusterware install
Using configuration parameter file: /u00/app/11.2.0/grid/crs/install/crsconfig_params
OPatch  is bundled with OCM, Enter the absolute OCM response file path:
/home/oracle/ocm.rsp

Unable to determine if /u01/app/oracle/11.2.0/db_1 is shared oracle home
Enter 'yes' if this is not a shared home or if the prerequiste actions are performed to patch this shared home (yes/no):yes
patch /u01/PATCH/p9655006_112010/9655006/custom/server/9655006  apply successful for home  /u01/app/oracle/11.2.0/db_1
patch /u01/PATCH/p9655006_112010/9654983  apply successful for home  /u01/app/oracle/11.2.0/db_1
[root@PNETN1 ~]#

===================================================================
Verify Patch is Applied.

[root@PNETN1 ~]# su - grid
PNETN1@:/home/grid :+ASM1 $/u00/app/11.2.0/grid/OPatch/opatch lsinventory  -bugs_fixed | grep 'GI PSU'
9655006    9655006   Sun Jul 15 15:33:59 EDT 2012   GI PSU 11.2.0.1.2 (INCLUDES DATABASE PSU 11.2.0.1.
9778840    9655006   Sun Jul 15 15:33:59 EDT 2012   TRACKING BUG FOR GI PSU( THIS IS REPLACEMENT FOR
                                                    APRIL GI PSU 9343627)

[root@PNETN1 ~]# su - oracle
PNETN1@:/home/oracle :test $/u01/app/oracle/11.2.0/db_1/OPatch/opatch lsinventory  -bugs_fixed | grep 'DATABASE PSU'
9352237    9654983   Sun Jul 15 16:47:28 EDT 2012   DATABASE PSU 11.2.0.1.1
9654983    9654983   Sun Jul 15 16:47:28 EDT 2012   DATABASE PSU 11.2.0.1.2 (INCLUDES CPUJUL2010)
9655006    9655006   Sun Jul 15 16:45:17 EDT 2012   GI PSU 11.2.0.1.2 (INCLUDES DATABASE PSU 11.2.0.1.

===================================================================
Run catbundle.sql

connect as sysdba and run below script.

SQL> @?catbundle.sql psu apply



No comments:

Post a Comment