11gr2 rac restart–apply psu(11.2.0.3.6)
rac滾動每個節點逐一打：
1 patch grid如下：
1.1 關閉crs:
節點1:
[root@ossoipltedb11 install]# /oracle/app/11.2.0.3/gi/crs/install/rootcrs.pl -unlock
Using configuration parameter file: /oracle/app/11.2.0.3/gi/crs/install/crsconfig_params
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'ossoipltedb11'
CRS-2673: Attempting to stop 'ora.crsd' on 'ossoipltedb11'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'ossoipltedb11'
CRS-2673: Attempting to stop 'ora.cvu' on 'ossoipltedb11'
CRS-2673: Attempting to stop 'ora.OCR.dg' on 'ossoipltedb11'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'ossoipltedb11'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'ossoipltedb11'
CRS-2673: Attempting to stop 'ora.oc4j' on 'ossoipltedb11'
CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'ossoipltedb11' succeeded
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'ossoipltedb11'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'ossoipltedb11' succeeded
CRS-2673: Attempting to stop 'ora.ossoipltedb11.vip' on 'ossoipltedb11'
CRS-2677: Stop of 'ora.scan1.vip' on 'ossoipltedb11' succeeded
CRS-2672: Attempting to start 'ora.scan1.vip' on 'ossoipltedb12'
CRS-2677: Stop of 'ora.ossoipltedb11.vip' on 'ossoipltedb11' succeeded
CRS-2672: Attempting to start 'ora.ossoipltedb11.vip' on 'ossoipltedb12'
CRS-2677: Stop of 'ora.cvu' on 'ossoipltedb11' succeeded
CRS-2672: Attempting to start 'ora.cvu' on 'ossoipltedb12'
CRS-2676: Start of 'ora.scan1.vip' on 'ossoipltedb12' succeeded
CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'ossoipltedb12'
CRS-2676: Start of 'ora.cvu' on 'ossoipltedb12' succeeded
CRS-2676: Start of 'ora.ossoipltedb11.vip' on 'ossoipltedb12' succeeded
CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'ossoipltedb12' succeeded
CRS-2677: Stop of 'ora.oc4j' on 'ossoipltedb11' succeeded
CRS-2672: Attempting to start 'ora.oc4j' on 'ossoipltedb12'
CRS-2676: Start of 'ora.oc4j' on 'ossoipltedb12' succeeded
CRS-2677: Stop of 'ora.OCR.dg' on 'ossoipltedb11' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'ossoipltedb11'
CRS-2677: Stop of 'ora.asm' on 'ossoipltedb11' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'ossoipltedb11'
CRS-2677: Stop of 'ora.ons' on 'ossoipltedb11' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'ossoipltedb11'
CRS-2677: Stop of 'ora.net1.network' on 'ossoipltedb11' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'ossoipltedb11' has completed
CRS-2677: Stop of 'ora.crsd' on 'ossoipltedb11' succeeded
CRS-2673: Attempting to stop 'ora.crf' on 'ossoipltedb11'
CRS-2673: Attempting to stop 'ora.ctssd' on 'ossoipltedb11'
CRS-2673: Attempting to stop 'ora.evmd' on 'ossoipltedb11'
CRS-2673: Attempting to stop 'ora.asm' on 'ossoipltedb11'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'ossoipltedb11'
CRS-2677: Stop of 'ora.crf' on 'ossoipltedb11' succeeded
CRS-2677: Stop of 'ora.evmd' on 'ossoipltedb11' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'ossoipltedb11' succeeded
CRS-2677: Stop of 'ora.asm' on 'ossoipltedb11' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'ossoipltedb11'
CRS-2677: Stop of 'ora.ctssd' on 'ossoipltedb11' succeeded
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'ossoipltedb11' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'ossoipltedb11'
CRS-2677: Stop of 'ora.cssd' on 'ossoipltedb11' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'ossoipltedb11'
CRS-2677: Stop of 'ora.gipcd' on 'ossoipltedb11' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'ossoipltedb11'
CRS-2677: Stop of 'ora.gpnpd' on 'ossoipltedb11' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'ossoipltedb11' has completed
CRS-4133: Oracle High Availability Services has been stopped.
Successfully unlock /oracle/app/11.2.0.3/gi
節點2:
[root@ossoipltedb12 install]# /oracle/app/11.2.0.3/gi/crs/install/rootcrs.pl -unlock
Using configuration parameter file: /oracle/app/11.2.0.3/gi/crs/install/crsconfig_params
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'ossoipltedb12'
CRS-2673: Attempting to stop 'ora.crsd' on 'ossoipltedb12'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'ossoipltedb12'
CRS-2673: Attempting to stop 'ora.cvu' on 'ossoipltedb12'
CRS-2673: Attempting to stop 'ora.oc4j' on 'ossoipltedb12'
CRS-2673: Attempting to stop 'ora.ossoipltedb11.vip' on 'ossoipltedb12'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'ossoipltedb12'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'ossoipltedb12'
CRS-2673: Attempting to stop 'ora.OCR.dg' on 'ossoipltedb12'
CRS-2677: Stop of 'ora.ossoipltedb11.vip' on 'ossoipltedb12' succeeded
CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'ossoipltedb12' succeeded
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'ossoipltedb12'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'ossoipltedb12' succeeded
CRS-2673: Attempting to stop 'ora.ossoipltedb12.vip' on 'ossoipltedb12'
CRS-2677: Stop of 'ora.scan1.vip' on 'ossoipltedb12' succeeded
CRS-2677: Stop of 'ora.cvu' on 'ossoipltedb12' succeeded
CRS-2677: Stop of 'ora.ossoipltedb12.vip' on 'ossoipltedb12' succeeded
CRS-2677: Stop of 'ora.oc4j' on 'ossoipltedb12' succeeded
CRS-2677: Stop of 'ora.OCR.dg' on 'ossoipltedb12' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'ossoipltedb12'
CRS-2677: Stop of 'ora.asm' on 'ossoipltedb12' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'ossoipltedb12'
CRS-2677: Stop of 'ora.ons' on 'ossoipltedb12' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'ossoipltedb12'
CRS-2677: Stop of 'ora.net1.network' on 'ossoipltedb12' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'ossoipltedb12' has completed
CRS-2677: Stop of 'ora.crsd' on 'ossoipltedb12' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'ossoipltedb12'
CRS-2673: Attempting to stop 'ora.evmd' on 'ossoipltedb12'
CRS-2673: Attempting to stop 'ora.asm' on 'ossoipltedb12'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'ossoipltedb12'
CRS-2677: Stop of 'ora.evmd' on 'ossoipltedb12' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'ossoipltedb12' succeeded
CRS-2677: Stop of 'ora.asm' on 'ossoipltedb12' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'ossoipltedb12'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'ossoipltedb12' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'ossoipltedb12' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'ossoipltedb12'
CRS-2677: Stop of 'ora.cssd' on 'ossoipltedb12' succeeded
CRS-2673: Attempting to stop 'ora.crf' on 'ossoipltedb12'
CRS-2677: Stop of 'ora.crf' on 'ossoipltedb12' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'ossoipltedb12'
CRS-2677: Stop of 'ora.gipcd' on 'ossoipltedb12' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'ossoipltedb12'
CRS-2677: Stop of 'ora.gpnpd' on 'ossoipltedb12' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'ossoipltedb12' has completed
CRS-4133: Oracle High Availability Services has been stopped.
Successfully unlock /oracle/app/11.2.0.3/gi
1.2 tar目錄
[grid@ossoipltedb7 install]$ cd OPatch/
[grid@ossoipltedb7 OPatch]$ ls
crs emdpatch.pl ocm opatch.bat opatchdiag.bat opatch.pl oplan version.txt
docs jlib opatch opatchdiag opatch.ini opatchprereqs README.txt
[grid@ossoipltedb7 OPatch]$ ./opatch napply -oh /oracle/app/11.2.0.3/gi -local /oracle/install/psu/16902043
OPatch could not create/open history file for writing : /oracle/app/11.2.0.3/gi/cfgtoollogs/opatch/opatch_history.txt
/oracle/app/11.2.0.3/gi/cfgtoollogs/opatch/opatch_history.txt (Permission denied)
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation. All rights reserved.
^C
OPatch failed with error code 130
[grid@ossoipltedb7 OPatch]$ ./opatch napply -oh /oracle/app/11.2.0.3/gi -local /oracle/install/psu/16902043
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/app/11.2.0.3/gi
Central Inventory : /oracle/app/oraInventory
from : /oracle/app/11.2.0.3/gi/oraInst.loc
OPatch version : 11.2.0.3.6
OUI version : 11.2.0.3.0
Log file location : /oracle/app/11.2.0.3/gi/cfgtoollogs/opatch/opatch2014-03-02_13-19-55PM_1.log
Verifying environment and performing prerequisite checks...
Prerequisite check "CheckActiveFilesAndExecutables" failed.
The details are:
Following executables are active :
/oracle/app/11.2.0.3/gi/bin/tnslsnr
Prerequisite check "CheckActiveFilesAndExecutables" failed.
The details are:
Following executables are active :
/oracle/app/11.2.0.3/gi/lib/libclntsh.so.11.1
UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.Prerequisite check "CheckActiveFilesAndExecutables" failed.
Log file location: /oracle/app/11.2.0.3/gi/cfgtoollogs/opatch/opatch2014-03-02_13-19-55PM_1.log
OPatch failed with error code 73
[grid@ossoipltedb7 OPatch]$ more /oracle/app/11.2.0.3/gi/cfgtoollogs/opatch/opatch2014-03-02_13-19-55PM_1.log
[Mar 2, 2014 1:19:56 PM] OPatch invoked as follows: 'napply -oh /oracle/app/11.2.0.3/gi -local /oracle/install/psu/16902043 -invPt
rLoc /oracle/app/11.2.0.3/gi/oraInst.loc '
[Mar 2, 2014 1:19:56 PM] OUI-67077:
Oracle Home : /oracle/app/11.2.0.3/gi
Central Inventory : /oracle/app/oraInventory
from : /oracle/app/11.2.0.3/gi/oraInst.loc
OPatch version : 11.2.0.3.6
OUI version : 11.2.0.3.0
OUI location : /oracle/app/11.2.0.3/gi/oui
Log file location : /oracle/app/11.2.0.3/gi/cfgtoollogs/opatch/opatch2014-03-02_13-19-55PM_1.log
[Mar 2, 2014 1:19:56 PM] Patch history file: /oracle/app/11.2.0.3/gi/cfgtoollogs/opatch/opatch_history.txt
[Mar 2, 2014 1:19:59 PM] Verifying environment and performing prerequisite checks...
[Mar 2, 2014 1:19:59 PM] Ignoring file "/oracle/install/psu/16902043/patchmd.xml" in the patch directory.
[Mar 2, 2014 1:20:00 PM] Checking conflict among patches...
[Mar 2, 2014 1:20:00 PM] Patch ID 16902043
[Mar 2, 2014 1:20:00 PM] Patches that conflict: [ ]
[Mar 2, 2014 1:20:00 PM] Checking conflicts for patch : 16902043
[Mar 2, 2014 1:20:01 PM] Checking if Oracle Home has components required by patches...
[Mar 2, 2014 1:20:01 PM] Check if patch "13343438" is a no-op patch.
[Mar 2, 2014 1:20:01 PM] Check if patch "13696216" is a no-op patch.
[Mar 2, 2014 1:20:01 PM] Opt. comp. not in OH inventory: oracle.sysman.console.db, 11.2.0.3.0
[Mar 2, 2014 1:20:01 PM] Opt. comp. not in OH inventory: oracle.sysman.oms.core, 10.2.0.4.4
[Mar 2, 2014 1:20:01 PM] [ oracle.sysman.console.db, 11.2.0.3.0 ] , [ oracle.sysman.oms.core, 10.2.0.4.4 ]
[Mar 2, 2014 1:20:01 PM] Check if patch "13923374" is a no-op patch.
[Mar 2, 2014 1:20:01 PM] Opt. comp. not in OH inventory: oracle.sysman.console.db, 11.2.0.3.0
[Mar 2, 2014 1:20:01 PM] Opt. comp. not in OH inventory: oracle.network.cman, 11.2.0.3.0
[Mar 2, 2014 1:20:01 PM] [ oracle.sysman.console.db, 11.2.0.3.0 ] , [ oracle.network.cman, 11.2.0.3.0 ]
[Mar 2, 2014 1:20:01 PM] Check if patch "14275605" is a no-op patch.
[Mar 2, 2014 1:20:01 PM] Opt. comp. not in OH inventory: oracle.precomp.common, 11.2.0.3.0
[Mar 2, 2014 1:20:01 PM] Opt. comp. not in OH inventory: oracle.precomp.lang, 11.2.0.3.0
[Mar 2, 2014 1:20:01 PM] [ oracle.precomp.common, 11.2.0.3.0 ] , [ oracle.precomp.lang, 11.2.0.3.0 ]
[Mar 2, 2014 1:20:01 PM] Check if patch "14727310" is a no-op patch.
...skipping 32 lines
[Mar 2, 2014 1:20:01 PM] Opt. comp. not in OH inventory: oracle.sysman.console.db, 11.2.0.3.0
[Mar 2, 2014 1:20:01 PM] Opt. comp. not in OH inventory: oracle.sysman.oms.core, 10.2.0.4.4
[Mar 2, 2014 1:20:01 PM] [ oracle.sysman.console.db, 11.2.0.3.0 ] , [ oracle.sysman.oms.core, 10.2.0.4.4 ]
[Mar 2, 2014 1:20:01 PM] Check if patch "13923374" is a no-op patch.
[Mar 2, 2014 1:20:01 PM] Opt. comp. not in OH inventory: oracle.sysman.console.db, 11.2.0.3.0
[Mar 2, 2014 1:20:01 PM] Opt. comp. not in OH inventory: oracle.network.cman, 11.2.0.3.0
[Mar 2, 2014 1:20:01 PM] [ oracle.sysman.console.db, 11.2.0.3.0 ] , [ oracle.network.cman, 11.2.0.3.0 ]
[Mar 2, 2014 1:20:01 PM] Check if patch "14275605" is a no-op patch.
[Mar 2, 2014 1:20:01 PM] Opt. comp. not in OH inventory: oracle.precomp.common, 11.2.0.3.0
[Mar 2, 2014 1:20:01 PM] Opt. comp. not in OH inventory: oracle.precomp.lang, 11.2.0.3.0
[Mar 2, 2014 1:20:01 PM] [ oracle.precomp.common, 11.2.0.3.0 ] , [ oracle.precomp.lang, 11.2.0.3.0 ]
[Mar 2, 2014 1:20:01 PM] Check if patch "14727310" is a no-op patch.
[Mar 2, 2014 1:20:01 PM] Opt. comp. not in OH inventory: oracle.sysman.console.db, 11.2.0.3.0
[Mar 2, 2014 1:20:01 PM] Opt. comp. not in OH inventory: oracle.sysman.oms.core, 10.2.0.4.4
[Mar 2, 2014 1:20:01 PM] [ oracle.sysman.console.db, 11.2.0.3.0 ] , [ oracle.sysman.oms.core, 10.2.0.4.4 ]
[Mar 2, 2014 1:20:01 PM] Check if patch "16056266" is a no-op patch.
[Mar 2, 2014 1:20:01 PM] Opt. comp. not in OH inventory: oracle.network.cman, 11.2.0.3.0
[Mar 2, 2014 1:20:01 PM] Opt. comp. not in OH inventory: oracle.ovm, 11.2.0.3.0
[Mar 2, 2014 1:20:01 PM] [ oracle.network.cman, 11.2.0.3.0 ] , [ oracle.ovm, 11.2.0.3.0 ]
[Mar 2, 2014 1:20:01 PM] Check if patch "16619892" is a no-op patch.
[Mar 2, 2014 1:20:01 PM] Opt. comp. not in OH inventory: oracle.marvel, 11.2.0.3.0
[Mar 2, 2014 1:20:01 PM] Opt. comp. not in OH inventory: oracle.precomp.common, 11.2.0.3.0
[Mar 2, 2014 1:20:01 PM] Opt. comp. not in OH inventory: oracle.precomp.lang, 11.2.0.3.0
[Mar 2, 2014 1:20:01 PM] Opt. comp. not in OH inventory: oracle.sysman.agent, 10.2.0.4.3
[Mar 2, 2014 1:20:01 PM] Opt. comp. not in OH inventory: oracle.sysman.console.db, 11.2.0.3.0
[Mar 2, 2014 1:20:01 PM] Opt. comp. not in OH inventory: oracle.sysman.repository.core, 10.2.0.4.4
[Mar 2, 2014 1:20:01 PM] Opt. comp. not in OH inventory: oracle.xdk, 11.2.0.3.0
[Mar 2, 2014 1:20:01 PM] [ oracle.marvel, 11.2.0.3.0 ] , [ oracle.precomp.common, 11.2.0.3.0 ] , [ oracle.precomp.lang, 11.2.0.3.0
] , [ oracle.sysman.agent, 10.2.0.4.3 ] , [ oracle.sysman.console.db, 11.2.0.3.0 ] , [ oracle.sysman.repository.core, 10.2.0.4.4 ] ,
[ oracle.xdk, 11.2.0.3.0 ]
[Mar 2, 2014 1:20:01 PM] Check if patch "16902043" is a no-op patch.
[Mar 2, 2014 1:20:01 PM] Opt. comp. not in OH inventory: oracle.idm.oid, 11.2.0.3.0
...skipping 32 lines
[Mar 2, 2014 1:20:04 PM] Finish fuser command /sbin/fuser /oracle/app/11.2.0.3/gi/bin/rman at Sun Mar 02 13:20:04 CST 2014
[Mar 2, 2014 1:20:04 PM] Start fuser command /sbin/fuser /oracle/app/11.2.0.3/gi/bin/wrap at Sun Mar 02 13:20:04 CST 2014
[Mar 2, 2014 1:20:04 PM] Finish fuser command /sbin/fuser /oracle/app/11.2.0.3/gi/bin/wrap at Sun Mar 02 13:20:04 CST 2014
[Mar 2, 2014 1:20:04 PM] Start fuser command /sbin/fuser /oracle/app/11.2.0.3/gi/bin/plshprof at Sun Mar 02 13:20:04 CST 2014
[Mar 2, 2014 1:20:04 PM] Finish fuser command /sbin/fuser /oracle/app/11.2.0.3/gi/bin/plshprof at Sun Mar 02 13:20:04 CST 2014
[Mar 2, 2014 1:20:04 PM] Start fuser command /sbin/fuser /oracle/app/11.2.0.3/gi/lib/libclntsh.so.11.1 at Sun Mar 02 13:20:04 CST
2014
[Mar 2, 2014 1:20:04 PM] Finish fuser command /sbin/fuser /oracle/app/11.2.0.3/gi/lib/libclntsh.so.11.1 at Sun Mar 02 13:20:04 CST
2014
[Mar 2, 2014 1:20:04 PM] Following executables are active :
/oracle/app/11.2.0.3/gi/lib/libclntsh.so.11.1
[Mar 2, 2014 1:20:04 PM] Prerequisite check "CheckActiveFilesAndExecutables" failed.
The details are:
Following executables are active :
/oracle/app/11.2.0.3/gi/lib/libclntsh.so.11.1
[Mar 2, 2014 1:20:04 PM] Start fuser command /sbin/fuser /oracle/app/11.2.0.3/gi/bin/amdu at Sun Mar 02 13:20:04 CST 2014
[Mar 2, 2014 1:20:04 PM] Finish fuser command /sbin/fuser /oracle/app/11.2.0.3/gi/bin/amdu at Sun Mar 02 13:20:04 CST 2014
[Mar 2, 2014 1:20:04 PM] Start fuser command /sbin/fuser /oracle/app/11.2.0.3/gi/bin/kfed at Sun Mar 02 13:20:04 CST 2014
[Mar 2, 2014 1:20:04 PM] Finish fuser command /sbin/fuser /oracle/app/11.2.0.3/gi/bin/kfed at Sun Mar 02 13:20:04 CST 2014
[Mar 2, 2014 1:20:05 PM] OUI-67073:UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.Prerequisite che
ck "CheckActiveFilesAndExecutables" failed.
[Mar 2, 2014 1:20:05 PM] Finishing UtilSession at Sun Mar 02 13:20:05 CST 2014
[Mar 2, 2014 1:20:05 PM] Log file location: /oracle/app/11.2.0.3/gi/cfgtoollogs/opatch/opatch2014-03-02_13-19-55PM_1.log
[Mar 2, 2014 1:20:05 PM] Stack Description: java.lang.RuntimeException: Prerequisite check "CheckActiveFilesAndExecutables" failed
.Prerequisite check "CheckActiveFilesAndExecutables" failed.
[Mar 2, 2014 1:20:05 PM] StackTrace: oracle.opatch.OPatchSessionHelper.runApplyPrereqs(OPatchSessionHelper.java:6420)
[Mar 2, 2014 1:20:05 PM] StackTrace: oracle.opatch.opatchutil.NApply.process(NApply.java:1614)
[Mar 2, 2014 1:20:05 PM] StackTrace: oracle.opatch.opatchutil.OUSession.napply(OUSession.java:1136)
[Mar 2, 2014 1:20:05 PM] StackTrace: sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[Mar 2, 2014 1:20:05 PM] StackTrace: sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
...skipping 32 lines
[grid@ossoipltedb7 OPatch]$
1.3 報錯處理（估計是沒有按照規範停掉crs所致）：
[root@ossoipltedb7 gi]# /sbin/fuser /oracle/app/11.2.0.3/gi/lib/libclntsh.so.11.1
/oracle/app/11.2.0.3/gi/lib/libclntsh.so.11.1: 30301m 30302m 30458m 31736m
root@ossoipltedb7 gi]# ps -ef |grep 30301
root 12722 12230 0 13:24 pts/4 00:00:00 grep 30301
grid 30301 1 0 Mar01 ? 00:00:00 /oracle/app/11.2.0.3/gi/opmn/bin/ons -d
grid 30302 30301 0 Mar01 ? 00:00:11 /oracle/app/11.2.0.3/gi/opmn/bin/ons -d
[root@ossoipltedb7 gi]# kill -9 30301
[root@ossoipltedb7 gi]# kill -9 30302
[root@ossoipltedb7 gi]# ps -ef |grep 30302
root 12737 12230 0 13:25 pts/4 00:00:00 grep 30302
[root@ossoipltedb7 gi]# ps -ef |grep 30458
root 12748 12230 0 13:25 pts/4 00:00:00 grep 30458
grid 30458 1 0 Mar01 ? 00:00:00 /oracle/app/11.2.0.3/gi/bin/tnslsnr LISTENER_SCAN1 -inherit
[root@ossoipltedb7 gi]# kill -9 30458
[root@ossoipltedb7 gi]# ps -ef |grep 30458
root 12756 12230 0 13:25 pts/4 00:00:00 grep 30458
[root@ossoipltedb7 gi]# ps -ef |grep 31736
root 12761 12230 0 13:25 pts/4 00:00:00 grep 31736
grid 31736 1 0 Mar01 ? 00:00:00 /oracle/app/11.2.0.3/gi/bin/tnslsnr LISTENER -inherit
[root@ossoipltedb7 gi]# kill -9 31736
[root@ossoipltedb7 gi]# ps -ef |grep 31736
root 12780 12230 0 13:26 pts/4 00:00:00 grep 31736
[root@ossoipltedb7 gi]# /sbin/fuser /oracle/app/11.2.0.3/gi/lib/libclntsh.so.11.1
[root@ossoipltedb7 gi]#
node2 :
[root@ossoipltedb8 gi]# /sbin/fuser /oracle/app/11.2.0.3/gi/lib/libclntsh.so.11.1
/oracle/app/11.2.0.3/gi/lib/libclntsh.so.11.1: 35104m 35105m 36240m
[root@ossoipltedb8 gi]# ps -ef |grep 35104
grid 35104 1 0 Mar01 ? 00:00:00 /oracle/app/11.2.0.3/gi/opmn/bin/ons -d
grid 35105 35104 0 Mar01 ? 00:00:11 /oracle/app/11.2.0.3/gi/opmn/bin/ons -d
root 74885 74041 0 13:27 pts/2 00:00:00 grep 35104
[root@ossoipltedb8 gi]# kill -9 35104
[root@ossoipltedb8 gi]# kill -9 35105
[root@ossoipltedb8 gi]# ps -ef |grep 35104
root 74897 74041 0 13:27 pts/2 00:00:00 grep 35104
[root@ossoipltedb8 gi]# /sbin/fuser /oracle/app/11.2.0.3/gi/lib/libclntsh.so.11.1
/oracle/app/11.2.0.3/gi/lib/libclntsh.so.11.1: 36240m
[root@ossoipltedb8 gi]# ps -ef |grep 36240
grid 36240 1 0 Mar01 ? 00:00:00 /oracle/app/11.2.0.3/gi/bin/tnslsnr LISTENER -inherit
root 74903 74041 0 13:27 pts/2 00:00:00 grep 36240
[root@ossoipltedb8 gi]# kill -9 36240
[root@ossoipltedb8 gi]# /sbin/fuser /oracle/app/11.2.0.3/gi/lib/libclntsh.so.11.1
1.4 實施過程：
node1：
[grid@ossoipltedb7 OPatch]$ ./opatch napply -oh /oracle/app/11.2.0.3/gi -local /oracle/install/psu/16902043
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/app/11.2.0.3/gi
Central Inventory : /oracle/app/oraInventory
from : /oracle/app/11.2.0.3/gi/oraInst.loc
OPatch version : 11.2.0.3.6
OUI version : 11.2.0.3.0
Log file location : /oracle/app/11.2.0.3/gi/cfgtoollogs/opatch/opatch2014-03-02_13-31-47PM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 13343438 13696216 13923374 14275605 14727310 16056266 16619892 16902043
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
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
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/oracle/app/11.2.0.3/gi')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying sub-patch '13343438' to OH '/oracle/app/11.2.0.3/gi'
Patching component oracle.rdbms.rsf, 11.2.0.3.0...
Patching component oracle.rdbms, 11.2.0.3.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...
Verifying the update...
Applying sub-patch '13696216' to OH '/oracle/app/11.2.0.3/gi'
ApplySession: Optional component(s) [ oracle.sysman.console.db, 11.2.0.3.0 ] , [ oracle.sysman.oms.core, 10.2.0.4.4 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.rdbms.rsf, 11.2.0.3.0...
Patching component oracle.rdbms, 11.2.0.3.0...
Patching component oracle.sdo.locator, 11.2.0.3.0...
Verifying the update...
Applying sub-patch '13923374' to OH '/oracle/app/11.2.0.3/gi'
ApplySession: Optional component(s) [ oracle.sysman.console.db, 11.2.0.3.0 ] , [ oracle.network.cman, 11.2.0.3.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.rdbms.rsf, 11.2.0.3.0...
Patching component oracle.rdbms, 11.2.0.3.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...
Patching component oracle.network.rsf, 11.2.0.3.0...
Patching component oracle.network.listener, 11.2.0.3.0...
Verifying the update...
Applying sub-patch '14275605' to OH '/oracle/app/11.2.0.3/gi'
ApplySession: Optional component(s) [ oracle.precomp.common, 11.2.0.3.0 ] , [ oracle.precomp.lang, 11.2.0.3.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.network.client, 11.2.0.3.0...
Patching component oracle.network.rsf, 11.2.0.3.0...
Patching component oracle.rdbms, 11.2.0.3.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...
Patching component oracle.rdbms.rman, 11.2.0.3.0...
Patching component oracle.rdbms.rsf, 11.2.0.3.0...
Patching component oracle.rdbms.util, 11.2.0.3.0...
Verifying the update...
Applying sub-patch '14727310' to OH '/oracle/app/11.2.0.3/gi'
ApplySession: Optional component(s) [ oracle.sysman.console.db, 11.2.0.3.0 ] , [ oracle.sysman.oms.core, 10.2.0.4.4 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.rdbms, 11.2.0.3.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...
Patching component oracle.rdbms.rsf, 11.2.0.3.0...
Patching component oracle.sdo.locator, 11.2.0.3.0...
Verifying the update...
Applying sub-patch '16056266' to OH '/oracle/app/11.2.0.3/gi'
ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.3.0 ] , [ oracle.ovm, 11.2.0.3.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.network.listener, 11.2.0.3.0...
Patching component oracle.network.rsf, 11.2.0.3.0...
Patching component oracle.rdbms, 11.2.0.3.0...
Patching component oracle.rdbms.rman, 11.2.0.3.0...
Patching component oracle.rdbms.rsf, 11.2.0.3.0...
Patching component oracle.sdo.locator, 11.2.0.3.0...
Patching component oracle.rdbms.deconfig, 11.2.0.3.0...
Verifying the update...
Applying sub-patch '16619892' to OH '/oracle/app/11.2.0.3/gi'
ApplySession: Optional component(s) [ oracle.marvel, 11.2.0.3.0 ] , [ oracle.precomp.common, 11.2.0.3.0 ] , [ oracle.precomp.lang, 11.2.0.3.0 ] , [ oracle.sysman.agent, 10.2.0.4.3 ] , [ oracle.sysman.console.db, 11.2.0.3.0 ] , [ oracle.sysman.repository.core, 10.2.0.4.4 ] , [ oracle.xdk, 11.2.0.3.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.rdbms, 11.2.0.3.0...
Patching component oracle.rdbms.rman, 11.2.0.3.0...
Patching component oracle.rdbms.rsf, 11.2.0.3.0...
Patching component oracle.xdk.parser.java, 11.2.0.3.0...
Patching component oracle.xdk.rsf, 11.2.0.3.0...
Verifying the update...
Applying sub-patch '16902043' to OH '/oracle/app/11.2.0.3/gi'
ApplySession: Optional component(s) [ oracle.idm.oid, 11.2.0.3.0 ] , [ oracle.owb.rsf, 11.2.0.3.0 ] , [ oracle.sysman.console.db, 11.2.0.3.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.ldap.rsf, 11.2.0.3.0...
Patching component oracle.ldap.rsf.ic, 11.2.0.3.0...
Patching component oracle.rdbms, 11.2.0.3.0...
Patching component oracle.rdbms.rsf, 11.2.0.3.0...
Verifying the update...
Composite patch 16902043 successfully applied.
Log file location: /oracle/app/11.2.0.3/gi/cfgtoollogs/opatch/opatch2014-03-02_13-31-47PM_1.log
OPatch succeeded.
[grid@ossoipltedb7 OPatch]$
[grid@ossoipltedb7 OPatch]$ ./opatch napply -oh /oracle/app/11.2.0.3/gi -local /oracle/install/psu/17076717
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/app/11.2.0.3/gi
Central Inventory : /oracle/app/oraInventory
from : /oracle/app/11.2.0.3/gi/oraInst.loc
OPatch version : 11.2.0.3.6
OUI version : 11.2.0.3.0
Log file location : /oracle/app/11.2.0.3/gi/cfgtoollogs/opatch/opatch2014-03-02_13-37-46PM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 17076717
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
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
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/oracle/app/11.2.0.3/gi')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '17076717' to OH '/oracle/app/11.2.0.3/gi'
Patching component oracle.crs, 11.2.0.3.0...
Patching component oracle.usm, 11.2.0.3.0...
Verifying the update...
Patch 17076717 successfully applied.
Log file location: /oracle/app/11.2.0.3/gi/cfgtoollogs/opatch/opatch2014-03-02_13-37-46PM_1.log
OPatch succeeded.
node2如上1相似：
$ opatch napply -oh /oracle/app/11.2.0.3/gi -local /oracle/install/psu/16902043
$ opatch napply -oh /oracle/app/11.2.0.3/gi -local /oracle/install/psu/17076717
2 patch rac database：
node1:
[oracle@ossoipltedb7 OPatch]$ ./opatch napply -oh /oracle/product/11.2.0.3/db_1 -local /oracle/install/psu/17076717/custom/server/17076717
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/product/11.2.0.3/db_1
Central Inventory : /oracle/app/oraInventory
from : /oracle/product/11.2.0.3/db_1/oraInst.loc
OPatch version : 11.2.0.3.6
OUI version : 11.2.0.3.0
Log file location : /oracle/product/11.2.0.3/db_1/cfgtoollogs/opatch/opatch2014-03-02_14-10-25PM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 17076717
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
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
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/oracle/product/11.2.0.3/db_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '17076717' to OH '/oracle/product/11.2.0.3/db_1'
Patching component oracle.rdbms, 11.2.0.3.0...
Verifying the update...
Patch 17076717 successfully applied.
Log file location: /oracle/product/11.2.0.3/db_1/cfgtoollogs/opatch/opatch2014-03-02_14-10-25PM_1.log
OPatch succeeded.
[oracle@ossoipltedb7 OPatch]$ ./opatch napply -oh /oracle/product/11.2.0.3/db_1 -local /oracle/install/psu/16902043
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/product/11.2.0.3/db_1
Central Inventory : /oracle/app/oraInventory
from : /oracle/product/11.2.0.3/db_1/oraInst.loc
OPatch version : 11.2.0.3.6
OUI version : 11.2.0.3.0
Log file location : /oracle/product/11.2.0.3/db_1/cfgtoollogs/opatch/opatch2014-03-02_14-11-22PM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 13343438 13696216 13923374 14275605 14727310 16056266 16619892 16902043
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
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
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/oracle/product/11.2.0.3/db_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying sub-patch '13343438' to OH '/oracle/product/11.2.0.3/db_1'
Patching component oracle.rdbms.rsf, 11.2.0.3.0...
Patching component oracle.rdbms, 11.2.0.3.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...
Verifying the update...
Applying sub-patch '13696216' to OH '/oracle/product/11.2.0.3/db_1'
Patching component oracle.rdbms.rsf, 11.2.0.3.0...
Patching component oracle.rdbms, 11.2.0.3.0...
Patching component oracle.sdo.locator, 11.2.0.3.0...
Patching component oracle.sysman.console.db, 11.2.0.3.0...
Patching component oracle.sysman.oms.core, 10.2.0.4.4...
Verifying the update...
Applying sub-patch '13923374' to OH '/oracle/product/11.2.0.3/db_1'
ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.3.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.rdbms.rsf, 11.2.0.3.0...
Patching component oracle.rdbms, 11.2.0.3.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...
Patching component oracle.network.rsf, 11.2.0.3.0...
Patching component oracle.network.listener, 11.2.0.3.0...
Patching component oracle.sysman.console.db, 11.2.0.3.0...
Verifying the update...
Applying sub-patch '14275605' to OH '/oracle/product/11.2.0.3/db_1'
ApplySession: Optional component(s) [ oracle.precomp.lang, 11.2.0.3.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.network.client, 11.2.0.3.0...
Patching component oracle.network.rsf, 11.2.0.3.0...
Patching component oracle.precomp.common, 11.2.0.3.0...
Patching component oracle.rdbms, 11.2.0.3.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...
Patching component oracle.rdbms.rman, 11.2.0.3.0...
Patching component oracle.rdbms.rsf, 11.2.0.3.0...
Patching component oracle.rdbms.util, 11.2.0.3.0...
Verifying the update...
Applying sub-patch '14727310' to OH '/oracle/product/11.2.0.3/db_1'
Patching component oracle.rdbms, 11.2.0.3.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...
Patching component oracle.rdbms.rsf, 11.2.0.3.0...
Patching component oracle.sdo.locator, 11.2.0.3.0...
Patching component oracle.sysman.console.db, 11.2.0.3.0...
Patching component oracle.sysman.oms.core, 10.2.0.4.4...
Verifying the update...
Applying sub-patch '16056266' to OH '/oracle/product/11.2.0.3/db_1'
ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.3.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.network.listener, 11.2.0.3.0...
Patching component oracle.network.rsf, 11.2.0.3.0...
Patching component oracle.ovm, 11.2.0.3.0...
Patching component oracle.rdbms, 11.2.0.3.0...
Patching component oracle.rdbms.rman, 11.2.0.3.0...
Patching component oracle.rdbms.rsf, 11.2.0.3.0...
Patching component oracle.sdo.locator, 11.2.0.3.0...
Patching component oracle.rdbms.deconfig, 11.2.0.3.0...
Verifying the update...
Applying sub-patch '16619892' to OH '/oracle/product/11.2.0.3/db_1'
ApplySession: Optional component(s) [ oracle.precomp.lang, 11.2.0.3.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.marvel, 11.2.0.3.0...
Patching component oracle.precomp.common, 11.2.0.3.0...
Patching component oracle.rdbms, 11.2.0.3.0...
Patching component oracle.rdbms.rman, 11.2.0.3.0...
Patching component oracle.rdbms.rsf, 11.2.0.3.0...
Patching component oracle.sysman.agent, 10.2.0.4.3...
Patching component oracle.sysman.console.db, 11.2.0.3.0...
Patching component oracle.sysman.repository.core, 10.2.0.4.4...
Patching component oracle.xdk, 11.2.0.3.0...
Patching component oracle.xdk.parser.java, 11.2.0.3.0...
Patching component oracle.xdk.rsf, 11.2.0.3.0...
Verifying the update...
Applying sub-patch '16902043' to OH '/oracle/product/11.2.0.3/db_1'
ApplySession: Optional component(s) [ oracle.idm.oid, 11.2.0.3.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.ldap.rsf, 11.2.0.3.0...
Patching component oracle.ldap.rsf.ic, 11.2.0.3.0...
Patching component oracle.owb.rsf, 11.2.0.3.0...
Patching component oracle.rdbms, 11.2.0.3.0...
Patching component oracle.rdbms.rsf, 11.2.0.3.0...
Patching component oracle.sysman.console.db, 11.2.0.3.0...
Verifying the update...
OPatch found the word "warning" in the stderr of the make command.
Please look at this stderr. You can re-run this make command.
Stderr output:
ins_precomp.mk:19: warning: overriding commands for target `pcscfg.cfg'
/oracle/product/11.2.0.3/db_1/precomp/lib/env_precomp.mk:2160: warning: ignoring old commands for target `pcscfg.cfg'
/oracle/product/11.2.0.3/db_1/precomp/lib/ins_precomp.mk:19: warning: overriding commands for target `pcscfg.cfg'
/oracle/product/11.2.0.3/db_1/precomp/lib/env_precomp.mk:2160: warning: ignoring old commands for target `pcscfg.cfg'
OPatch found the word "warning" in the stderr of the make command.
Please look at this stderr. You can re-run this make command.
Stderr output:
ins_emagent.mk:113: warning: overriding commands for target `nmosudo'
ins_emagent.mk:52: warning: ignoring old commands for target `nmosudo'
/oracle/product/11.2.0.3/db_1/sysman/lib/ins_emagent.mk:113: warning: overriding commands for target `nmosudo'
/oracle/product/11.2.0.3/db_1/sysman/lib/ins_emagent.mk:52: warning: ignoring old commands for target `nmosudo'
Composite patch 16902043 successfully applied.
OPatch Session completed with warnings.
Log file location: /oracle/product/11.2.0.3/db_1/cfgtoollogs/opatch/opatch2014-03-02_14-11-22PM_1.log
OPatch completed with warnings.
[oracle@ossoipltedb7 OPatch]$ /oracle/install/psu/17076717/custom/scripts/postpatch.sh -dbhome /oracle/product/11.2.0.3/db_1
Reading /oracle/product/11.2.0.3/db_1/install/params.ora..
Reading /oracle/product/11.2.0.3/db_1/install/params.ora..
Parsing file /oracle/product/11.2.0.3/db_1/bin/racgwrap
Parsing file /oracle/product/11.2.0.3/db_1/bin/srvctl
Parsing file /oracle/product/11.2.0.3/db_1/bin/srvconfig
Parsing file /oracle/product/11.2.0.3/db_1/bin/cluvfy
Verifying file /oracle/product/11.2.0.3/db_1/bin/racgwrap
Verifying file /oracle/product/11.2.0.3/db_1/bin/srvctl
Verifying file /oracle/product/11.2.0.3/db_1/bin/srvconfig
Verifying file /oracle/product/11.2.0.3/db_1/bin/cluvfy
Reapplying file permissions on /oracle/product/11.2.0.3/db_1/bin/racgwrap
Reapplying file permissions on /oracle/product/11.2.0.3/db_1/bin/srvctl
Reapplying file permissions on /oracle/product/11.2.0.3/db_1/bin/srvconfig
Reapplying file permissions on /oracle/product/11.2.0.3/db_1/bin/cluvfy
Reapplying file permissions on /oracle/product/11.2.0.3/db_1/bin/diskmon.bin
Reapplying file permissions on /oracle/product/11.2.0.3/db_1/bin/lsnodes
Reapplying file permissions on /oracle/product/11.2.0.3/db_1/bin/osdbagrp
Reapplying file permissions on /oracle/product/11.2.0.3/db_1/bin/rawutl
Reapplying file permissions on /oracle/product/11.2.0.3/db_1/srvm/admin/ractrans
Reapplying file permissions on /oracle/product/11.2.0.3/db_1/srvm/admin/getcrshome
Reapplying file permissions on /oracle/product/11.2.0.3/db_1/bin/gnsd
Reapplying file permissions on /oracle/product/11.2.0.3/db_1/bin/crsdiag.pl
Reapplying file permissions on /oracle/product/11.2.0.3/db_1/lib/libhasgen11.so
Reapplying file permissions on /oracle/product/11.2.0.3/db_1/lib/libclsra11.so
Reapplying file permissions on /oracle/product/11.2.0.3/db_1/lib/libdbcfg11.so
Reapplying file permissions on /oracle/product/11.2.0.3/db_1/lib/libocr11.so
Reapplying file permissions on /oracle/product/11.2.0.3/db_1/lib/libocrb11.so
Reapplying file permissions on /oracle/product/11.2.0.3/db_1/lib/libocrutl11.so
Reapplying file permissions on /oracle/product/11.2.0.3/db_1/lib/libuini11.so
Reapplying file permissions on /oracle/product/11.2.0.3/db_1/lib/librdjni11.so
Reapplying file permissions on /oracle/product/11.2.0.3/db_1/lib/libgns11.so
Reapplying file permissions on /oracle/product/11.2.0.3/db_1/lib/libgnsjni11.so
Reapplying file permissions on /oracle/product/11.2.0.3/db_1/lib/liba**11.so
3. 將打好補丁的節點重新啟動，加入叢集然後進行檢查：
使用root使用者進行以下操作
# /oracle/11.2.0.3/gi/rdbms/install/rootadd_rdbms.sh
# /oracle/app/11.2.0.3/gi/crs/install/rootcrs.pl -patch
[root@ossoipltedb7 gi]# /oracle/app/11.2.0.3/gi/rdbms/install/rootadd_rdbms.sh
[root@ossoipltedb7 gi]# /oracle/app/11.2.0.3/gi/crs/install/rootcrs.pl -patch
Using configuration parameter file: /oracle/app/11.2.0.3/gi/crs/install/crsconfig_params
CRS-4123: Oracle High Availability Services has been started.
[grid@ossoipltedb7 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....ER.lsnr ora....er.type ONLINE ONLINE osso...edb7
ora....N1.lsnr ora....er.type ONLINE ONLINE osso...edb7
ora.OCR.dg ora....up.type ONLINE ONLINE osso...edb7
ora.asm ora.asm.type ONLINE ONLINE osso...edb7
ora.cvu ora.cvu.type ONLINE ONLINE osso...edb7
ora.gsd ora.gsd.type OFFLINE OFFLINE
ora....network ora....rk.type ONLINE ONLINE osso...edb7
ora.oc4j ora.oc4j.type ONLINE ONLINE osso...edb8
ora.ons ora.ons.type ONLINE ONLINE osso...edb7
ora....SM1.asm application ONLINE ONLINE osso...edb7
ora....B7.lsnr application ONLINE ONLINE osso...edb7
ora....db7.gsd application OFFLINE OFFLINE
ora....db7.ons application ONLINE ONLINE osso...edb7
ora....db7.vip ora....t1.type ONLINE ONLINE osso...edb7
ora....SM2.asm application ONLINE ONLINE osso...edb8
ora....B8.lsnr application ONLINE ONLINE osso...edb8
ora....db8.gsd application OFFLINE OFFLINE
ora....db8.ons application ONLINE ONLINE osso...edb8
ora....db8.vip ora....t1.type ONLINE ONLINE osso...edb8
ora.scan1.vip ora....ip.type ONLINE ONLINE osso...edb7
[oracle@ossoipltedb7 OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation. All rights reserved.
Oracle Home : /oracle/product/11.2.0.3/db_1
Central Inventory : /oracle/app/oraInventory
from : /oracle/product/11.2.0.3/db_1/oraInst.loc
OPatch version : 11.2.0.3.6
OUI version : 11.2.0.3.0
Log file location : /oracle/product/11.2.0.3/db_1/cfgtoollogs/opatch/opatch2014-03-02_14-58-00PM_1.log
Lsinventory Output file location : /oracle/product/11.2.0.3/db_1/cfgtoollogs/opatch/lsinv/lsinventory2014-03-02_14-58-00PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 11g 11.2.0.3.0
There are 1 product(s) installed in this Oracle Home.
Interim patches (2) :
Patch 16902043 : applied on Sun Mar 02 14:19:24 CST 2014
Unique Patch ID: 16676143
Patch description: "Database Patch Set Update : 11.2.0.3.8 (16902043)"
Created on 24 Sep 2013, 23:20:58 hrs PST8PDT
Sub-patch 16619892; "Database Patch Set Update : 11.2.0.3.7 (16619892)"
Sub-patch 16056266; "Database Patch Set Update : 11.2.0.3.6 (16056266)"
Sub-patch 14727310; "Database Patch Set Update : 11.2.0.3.5 (14727310)"
Sub-patch 14275605; "Database Patch Set Update : 11.2.0.3.4 (14275605)"
Sub-patch 13923374; "Database Patch Set Update : 11.2.0.3.3 (13923374)"
Sub-patch 13696216; "Database Patch Set Update : 11.2.0.3.2 (13696216)"
Sub-patch 13343438; "Database Patch Set Update : 11.2.0.3.1 (13343438)"
Bugs fixed:
13593999, 13566938, 10350832, 14138130, 12919564, 14198511, 13561951
13624984, 13588248, 16024441, 13080778, 17333199, 13914613, 13804294
16710324, 14258925, 12873183, 14755945, 13645875, 14472647, 12880299
14664355, 12998795, 14409183, 13719081, 14469008, 13492735, 13496884
12857027, 14263036, 13015379, 14263073, 14188650, 13742433, 13732226
16368108, 16314469, 12905058, 6690853, 13742434, 16212405, 12849688
12950644, 13742435, 13464002, 12899768, 12879027, 13063120, 13534412
13958038, 14613900, 12585543, 12535346, 13790109, 16382448, 12588744
13972394, 11877623, 13072654, 12395918, 13786142, 13814739, 12847466
13649031, 13855490, 13981051, 12582664, 12797765, 17333200, 14262913
17332800, 12923168, 14695377, 13384182, 12912137, 16279401, 13612575
13466801, 13484963, 14207163, 13724193, 13642044, 13772618, 11063191
16694777, 13945708, 13070939, 12797420, 12865902, 13041324, 15869211
13605839, 14003090, 16314467, 16279211, 16314468, 12976376, 12755231
11708510, 13680405, 13742437, 14589750, 13026410, 13737746, 11868640
13742438, 14644185, 13326736, 15841373, 15910002, 13596521, 16362358
14398795, 13001379, 13579992, 16344871, 13099577, 9873405, 13742436
14275605, 9858539, 16372203, 14841812, 16344758, 11715084, 9547706
16231699, 14040433, 9703627, 12662040, 12617123, 16530565, 13483354
14393728, 14207317, 12845115, 12764337, 13354082, 16902043, 14459552
13397104, 14191508, 13913630, 12964067, 12983611, 13550185, 12780983
13810393, 12583611, 14546575, 15862016, 13476583, 13489024, 11840910
13903046, 15862017, 13572659, 16294378, 13718279, 13657605, 14088346
13448206, 16314466, 13419660, 14480676, 13632717, 14668670, 14063281
14110275, 13430938, 13467683, 13420224, 13812031, 14548763, 12646784
16299830, 14512189, 12755116, 17230530, 13616375, 14035825, 13427062
12861463, 12834027, 13092220, 15862021, 13632809, 13377816, 13036331
14727310, 16619892, 13685544, 13499128, 15862018, 16175381, 13584130
12829021, 15862019, 12794305, 14546673, 12791981, 13561750, 13503598
13787482, 10133521, 12744759, 12718090, 13848402, 13399435, 14762511
14023636, 9095696, 13725395, 12401111, 13860201, 12796518, 13257247
13362079, 14176879, 12917230, 13923374, 16014985, 14220725, 12621588
12312133, 13524899, 14480675, 16306019, 13559697, 9706792, 12974860
12940620, 14751895, 14480674, 13916709, 13098318, 14076523, 13773133
16794244, 15905421, 13340388, 13528551, 13366202, 12731940, 12894807
12747437, 13343438, 13454210, 12748240, 14205448, 13385346, 17082364
14127231, 15853081, 14273397, 14467061, 12971775, 13923995, 13582702
14571027, 12784406, 13907462, 12748538, 10242202, 13493847, 13035804
13857111, 16710363, 13544396, 14128555, 13686047, 16382353, 8547978
14226599, 17333203, 14095982, 13591624, 17333197, 14523004, 13440516
9397635, 14007968, 16794241, 13035360, 14062795, 12693626, 12925089
14189694, 12815057, 13332439, 14038787, 13040943, 11071989, 13843646
14062796, 16794243, 12913474, 14841409, 14390252, 13370330, 16314470
14062797, 13059165, 14062794, 12959852, 12345082, 13358781, 17333202
12960925, 16703112, 9659614, 14546638, 13699124, 13936424, 17333198
16794240, 14301592, 13338048, 12938841, 12658411, 12620823, 12656535
14062793, 12678920, 13038684, 14791477, 14062792, 13807411, 16742095
16794238, 15862022, 12594032, 13250244, 12612118, 9761357, 14053457
13742464, 14052474, 13060271, 13911821, 13457582, 13527323, 7509451
13791364, 15862020, 13910420, 12821418, 12780098, 13502183, 13696216
13705338, 14841558, 10263668, 16794242, 15862023, 16056266, 13834065
14351566, 13723052, 16794239, 13554409, 15862024, 13103913, 13645917
14063280, 12772404, 13011409
Patch 17076717 : applied on Sun Mar 02 14:10:48 CST 2014
Unique Patch ID: 16721032
Patch description: "Grid Infrastructure Patch Set Update : 11.2.0.3.8 (HAS Components)"
Created on 11 Oct 2013, 02:52:50 hrs PST8PDT
Bugs fixed:
17076717, 16619898, 16315641, 15876003, 14275572, 13919095, 13696251
13348650, 12659561, 14305980, 14277586, 13987807, 14625969, 13825231
12794268, 13000491, 13498267, 15934834, 11675721, 14082976, 12771830
14515980, 14085018, 13943175, 14102704, 14171552, 12594616, 13879428
12897902, 12726222, 12829429, 13079948, 13090686, 12995950, 13251796
13582411, 14651272, 12903592, 12990582, 13857364, 15856610, 13082238
16446410, 12947871, 13256955, 13037709, 14535011, 12878750, 16560359
14048512, 11772838, 13058611, 13001955, 13440962, 13727853, 13425727
12885323, 12870400, 14212634, 14407395, 13332363, 14761411, 13430626
14456069, 13811209, 12709476, 14168708, 14096821, 14626717, 13460353
13694885, 12857064, 12899169, 13111013, 12558569, 13323698, 16547309
10260842, 16613232, 13085732, 16555186, 14332688, 10317921, 16077216
13869978, 12914824, 13789135, 12730342, 12950823, 13355963, 13531373
14268365, 13776758, 12720728, 13620816, 14628188, 13023609, 15874565
16578706, 16735171, 13024624, 13039908, 14525998, 15911134, 13036424
13938166, 15907617, 13011520, 13569812, 12758736, 13001901, 13077654
13430715, 13550689, 13251609, 13806545, 13634583, 14271305, 12538907
13947200, 12996428, 13066371, 13483672, 13936066, 12897651, 13540563
12896850, 13241779, 12728585, 12876314, 12925041, 12650672, 12398492
12848480, 13088512, 13652088, 16307750, 12917897, 12975811, 13653178
17247404, 13371153, 14800989, 16684285, 10114953, 14001941, 11836951
14179376, 12965049, 14773530, 12765467, 12950415, 15998768, 13339443
13965075, 16210540, 14307855, 12784559, 14242977, 13955385, 12704789
13745317, 13074261, 12971251, 13993634, 13523527, 13719731, 13396284
12639013, 12867511, 13989181, 12959140, 16836877, 14748254, 13912274
12829917, 12349553, 12849377, 12934171, 13843080, 14496536, 13899736
13924431, 12680491, 13334158, 10418841, 12832204, 13838047, 13002015
14639430, 11822565, 15920201, 12791719
Rac system comprising of multiple nodes
Local node = ossoipltedb7
Remote node = ossoipltedb8
--------------------------------------------------------------------------------
OPatch succeeded.
[oracle@ossoipltedb7 OPatch]$
整理步驟如下：
1. 關閉操作節點的叢集服務
使用root登入，執行以下操作
# /oracle/11.2.0/gi/crs/install/rootcrs.pl -unlock
/oracle/app/11.2.0.3/gi/crs/install/rootcrs.pl -unlock
使用root登入，執行以下操作
# cd $gi_HOME
# tar -cvf OPatch.tar OPatch
# mv OPatch OPatch.bak
# unzip p6880880_112000_Linux-x86-64.zip
# chown -R grid:oinstall OPatch
# su - grid
# opatch version
打gi叢集件補丁
# su - grid
$ opatch napply -oh /oracle/app/11.2.0.3/gi -local /oracle/install/psu/16902043
$ opatch napply -oh /oracle/app/11.2.0.3/gi -local /oracle/install/psu/17076717
打oracle資料庫補丁
替換oracle使用者的OPatch
使用oracle登入，執行以下操作
$ su - oracle
# cd $ORACLE_HOME
# tar -cvf OPatch.tar OPatch
# mv OPatch OPatch.bak
# unzip p6880880_112000_Linux-x86-64.zip
# opatch version
$ /oracle/install/psu/17076717/custom/scripts/prepatch.sh -dbhome /oracle/product/11.2.0/db_1
$ opatch napply -oh /oracle/product/11.2.0.3/db_1 -local /oracle/install/psu/17076717/custom/server/17076717
$ opatch napply -oh /oracle/product/11.2.0.3/db_1 -local /oracle/install/psu/16902043
$ /oracle/install/psu/17076717/custom/scripts/postpatch.sh -dbhome /oracle/product/11.2.0.3/db_1
3. 將打好補丁的節點重新啟動，加入叢集
使用root使用者進行以下操作
# /oracle/app/11.2.0.3/gi/rdbms/install/rootadd_rdbms.sh
# /oracle/app/11.2.0.3/gi/crs/install/rootcrs.pl -patch
參考aix補丁:
psu8====================
0、兩個節點上psu8都要有（這步統一解壓到/oracle/install/psu8）；opatch兩邊的oracle和grid使用者都要更新
1、所以還要以grid使用者到兩個節點的對應目錄下去生成 OCM response file
[grid@rac121 OPatch]$ $ORACLE_HOME/OPatch/ocm/bin/emocmrsp
2和3步驟用root在兩個節點下
2、打grid補丁
/oracle/app/oracle/product/11.2.0.3/dbhome_1/OPatch/opatch auto /oracle/install/psu8 -ocmrf /home/grid/ocm.rsp
3、打database補丁
/oracle/app/oracle/product/11.2.0.3/dbhome_1/OPatch/opatch auto /oracle/install/psu8 -oh /oracle/app/oracle/product/11.2.0.3/dbhome_1 -ocmrf /home/grid/ocm.rsp
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/13750068/viewspace-1098086/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- Apply PSU for Grid Infrastructure Standalone and DB with Oracle RestartAPPASTStructOracleREST
- 【RAC】11gR2 新特性： Rebootless RestartbootREST
- oracle_如何打11GR2 RAC PSU補丁Oracle
- Oracle 11gR2 New Features Oracle RestartOracleREST
- Oracle 11G PSU 31326410 PSU apply failed 處理-拾億OracleAPPAI
- Linux 11g rac PSULinux
- 安裝PSU後一定要執行catbundle.sql psu apply指令碼嗎SQLAPP指令碼
- 【Oracle】RAC 11.2.0.4.0 PSU 11.2.0.4.170418Oracle
- 安裝11gr2 RAC
- 11gR2 RAC修改IP
- 11gR2 RAC ASM 啟動ASM
- oracle 11gr2 rac 安裝Oracle
- Oracle 11.2.0.4 RAC安裝最新PSU補丁Oracle
- 【RAC安裝】 AIX下安裝Oracle 11gR2 RACAIOracle
- Oracle 11gR2 RAC修改SCAN IPOracle
- 11gr2 rac 基本管理命令（一）
- 11gr2 rac常用命令
- rac one node、Single Instance HA(SIHA)、Oracle Restart的概念OracleREST
- 【RAC】Diskgroup shows offline after restart even it is mounted in ASM instanceRESTASM
- 【RAC】11gR2 rac 上滾動安裝/回退補丁
- Oracle 11g RAC自動打GI PSU補丁Oracle
- AIX7.1下oracle RAC PSU 11.2.0.4.8 Patch 失敗AIOracle
- Oracle 11.2.0.4 RAC psu補丁升級至11.2.0.4.2Oracle
- Oracle RAC 11gR2開啟歸檔Oracle
- How to create and relocate an 11gr2 RAC DATABASE SERVICEDatabase
- Oracle 11gR2 RAC ORA-00845Oracle
- Oracle 11gR2 RAC修改SCAN IP地址Oracle
- How to modify Public ip and vip In 11gr2 Rac
- Oracle 11gR2 RAC 常用維護操作Oracle
- 11gR2 RAC ASM啟動過程ASM
- update restartREST
- Step By Step of Configuring Oracle 11gR2 (11.2.0.1) RAC to RAC DataguardOracle
- 11gr2 RAC配置Service-Side TAFIDE
- 11Gr2 RAC udev ASM openfiler(安裝文件)devASM
- Oracle 11gR2 RAC的JDBC連線串OracleJDBC
- 11gR2 RAC 使用infiniband 支援AIX 不力AI
- oracle 11gR2 RAC crsctl 命令的增強Oracle
- 筆記本搭建11gR2 RAC環境筆記