Oracle 10g RAC打补丁p13343471

–查看当前补丁情况 [Oracle@rac1 OPatch]$ pwd /opt/ora10g/product/database/OPatch [Oracle@rac1 OPatch]$ ./opatch lsinventory Invoking OPatch 10.2.0.4.9 Oracle Interim Patch Installer version 10.2.0.4.9- Copyright (c) 2009, Oracle Corporation

–查看当前补丁情况
[Oracle@rac1 OPatch]$ pwd
/opt/ora10g/product/database/OPatch
[Oracle@rac1 OPatch]$ ./opatch lsinventory
Invoking OPatch 10.2.0.4.9
Oracle Interim Patch Installer version 10.2.0.4.9-

Copyright (c) 2009, Oracle Corporation.  All rights reserved.
Oracle Home       : /opt/ora10g/product/database
Central Inventory : /opt/ora10g/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 10.2.0.4.9
OUI version       : 10.2.0.5.0
OUI location      : /opt/ora10g/product/database/oui
Log file location : /opt/ora10g/product/database/cfgtoollogs/opatch/opatch2012-09-13_23-19-14PM.log
Patch history file: /opt/ora10g/product/database/cfgtoollogs/opatch/opatch_history.txt
Lsinventory Output file location : /opt/ora10g/product/database/cfgtoollogs/opatch/lsinv/lsinventory2012-09-13_23-19-14PM.txt
——————————————————————————–
Installed Top-level Products (2):
Oracle Database 10g                                                  10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 4                           10.2.0.5.0a
There are 2 products installed in this Oracle Home.
Interim patches (1) :
Patch  12880299     : applied on Wed Sep 12 01:15:39 CST 2012
Unique Patch ID:  14803344
   Created on 3 May 2012, 20:16:10 hrs PST8PDT
   Bugs fixed:
     12880299
Rac system comprising of multiple nodes
  Local node = rac1
  Remote node = rac2
——————————————————————————–
OPatch succeeded.
–apply patch
[Oracle@rac1 OPatch]$ cd /tmp/13343471/
[Oracle@rac1 13343471]$ pwd
/tmp/13343471
[Oracle@rac1 13343471]$ /opt/ora10g/product/database/OPatch/opatch apply
Invoking OPatch 10.2.0.4.9
Oracle Interim Patch Installer version 10.2.0.4.9
Copyright (c) 2009, Oracle Corporation.  All rights reserved.
Oracle Home       : /opt/ora10g/product/database
Central Inventory : /opt/ora10g/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 10.2.0.4.9
OUI version       : 10.2.0.5.0
OUI location      : /opt/ora10g/product/database/oui
Log file location : /opt/ora10g/product/database/cfgtoollogs/opatch/opatch2012-09-13_23-21-41PM.log
Patch history file: /opt/ora10g/product/database/cfgtoollogs/opatch/opatch_history.txt
ApplySession applying interim patch ‘13343471’ to OH ‘/opt/ora10g/product/database’
ApplySession failed: ApplySession failed to prepare the system.
Patch 13343471 requires OPatch version 10.2.0.5.0.
The OPatch version being used (10.2.0.4.9) doesn’t meet the minimum version required by the patch(es). Please download latest OPatch from My Oracle Support.
System intact, OPatch will not attempt to restore the system
OPatch failed with error code 73
[Oracle@rac1 13343471]$ /opt/ora10g/product/database/OPatch/opatch version
Invoking OPatch 10.2.0.4.9
OPatch Version: 10.2.0.4.9
OPatch succeeded.
–升级OPatch
[Oracle@rac1 OPatch]$ ./opatch version
Invoking OPatch 10.2.0.5.1
OPatch Version: 10.2.0.5.1
OPatch succeeded.
–再次apply patch
–注:停止所有节点的资源和CRS(很奇怪，不停止所有节点的CRS的话，在打补丁的期间，当前节点会自动重启，很奇怪啊啊啊~)
[Oracle@rac1 13343471]$ pwd
/tmp/13343471
[Oracle@rac1 13343471]$ /opt/ora10g/product/database/OPatch/opatch apply
Invoking OPatch 10.2.0.5.1
Oracle Interim Patch Installer version 10.2.0.5.1
Copyright (c) 2010, Oracle Corporation.  All rights reserved.
Oracle Home       : /opt/ora10g/product/database
Central Inventory : /opt/ora10g/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 10.2.0.5.1
OUI version       : 10.2.0.5.0
OUI location      : /opt/ora10g/product/database/oui
Log file location : /opt/ora10g/product/database/cfgtoollogs/opatch/opatch2012-09-14_00-01-54AM.log
Patch history file: /opt/ora10g/product/database/cfgtoollogs/opatch/opatch_history.txt
ApplySession applying interim patch ‘13343471’ to OH ‘/opt/ora10g/product/database’
Running prerequisite checks…
Patch 13343471: Optional component(s) missing : [ Oracle.rdbms.dv, 10.2.0.5.0 ] , [ oracle.rdbms.dv.oc4j, 10.2.0.5.0 ] , [ oracle.network.cman, 10.2.0.5.0 ]
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
OPatch detected the node list and the local node from the inventory.  OPatch will patch the local system then propagate the patch to the remote nodes.
This node is part of an Oracle Real Application Cluster.
Remote nodes: ‘rac2’
Local node: ‘rac1’
elease shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = ‘/opt/ora10g/product/database’)
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch ‘13343471’ for restore. This might take a while…
Backing up files affected by the patch ‘13343471’ for rollback. This might take a while…
Execution of ‘sh /tmp/13343471/custom/scripts/pre -apply 13343471 ‘:
Return Code = 0
Patching component Oracle.rdbms, 10.2.0.5.0…
… …
Patching in rolling mode.
The node ‘rac2’ will be patched next.
Please shutdown Oracle instances running out of this ORACLE_HOME on ‘rac2’.
(Oracle Home = ‘/opt/ora10g/product/database’)
Is the node ready for patching? [y|n]
y
User Responded with: Y
Updating nodes ‘rac2’
   Apply-related files are:
     FP = “/opt/ora10g/product/database/.patch_storage/13343471_Dec_20_2011_19_32_16/rac/copy_files.txt”
     DP = “/opt/ora10g/product/database/.patch_storage/13343471_Dec_20_2011_19_32_16/rac/copy_dirs.txt”
     MP = “/opt/ora10g/product/database/.patch_storage/13343471_Dec_20_2011_19_32_16/rac/make_cmds.txt”
     RC = “/opt/ora10g/product/database/.patch_storage/13343471_Dec_20_2011_19_32_16/rac/remote_cmds.txt”
Instantiating the file “/opt/ora10g/product/database/.patch_storage/13343471_Dec_20_2011_19_32_16/rac/copy_files.txt.instantiated” by replacing $Oracle_HOME in “/opt/ora10g/product/database/.patch_storage/13343471_Dec_20_2011_19_32_16/rac/copy_files.txt” with actual path.
Propagating files to remote nodes…
… …
The node ‘rac2’ has been patched.  You can restart Oracle instances on it.
There were relinks on remote nodes.  Remember to check the binary size and timestamp on the nodes ‘rac2’ .
The following make commands were invoked on remote nodes:
‘cd /opt/ora10g/product/database/rdbms/lib; /usr/bin/make -f ins_rdbms.mk client_sharedlib Oracle_HOME=/opt/ora10g/product/database
cd /opt/ora10g/product/database/rdbms/lib; /usr/bin/make -f ins_rdbms.mk iOracle ORACLE_HOME=/opt/ora10g/product/database
cd /opt/ora10g/product/database/plsql/lib; /usr/bin/make -f ins_plsql.mk iwrap Oracle_HOME=/opt/ora10g/product/database
cd /opt/ora10g/product/database/network/lib; /usr/bin/make -f ins_net_client.mk client_sharedlib Oracle_HOME=/opt/ora10g/product/database
cd /opt/ora10g/product/database/precomp/lib; /usr/bin/make -f ins_precomp.mk proc Oracle_HOME=/opt/ora10g/product/database
cd /opt/ora10g/product/database/rdbms/lib; /usr/bin/make -f ins_rdbms.mk irman Oracle_HOME=/opt/ora10g/product/database
‘
OPatch succeeded.
–查看补丁安装情况
[Oracle@rac1 ~]$ cd /opt/ora10g/product/database/OPatch
[Oracle@rac1 OPatch]$ ./opatch lsinventory
Invoking OPatch 10.2.0.5.1
Oracle Interim Patch Installer version 10.2.0.5.1
Copyright (c) 2010, Oracle Corporation.  All rights reserved.
Oracle Home       : /opt/ora10g/product/database
Central Inventory : /opt/ora10g/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 10.2.0.5.1
OUI version       : 10.2.0.5.0
OUI location      : /opt/ora10g/product/database/oui
Log file location : /opt/ora10g/product/database/cfgtoollogs/opatch/opatch2012-09-14_00-15-26AM.log
Patch history file: /opt/ora10g/product/database/cfgtoollogs/opatch/opatch_history.txt
Lsinventory Output file location : /opt/ora10g/product/database/cfgtoollogs/opatch/lsinv/lsinventory2012-09-14_00-15-26AM.txt
——————————————————————————–
Installed Top-level Products (2):
Oracle Database 10g                                                  10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 4                           10.2.0.5.0a
There are 2 products installed in this Oracle Home.
Interim patches (2) :
Patch  13343471     : applied on Fri Sep 14 00:06:40 CST 2012
Unique Patch ID:  14268542
   Created on 20 Dec 2011, 19:32:16 hrs PST8PDT
   Bugs fixed:
     6402302, 10269717, 10327190, 11693109, 8865718, 10017048, 9024850
     8394351, 8546356, 8224558, 13489660, 9360157, 9770451, 9020537, 9772888
     8650138, 8664189, 8488233, 10091698, 10092858, 12551710, 7519406
     13349665, 10132870, 8771916, 9109487, 7509714, 9171933, 10173237
     9532911, 10139235, 10159846, 10068982, 8350262, 11792865, 7119382
     7361418, 10306945, 8666117, 11724962, 11725006, 6157713, 10214450
     9184754, 8966823, 8544696, 9320130, 9767674, 9323583, 7026523, 9399589
     8277300, 9672816, 13343467, 9726739, 9499302, 8412426, 10165083, 10208905
     12419392, 6651220, 9150282, 9145204, 9659614, 9949948, 11076894, 10327179
     8882576, 7612454, 7111619, 7450366, 9711859, 11893577, 9714832, 9735237
     8970313, 6011045, 11814891, 10162036, 10248542, 9952230, 9469117, 13359623
     9952270, 9842573, 13343471, 8660422, 10324526, 11066597, 12419258
     9322219, 8636407, 9713537, 12828105, 10010310, 9390484, 9824435, 12925532
     9963497, 9032322, 12862186, 12551700, 12862187, 12551701, 10249537
     12551702, 12551703, 9586877, 8211733, 12551704, 10076669, 6694396
     9548269, 12551705, 12551706, 9337325, 12551707, 8354642, 7602341, 12551708
     9308296, 12827745, 9072105, 8528171, 10157402, 12565867, 11737047
Patch  12880299     : applied on Wed Sep 12 01:15:39 CST 2012
Unique Patch ID:  14803344
   Created on 3 May 2012, 20:16:10 hrs PST8PDT
   Bugs fixed:
     12880299
Rac system comprising of multiple nodes
  Local node = rac1
  Remote node = rac2
——————————————————————————–
OPatch succeeded.
注：安装此次补丁是希望解决我的rac节点无故重启的问题，可是在安装补丁的同时也出现重启节点的现象，很是难以理解。
不过在安装此补丁后，节点重启问题依然没有得到解决。