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
===================================================================
Check new Opatch version / Inventory. (Do it for GI/DB home on each node)
===================================================================
If GI/DB home are not shared make sure cluster is running on each nodes.
===================================================================
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.
===================================================================
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).
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.
===================================================================
Apply patch for DB Home - Make sure if any resource are running for DB home is shut-down.
===================================================================
Verify Patch is Applied.
===================================================================
Run catbundle.sql
connect as sysdba and run below script.
SQL> @?catbundle.sql psu apply
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
