匿名通过本文主要向大家介绍了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_r