分类: Oracle
2008-09-10 17:30:45
Oracle 10G RAC一次打小patch的过程
版本oracle 10.2.0.4
因之前碰到一个bug,需要打个小patch上去,在此记录一下,主要说明如下:
1.在Oracle 10G RAC打patch,不需要分别在多个节点上执行,只要在一个节点上执行即可,它会提示你一个节点一个节点去停instance,然后远程应用
2.安装patch过程中也需要输入metalink帐号,这点真奇怪,难道oracle还去联网认证,但一般数据库服务器都上不了公网的,因没时间,没去进一步验证
3.最新的opatch工具也有所变化,我用的是6880880
过程记录:
第一次因运行opatch节点的instance没有停,提示失败
[oracle@dwdb2 6378112]$ opatch apply
Invoking OPatch 10.2.0.4.3
Oracle Interim Patch Installer version 10.2.0.4.3
Copyright (c) 2007, Oracle Corporation. All rights reserved.
Oracle Home : /u01/oracle/product/1020/db_1
Central Inventory : /u01/oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.4.3
OUI version : 10.2.0.4.0
OUI location : /u01/oracle/product/1020/db_1/oui
Log file location : /u01/oracle/product/1020/db_1/cfgtoollogs/opatch/opatch2008-09-10_16-55-18PM.log
ApplySession applying interim patch '6378112' to OH '/u01/oracle/product/1020/db_1'
Running prerequisite checks...
Prerequisite check "CheckActiveFilesAndExecutables" failed.
The details are:
Following executables are active :
/u01/oracle/product/1020/db_1/bin/oracle
ApplySession failed during prerequisite checks: Prerequisite check "CheckActiveFilesAndExecutables" failed.
System intact, OPatch will not attempt to restore the system
OPatch failed with error code 74
[oracle@dwdb2 6378112]$
先把本地的instance停了,就继续了...
[oracle@dwdb2 6378112]$ opatch apply
Invoking OPatch 10.2.0.4.3
Oracle Interim Patch Installer version 10.2.0.4.3
Copyright (c) 2007, Oracle Corporation. All rights reserved.
Oracle Home : /u01/oracle/product/1020/db_1
Central Inventory : /u01/oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.4.3
OUI version : 10.2.0.4.0
OUI location : /u01/oracle/product/1020/db_1/oui
Log file location : /u01/oracle/product/1020/db_1/cfgtoollogs/opatch/opatch2008-09-10_16-58-35PM.log
ApplySession applying interim patch '6378112' to OH '/u01/oracle/product/1020/db_1'
Running prerequisite checks...
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: 'dwdb1'
Local node: 'dwdb2'
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/oracle/product/1020/db_1')
Is the local system ready for patching? [y|n] 输入Y
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 '6378112' for restore. This might take a while...
***************************************************************************
Oracle Configuration Manager (OCM) is included with this release of OPatch.
***************************************************************************
Technical Support Policies and the following terms, the relevant terms below
will control your use of the Tools.
Description of Tools: What Data is Collected and How it is Stored and Used
------------
[Press enter to continue, 'q' to stop displaying the license agreement.]
还得同意license,哎
comply with its Privacy Policy in effect as services are performed, which is
available at .
[Press enter to continue, 'q' to stop displaying the license agreement.]
License
licencs还很长,按回车键继续显示
THE IMPLIED WARRANTIES OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE.
THE TOOLS ARE NOT PROGRAMS UNDER THE TERMS OF YOUR LICENSE OR DISTRIBUTION
[Press enter to continue, 'q' to stop displaying the license agreement.]
AGREEMENT(S) WITH ORACLE.
Export Compliance
-----------------
You agree that you will comply with all United States export laws and that
none of the Tools will be exported, directly or indirectly, in violation of
such laws.
Oracle Corporation
World Headquarters
500 Oracle Parkway
Redwood Shores, CA 94065
USA
Worldwide Inquiries:
Phone (+1) 650.506.7000
Fax (+1) 650.506.7200
I accept the License Agreement (Y/N) [Y]: y
最后当然是选y同意了,除非你不想装这个patch了
A MetaLink user name and password are required for you to view configuration
data reports and access valuable configuration best practices through the
Software Configuration Manager tab in MetaLink.
MetaLink User Name:
MetaLink Password:
这里要输入metalink帐号和密码,oracle你牛
OPatch has successfully configured Oracle Configuration Manager in the Oracle Home.
Please refer log file for details.
he local system has been patched. You can restart Oracle instances on it.
Patching in rolling mode.
The node 'dwdb1' will be patched next.
Please shutdown Oracle instances running out of this ORACLE_HOME on 'dwdb1'.
(Oracle Home = '/u01/oracle/product/1020/db_1')
Is the node ready for patching? [y|n]
y
这里提示本地节点的patch已经安装好了,叫你停止下一个节点的instance,然后选y继续其它节点的安装
The node 'dwdb1' 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 'dwdb1' .
The following make commands were invoked on remote nodes:
'cd /u01/oracle/product/1020/db_1/rdbms/lib; /usr/bin/make -f ins_rdbms.mk ioracle ORACLE_HOME=/u01/oracle/product/1020/db_1
'
OPatch succeeded.
最后所有节点安装成功