之前执行patch都是选择手动执行,由于有升级需求,所以测试一下patch auto方式
一.生产环境
1.数据库环境
操作系统版本 : RedHat 5.4
数据库版本 : Oracle 11.2.0.4 RAC
Grid : 11.2.0.4
Oracle database: 11.2.0.4
2.准备内容
GI PSU : p22646198_112040_LINUX.zip
OPatch : p6880880_112000_Linux.zip
二、更新OPatch版本,必须要更新
在升级PSU之前必须将OPatch工具的版本升级到11.2.0.3.6或更高版本。目前最新的版本为11.2.0.3.12 OPatch下载地址:https://updates.oracle.com/download/6880880.html分别在两个节点更新OPatch版本:
1. 更新OPatch版本,需要更新到11.2.0.3.12,OPatch直接压缩替换就可以了上传p6880880_112000_Linux-x86-64.zip到每个节点的/soft目录
[root@jyrac1 soft]# ls -lrt total 51556 -rw-r--r-- 1 root root 52733900 May 11 11:11 p6880880_112000_Linux.zip [root@jyrac2 soft]# ls -lrt total 51556 -rw-r--r-- 1 root root 52733900 May 11 12:08 p6880880_112000_Linux.zip
备份grid与oracle软件的原Opatch目录
[root@jyrac1 soft]# cd /u01/app/product/11.2.0/crs [root@jyrac1 crs]# mv OPatch OPatch_bak [root@jyrac2 soft]# cd /u01/app/product/11.2.0/crs [root@jyrac2 crs]# mv OPatch OPatch_bak [root@jyrac1 db]# cd /u01/app/oracle/product/11.2.0/db [root@jyrac1 db]# mv OPatch OPatch_bak [root@jyrac2 crs]# cd /u01/app/oracle/product/11.2.0/db [root@jyrac2 db]# mv OPatch OPatch_bak
grid目录OPatch替换
以root用户执行以下命令:
[root@jyrac1 soft]# unzip p6880880_112000_Linux-x86-64.zip
Archive: p6880880_112000_Linux-x86-64.zip
creating: OPatch/
inflating: OPatch/opatchdiag
inflating: OPatch/opatch.pl
creating: OPatch/jlib/
inflating: OPatch/jlib/oracle.opatchcore.classpath.jar
inflating: OPatch/jlib/opatch.jar
inflating: OPatch/jlib/oracle.opatch.classpath.jar
inflating: OPatch/jlib/oracle.opatch.classpath.unix.jar
inflating: OPatch/jlib/oracle.opatch.classpath.windows.jar
inflating: OPatch/jlib/opatchsdk.jar
inflating: OPatch/jlib/oracle.opatchcore.classpath.unix.jar
inflating: OPatch/jlib/oracle.opatchcore.classpath.windows.jar
creating: OPatch/crs/
inflating: OPatch/crs/patch11203.pl
inflating: OPatch/crs/installPatch.excl
inflating: OPatch/crs/patch11202.pl
inflating: OPatch/crs/auto_patch.pl
creating: OPatch/crs/log/
inflating: OPatch/crs/patch112.pl
inflating: OPatch/crs/patchDB.pl
inflating: OPatch/crs/opatchauto
inflating: OPatch/crs/CRSProductDriver.jar
inflating: OPatch/crs/driver.jar
creating: OPatch/ocm/
creating: OPatch/ocm/doc/
extracting: OPatch/ocm/ocm.zip
inflating: OPatch/ocm/ocm_platforms.txt
creating: OPatch/ocm/lib/
inflating: OPatch/ocm/lib/emocmclnt.jar
inflating: OPatch/ocm/lib/xmlparserv2.jar
inflating: OPatch/ocm/lib/http_client.jar
inflating: OPatch/ocm/lib/emocmclnt-14.jar
inflating: OPatch/ocm/lib/regexp.jar
inflating: OPatch/ocm/lib/jnet.jar
inflating: OPatch/ocm/lib/jsse.jar
inflating: OPatch/ocm/lib/osdt_core3.jar
inflating: OPatch/ocm/lib/osdt_jce.jar
inflating: OPatch/ocm/lib/emocmcommon.jar
inflating: OPatch/ocm/lib/log4j-core.jar
inflating: OPatch/ocm/lib/jcert.jar
creating: OPatch/ocm/bin/
inflating: OPatch/ocm/bin/emocmrsp
inflating: OPatch/opatch
creating: OPatch/opatchauto-dir/
creating: OPatch/opatchauto-dir/opatchautocore/
inflating: OPatch/opatchauto-dir/opatchautocore/oplan
inflating: OPatch/opatchauto-dir/opatchautocore/opatchautobinary
creating: OPatch/opatchauto-dir/opatchautocore/jlib/
inflating: OPatch/opatchauto-dir/opatchautocore/jlib/ValidationRules.jar
inflating: OPatch/opatchauto-dir/opatchautocore/jlib/patchsdk.jar
inflating: OPatch/opatchauto-dir/opatchautocore/jlib/ProductDriver.jar
inflating: OPatch/opatchauto-dir/opatchautocore/jlib/osysmodel-utils.jar
inflating: OPatch/opatchauto-dir/opatchautocore/jlib/OsysModel.jar
creating: OPatch/opatchauto-dir/opatchautocore/jlib/apache-commons/
inflating: OPatch/opatchauto-dir/opatchautocore/jlib/apache-commons/commons-compress-1.4.jar
inflating: OPatch/opatchauto-dir/opatchautocore/jlib/apache-commons/commons-cli-1.0.jar
inflating: OPatch/opatchauto-dir/opatchautocore/jlib/oplan_core.jar
inflating: OPatch/opatchauto-dir/opatchautocore/jlib/oracle.oplan.classpath.jar
inflating: OPatch/opatchauto-dir/opatchautocore/jlib/bundle.jar
inflating: OPatch/opatchauto-dir/opatchautocore/jlib/oplan_sample.jar
inflating: OPatch/opatchauto-dir/opatchautocore/jlib/Validation.jar
creating: OPatch/opatchauto-dir/opatchautocore/jlib/jaxb/
inflating: OPatch/opatchauto-dir/opatchautocore/jlib/jaxb/activation.jar
inflating: OPatch/opatchauto-dir/opatchautocore/jlib/jaxb/jsr173_1.0_api.jar
inflating: OPatch/opatchauto-dir/opatchautocore/jlib/jaxb/jaxb-api.jar
inflating: OPatch/opatchauto-dir/opatchautocore/jlib/jaxb/jaxb-impl.jar
inflating: OPatch/opatchauto-dir/opatchautocore/jlib/automation.jar
inflating: OPatch/opatchauto-dir/opatchautocore/oplan.bat
inflating: OPatch/opatchauto-dir/opatchautocore/README.txt
inflating: OPatch/opatchauto-dir/opatchautocore/README.html
creating: OPatch/opatchauto-dir/opatchautodb/
creating: OPatch/opatchauto-dir/opatchautodb/jlib/
inflating: OPatch/opatchauto-dir/opatchautodb/jlib/oracle.oplan.db.classpath.jar
inflating: OPatch/opatchauto-dir/opatchautodb/jlib/oplan_db.jar
inflating: OPatch/emdpatch.pl
creating: OPatch/scripts/
inflating: OPatch/scripts/opatch_wls.bat
inflating: OPatch/scripts/opatch_jvm_discovery.bat
inflating: OPatch/scripts/opatch_wls
inflating: OPatch/scripts/opatch_jvm_discovery
inflating: OPatch/operr
inflating: OPatch/operr_readme.txt
inflating: OPatch/operr.bat
creating: OPatch/opatchprereqs/
inflating: OPatch/opatchprereqs/prerequisite.properties
creating: OPatch/opatchprereqs/oui/
inflating: OPatch/opatchprereqs/oui/knowledgesrc.xml
creating: OPatch/opatchprereqs/opatch/
inflating: OPatch/opatchprereqs/opatch/runtime_prereq.xml
inflating: OPatch/opatchprereqs/opatch/rulemap.xml
inflating: OPatch/opatchprereqs/opatch/opatch_prereq.xml
inflating: OPatch/opatch.bat
creating: OPatch/oplan/
creating: OPatch/oplan/jlib/
creating: OPatch/oplan/jlib/apache-commons/
inflating: OPatch/oplan/jlib/apache-commons/commons-cli-1.0.jar
creating: OPatch/oplan/jlib/jaxb/
inflating: OPatch/oplan/jlib/jaxb/jsr173_1.0_api.jar
inflating: OPatch/oplan/jlib/jaxb/jaxb-impl.jar
inflating: OPatch/oplan/jlib/jaxb/activation.jar
inflating: OPatch/oplan/jlib/jaxb/jaxb-api.jar
inflating: OPatch/oplan/jlib/Validation.jar
inflating: OPatch/oplan/jlib/oracle.oplan.classpath.jar
inflating: OPatch/oplan/jlib/OuiDriver.jar
inflating: OPatch/oplan/jlib/EMrepoDrivers.jar
inflating: OPatch/oplan/jlib/JMXDrivers.jar
inflating: OPatch/oplan/jlib/bundle.jar
inflating: OPatch/oplan/jlib/CRSProductDriver.jar
inflating: OPatch/oplan/jlib/oplan.jar
inflating: OPatch/oplan/jlib/ValidationRules.jar
inflating: OPatch/oplan/jlib/osysmodel-utils.jar
inflating: OPatch/oplan/jlib/automation.jar
inflating: OPatch/oplan/README.html
inflating: OPatch/oplan/README.txt
inflating: OPatch/oplan/oplan.bat
inflating: OPatch/oplan/oplan
inflating: OPatch/opatchdiag.bat
inflating: OPatch/README.txt
extracting: OPatch/version.txt
creating: OPatch/docs/
inflating: OPatch/docs/cversion.txt
inflating: OPatch/docs/Prereq_Users_Guide.txt
inflating: OPatch/docs/FAQ
inflating: OPatch/docs/Users_Guide.txt
[root@jyrac2 soft]# unzip p6880880_112000_Linux-x86-64.zip Archive: p6880880_112000_Linux-x86-64.zip creating: OPatch/ inflating: OPatch/opatchdiag inflating: OPatch/opatch.pl creating: OPatch/jlib/ inflating: OPatch/jlib/oracle.opatchcore.classpath.jar inflating: OPatch/jlib/opatch.jar inflating: OPatch/jlib/oracle.opatch.classpath.jar inflating: OPatch/jlib/oracle.opatch.classpath.unix.jar inflating: OPatch/jlib/oracle.opatch.classpath.windows.jar inflating: OPatch/jlib/opatchsdk.jar inflating: OPatch/jlib/oracle.opatchcore.classpath.unix.jar inflating: OPatch/jlib/oracle.opatchcore.classpath.windows.jar creating: OPatch/crs/ inflating: OPatch/crs/patch11203.pl inflating: OPatch/crs/installPatch.excl inflating: OPatch/crs/patch11202.pl inflating: OPatch/crs/auto_patch.pl creating: OPatch/crs/log/ inflating: OPatch/crs/patch112.pl inflating: OPatch/crs/patchDB.pl inflating: OPatch/crs/opatchauto inflating: OPatch/crs/CRSProductDriver.jar inflating: OPatch/crs/driver.jar creating: OPatch/ocm/ creating: OPatch/ocm/doc/ extracting: OPatch/ocm/ocm.zip inflating: OPatch/ocm/ocm_platforms.txt creating: OPatch/ocm/lib/ inflating: OPatch/ocm/lib/emocmclnt.jar inflating: OPatch/ocm/lib/xmlparserv2.jar inflating: OPatch/ocm/lib/http_client.jar inflating: OPatch/ocm/lib/emocmclnt-14.jar inflating: OPatch/ocm/lib/regexp.jar inflating: OPatch/ocm/lib/jnet.jar inflating: OPatch/ocm/lib/jsse.jar inflating: OPatch/ocm/lib/osdt_core3.jar inflating: OPatch/ocm/lib/osdt_jce.jar inflating: OPatch/ocm/lib/emocmcommon.jar inflating: OPatch/ocm/lib/log4j-core.jar inflating: OPatch/ocm/lib/jcert.jar creating: OPatch/ocm/bin/ inflating: OPatch/ocm/bin/emocmrsp inflating: OPatch/opatch creating: OPatch/opatchauto-dir/ creating: OPatch/opatchauto-dir/opatchautocore/ inflating: OPatch/opatchauto-dir/opatchautocore/oplan inflating: OPatch/opatchauto-dir/opatchautocore/opatchautobinary creating: OPatch/opatchauto-dir/opatchautocore/jlib/ inflating: OPatch/opatchauto-dir/opatchautocore/jlib/ValidationRules.jar inflating: OPatch/opatchauto-dir/opatchautocore/jlib/patchsdk.jar inflating: OPatch/opatchauto-dir/opatchautocore/jlib/ProductDriver.jar inflating: OPatch/opatchauto-dir/opatchautocore/jlib/osysmodel-utils.jar inflating: OPatch/opatchauto-dir/opatchautocore/jlib/OsysModel.jar creating: OPatch/opatchauto-dir/opatchautocore/jlib/apache-commons/ inflating: OPatch/opatchauto-dir/opatchautocore/jlib/apache-commons/commons-compress-1.4.jar inflating: OPatch/opatchauto-dir/opatchautocore/jlib/apache-commons/commons-cli-1.0.jar inflating: OPatch/opatchauto-dir/opatchautocore/jlib/oplan_core.jar inflating: OPatch/opatchauto-dir/opatchautocore/jlib/oracle.oplan.classpath.jar inflating: OPatch/opatchauto-dir/opatchautocore/jlib/bundle.jar inflating: OPatch/opatchauto-dir/opatchautocore/jlib/oplan_sample.jar inflating: OPatch/opatchauto-dir/opatchautocore/jlib/Validation.jar creating: OPatch/opatchauto-dir/opatchautocore/jlib/jaxb/ inflating: OPatch/opatchauto-dir/opatchautocore/jlib/jaxb/activation.jar inflating: OPatch/opatchauto-dir/opatchautocore/jlib/jaxb/jsr173_1.0_api.jar inflating: OPatch/opatchauto-dir/opatchautocore/jlib/jaxb/jaxb-api.jar inflating: OPatch/opatchauto-dir/opatchautocore/jlib/jaxb/jaxb-impl.jar inflating: OPatch/opatchauto-dir/opatchautocore/jlib/automation.jar inflating: OPatch/opatchauto-dir/opatchautocore/oplan.bat inflating: OPatch/opatchauto-dir/opatchautocore/README.txt inflating: OPatch/opatchauto-dir/opatchautocore/README.html creating: OPatch/opatchauto-dir/opatchautodb/ creating: OPatch/opatchauto-dir/opatchautodb/jlib/ inflating: OPatch/opatchauto-dir/opatchautodb/jlib/oracle.oplan.db.classpath.jar inflating: OPatch/opatchauto-dir/opatchautodb/jlib/oplan_db.jar inflating: OPatch/emdpatch.pl creating: OPatch/scripts/ inflating: OPatch/scripts/opatch_wls.bat inflating: OPatch/scripts/opatch_jvm_discovery.bat inflating: OPatch/scripts/opatch_wls inflating: OPatch/scripts/opatch_jvm_discovery inflating: OPatch/operr inflating: OPatch/operr_readme.txt inflating: OPatch/operr.bat creating: OPatch/opatchprereqs/ inflating: OPatch/opatchprereqs/prerequisite.properties creating: OPatch/opatchprereqs/oui/ inflating: OPatch/opatchprereqs/oui/knowledgesrc.xml creating: OPatch/opatchprereqs/opatch/ inflating: OPatch/opatchprereqs/opatch/runtime_prereq.xml inflating: OPatch/opatchprereqs/opatch/rulemap.xml inflating: OPatch/opatchprereqs/opatch/opatch_prereq.xml inflating: OPatch/opatch.bat creating: OPatch/oplan/ creating: OPatch/oplan/jlib/ creating: OPatch/oplan/jlib/apache-commons/ inflating: OPatch/oplan/jlib/apache-commons/commons-cli-1.0.jar creating: OPatch/oplan/jlib/jaxb/ inflating: OPatch/oplan/jlib/jaxb/jsr173_1.0_api.jar inflating: OPatch/oplan/jlib/jaxb/jaxb-impl.jar inflating: OPatch/oplan/jlib/jaxb/activation.jar inflating: OPatch/oplan/jlib/jaxb/jaxb-api.jar inflating: OPatch/oplan/jlib/Validation.jar inflating: OPatch/oplan/jlib/oracle.oplan.classpath.jar inflating: OPatch/oplan/jlib/OuiDriver.jar inflating: OPatch/oplan/jlib/EMrepoDrivers.jar inflating: OPatch/oplan/jlib/JMXDrivers.jar inflating: OPatch/oplan/jlib/bundle.jar inflating: OPatch/oplan/jlib/CRSProductDriver.jar inflating: OPatch/oplan/jlib/oplan.jar inflating: OPatch/oplan/jlib/ValidationRules.jar inflating: OPatch/oplan/jlib/osysmodel-utils.jar inflating: OPatch/oplan/jlib/automation.jar inflating: OPatch/oplan/README.html inflating: OPatch/oplan/README.txt inflating: OPatch/oplan/oplan.bat inflating: OPatch/oplan/oplan inflating: OPatch/opatchdiag.bat inflating: OPatch/README.txt extracting: OPatch/version.txt creating: OPatch/docs/ inflating: OPatch/docs/cversion.txt inflating: OPatch/docs/Prereq_Users_Guide.txt inflating: OPatch/docs/FAQ inflating: OPatch/docs/Users_Guide.txt
以root用户执行以下命令:
[root@jyrac1 soft]# cp -R OPatch /u01/app/product/11.2.0/crs/ [root@jyrac1 ~]$ cd /u01/app/product/11.2.0/crs/ [root@jyrac1 ~]$chown -R grid:oinstall OPatch [root@jyrac2 soft]# cp -R OPatch /u01/app/product/11.2.0/crs/ [root@jyrac2 ~]$ cd /u01/app/product/11.2.0/crs/ [root@jyrac2 ~]$chown -R grid:oinstall OPatch [root@jyrac1 soft]# cp -R OPatch /u01/app/oracle/product/11.2.0/db/ [root@jyrac1 soft]# cd /u01/app/oracle/product/11.2.0/db [root@jyrac1 db]# chown -R oracle:oinstall OPatch [root@jyrac2 soft]# cp -R OPatch /u01/app/oracle/product/11.2.0/db/ [root@jyrac2 soft]# cd /u01/app/oracle/product/11.2.0/db [root@jyrac2 db]# chown -R oracle:oinstall OPatch
以grid与oracle用户来进行测试
[root@jyrac1 crs]# su - grid [grid@jyrac1 ~]$ cd /u01/app/product/11.2.0/crs/OPatch [grid@jyrac1 OPatch]$ ./opatch version OPatch Version: 11.2.0.3.12 OPatch succeeded. [root@jyrac2 crs]# su - grid [grid@jyrac2 ~]$ cd /u01/app/product/11.2.0/crs/OPatch/ [grid@jyrac2 OPatch]$ ./opatch version OPatch Version: 11.2.0.3.12 OPatch succeeded.
[root@jyrac1 db]# su - oracle [oracle@jyrac1 ~]$ cd /u01/app/oracle/product/11.2.0/db/OPatch [oracle@jyrac1 OPatch]$ ./opatch version OPatch Version: 11.2.0.3.12 OPatch succeeded. [root@jyrac2 db]# su - oracle [oracle@jyrac2 ~]$ cd /u01/app/oracle/product/11.2.0/db/OPatch [oracle@jyrac2 OPatch]$ ./opatch version OPatch Version: 11.2.0.3.12 OPatch succeeded.
三.将补丁上传到所有节点并解压
[root@jyrac1 soft]# unzip p22646198_112040_LINUX.zip [root@jyrac1 u02]# chown -R grid:oinstall 22646198 [root@jyrac1 u02]# chmod -R 755 22646198 [root@jyrac2 soft]# unzip p22646198_112040_LINUX.zip [root@jyrac2 u02]# chown -R grid:oinstall 22646198 [root@jyrac2 u02]# chmod -R 755 22646198
四.检查需要打的补丁与现有补丁是否冲突
[grid@jyrac1 OPatch]$ cd /u02/22646198/ [grid@jyrac1 22646198]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./ Oracle Interim Patch Installer version 11.2.0.3.12 Copyright (c) 2016, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/product/11.2.0/crs Central Inventory : /u01/app/oraInventory from : /u01/app/product/11.2.0/crs/oraInst.loc OPatch version : 11.2.0.3.12 OUI version : 11.2.0.4.0 Log file location : /u01/app/product/11.2.0/crs/cfgtoollogs/opatch/opatch2016-05-11_21-54-31PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded.
[grid@jyrac2 OPatch]$ cd /u02/22646198/ [grid@jyrac2 22646198]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./ Oracle Interim Patch Installer version 11.2.0.3.12 Copyright (c) 2016, Oracle Corporation. All rights reserved. PREREQ session Oracle Home : /u01/app/product/11.2.0/crs Central Inventory : /u01/app/oraInventory from : /u01/app/product/11.2.0/crs/oraInst.loc OPatch version : 11.2.0.3.12 OUI version : 11.2.0.4.0 Log file location : /u01/app/product/11.2.0/crs/cfgtoollogs/opatch/opatch2016-05-11_21-54-31PM_1.log Invoking prereq "checkconflictagainstohwithdetail" Prereq "checkConflictAgainstOHWithDetail" passed. OPatch succeeded.
五.OPatch apply(所有节点均需执行)(无需关闭任何组件及资源)
[root@jyrac1 u02]# export ORACLE_HOME=/u01/app/product/11.2.0/crs [root@jyrac1 u02]# $ORACLE_HOME/OPatch/opatch auto /u02/22646198/ -oh $ORACLE_HOME/ -ocmrf $ORACLE_HOME/OPatch/ocm/bin/emocmrsp Executing /u01/app/product/11.2.0/crs/perl/bin/perl /u01/app/product/11.2.0/crs/OPatch/crs/patch11203.pl -patchdir /u02 -patchn 22646198 -oh /u01/app/product/11.2.0/crs/ -ocmrf /u01/app/product/11.2.0/crs/OPatch/ocm/bin/emocmrsp -paramfile /u01/app/product/11.2.0/crs/crs/install/crsconfig_params This is the main log file: /u01/app/product/11.2.0/crs/cfgtoollogs/opatchauto2016-05-11_21-59-41.log This file will show your detected configuration and all the steps that opatchauto attempted to do on your system: /u01/app/product/11.2.0/crs/cfgtoollogs/opatchauto2016-05-11_21-59-41.report.log 2016-05-11 21:59:41: Starting Clusterware Patch Setup Using configuration parameter file: /u01/app/product/11.2.0/crs/crs/install/crsconfig_params Stopping CRS... Stopped CRS successfully patch /u02/22646198/22502456 apply successful for home /u01/app/product/11.2.0/crs patch /u02/22646198/22502549 apply successful for home /u01/app/product/11.2.0/crs patch /u02/22646198/22502505 apply successful for home /u01/app/product/11.2.0/crs Starting CRS... Installing Trace File Analyzer CRS-4123: Oracle High Availability Services has been started. opatch auto succeeded.
[root@jyrac2 app]# export ORACLE_HOME=/u01/app/product/11.2.0/crs [root@jyrac2 app]# $ORACLE_HOME/OPatch/opatch auto /u02/22646198/ -oh $ORACLE_HOME/ -ocmrf $ORACLE_HOME/OPatch/ocm/bin/emocmrsp Executing /u01/app/product/11.2.0/crs/perl/bin/perl /u01/app/product/11.2.0/crs/OPatch/crs/patch11203.pl -patchdir /u02 -patchn 22646198 -oh /u01/app/product/11.2.0/crs/ -ocmrf /u01/app/product/11.2.0/crs/OPatch/ocm/bin/emocmrsp -paramfile /u01/app/product/11.2.0/crs/crs/install/crsconfig_params This is the main log file: /u01/app/product/11.2.0/crs/cfgtoollogs/opatchauto2016-05-11_22-32-49.log This file will show your detected configuration and all the steps that opatchauto attempted to do on your system: /u01/app/product/11.2.0/crs/cfgtoollogs/opatchauto2016-05-11_22-32-49.report.log 2016-05-11 22:32:49: Starting Clusterware Patch Setup Using configuration parameter file: /u01/app/product/11.2.0/crs/crs/install/crsconfig_params Stopping CRS... Stopped CRS successfully patch /u02/22646198/22502456 apply successful for home /u01/app/product/11.2.0/crs patch /u02/22646198/22502549 apply successful for home /u01/app/product/11.2.0/crs patch /u02/22646198/22502505 apply successful for home /u01/app/product/11.2.0/crs Starting CRS... Installing Trace File Analyzer CRS-4123: Oracle High Availability Services has been started. opatch auto succeeded.
[grid@jyrac1 app]$ crsctl stat res -t -------------------------------------------------------------------------------- NAME TARGET STATE SERVER STATE_DETAILS -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.CRSDG.dg ONLINE ONLINE jyrac1 ONLINE ONLINE jyrac2 ora.DATADG.dg ONLINE ONLINE jyrac1 ONLINE ONLINE jyrac2 ora.LISTENER.lsnr ONLINE ONLINE jyrac1 ONLINE ONLINE jyrac2 ora.asm ONLINE ONLINE jyrac1 Started ONLINE ONLINE jyrac2 Started ora.gsd ONLINE OFFLINE jyrac1 ONLINE OFFLINE jyrac2 ora.net1.network ONLINE ONLINE jyrac1 ONLINE ONLINE jyrac2 ora.ons ONLINE ONLINE jyrac1 ONLINE ONLINE jyrac2 ora.registry.acfs ONLINE ONLINE jyrac1 ONLINE ONLINE jyrac2 -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE jyrac1 ora.cvu 1 ONLINE ONLINE jyrac1 ora.jyrac.db 1 ONLINE ONLINE jyrac1 Open 2 ONLINE OFFLINE Instance Shutdown ora.jyrac1.vip 1 ONLINE ONLINE jyrac1 ora.jyrac2.vip 1 ONLINE ONLINE jyrac2 ora.oc4j 1 ONLINE ONLINE jyrac1 ora.scan1.vip 1 ONLINE ONLINE jyrac1
显示opatch成功,但是实例jyrac2不能启动,于是手动启动.
[oracle@jyrac2 trace]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Wed May 11 22:45:53 2016 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORA-01078: failure in processing system parameters ORA-01565: error in identifying file '+DATADG/jyrac/spfilejyrac.ora' ORA-17503: ksfdopn:2 Failed to open file +DATADG/jyrac/spfilejyrac.ora ORA-01034: ORACLE not available ORA-27123: unable to attach to shared memory segment Linux Error: 13: Permission denied Additional information: 26 Additional information: 786438
错误信息显示没有权限来访问磁盘组中的参数文件,可能是$ORACLE_HOME/bin/oracle权限出问题了。
[grid@jyrac2 crs]$ ls -l $ORACLE_HOME/bin/oracle -rwxr-x--x 1 grid oinstall 174947566 Dec 2 16:01 /u01/app/product/11.2.0/crs/bin/oracle [grid@jyrac2 crs]$ chmod 6751 $ORACLE_HOME/bin/oracle [grid@jyrac2 crs]$ ls -l $ORACLE_HOME/bin/oracle -rwsr-s--x 1 grid oinstall 174947566 Dec 2 16:01 /u01/app/product/11.2.0/crs/bin/oracle [oracle@jyrac2 dbs]$ ls -l $ORACLE_HOME/bin/oracle -rwsr-xr-x 1 oracle asmadmin 198797109 Dec 2 19:16 /u01/app/oracle/product/11.2.0/db/bin/oracle [oracle@jyrac2 dbs]$ chmod 6751 $ORACLE_HOME/bin/oracle [oracle@jyrac2 dbs]$ ls -l $ORACLE_HOME/bin/oracle -rwsr-x--x 1 oracle asmadmin 198797109 Dec 2 19:16 /u01/app/oracle/product/11.2.0/db/bin/oracle SQL> startup ORACLE instance started. Total System Global Area 669581312 bytes Fixed Size 1366724 bytes Variable Size 243270972 bytes Database Buffers 419430400 bytes Redo Buffers 5513216 bytes Database mounted. Database opened.
[root@jyrac1 u02]# export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db [root@jyrac1 u02]# $ORACLE_HOME/OPatch/opatch auto /u02/22646198/ -oh $ORACLE_HOME/ -ocmrf $ORACLE_HOME/OPatch/ocm/bin/emocmrsp Executing /u01/app/product/11.2.0/crs/perl/bin/perl /u01/app/oracle/product/11.2.0/db/OPatch/crs/patch11203.pl -patchdir /u02 -patchn 22646198 -oh /u01/app/oracle/product/11.2.0/db/ -ocmrf /u01/app/oracle/product/11.2.0/db/OPatch/ocm/bin/emocmrsp -paramfile /u01/app/product/11.2.0/crs/crs/install/crsconfig_params This is the main log file: /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatchauto2016-05-11_22-56-19.log This file will show your detected configuration and all the steps that opatchauto attempted to do on your system: /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatchauto2016-05-11_22-56-19.report.log 2016-05-11 22:56:19: Starting Clusterware Patch Setup Using configuration parameter file: /u01/app/product/11.2.0/crs/crs/install/crsconfig_params Stopping RAC /u01/app/oracle/product/11.2.0/db ... Stopped RAC /u01/app/oracle/product/11.2.0/db successfully patch /u02/22646198/22502456 apply successful for home /u01/app/oracle/product/11.2.0/db patch /u02/22646198/22502549/custom/server/22502549 apply successful for home /u01/app/oracle/product/11.2.0/db Starting RAC /u01/app/oracle/product/11.2.0/db ... Failed to start resources from database home /u01/app/oracle/product/11.2.0/db ERROR: Refer log file for more details. opatch auto failed.
错误显示patch成功,但在启动RAC数据库时失败,于是手动启动实例jyrac1
[oracle@jyrac1 OPatch]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Wed May 11 23:05:01 2016 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORA-01078: failure in processing system parameters ORA-01565: error in identifying file '+DATADG/jyrac/spfilejyrac.ora' ORA-17503: ksfdopn:10 Failed to open file +DATADG/jyrac/spfilejyrac.ora ORA-12547: TNS:lost contact SQL> exit Disconnected
错误信息显示没有权限来访问磁盘组中的参数文件,可能是$ORACLE_HOME/bin/oracle权限出问题了
[grid@jyrac1 crs]$ ls -l $ORACLE_HOME/bin/oracle -rwxr-x--x 1 grid oinstall 174947566 Dec 2 16:01 /u01/app/product/11.2.0/crs/bin/oracle [grid@jyrac1 crs]$ chmod 6751 $ORACLE_HOME/bin/oracle [grid@jyrac1 crs]$ ls -l $ORACLE_HOME/bin/oracle -rwsr-s--x 1 grid oinstall 174947566 Dec 2 16:01 /u01/app/product/11.2.0/crs/bin/oracle [oracle@jyrac1 OPatch]$ ls -l $ORACLE_HOME/bin/oracle -rwsr-s--x 1 oracle asmadmin 198963317 May 11 23:02 /u01/app/oracle/product/11.2.0/db/bin/oracle [oracle@jyrac1 OPatch]$ chmod 6751 $ORACLE_HOME/bin/oracle [oracle@jyrac1 OPatch]$ ls -l $ORACLE_HOME/bin/oracle -rwsr-x--x 1 oracle asmadmin 198963317 May 11 23:02 /u01/app/oracle/product/11.2.0/db/bin/oracle [oracle@jyrac1 OPatch]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Wed May 11 23:10:40 2016 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 669581312 bytes Fixed Size 1366724 bytes Variable Size 243270972 bytes Database Buffers 419430400 bytes Redo Buffers 5513216 bytes Database mounted. Database opened.
[root@jyrac2 app]# export ORACLE_HOME=/u01/app/oracle/product/11.2.0/db [root@jyrac2 app]# $ORACLE_HOME/OPatch/opatch auto /u02/22646198/ -oh $ORACLE_HOME/ -ocmrf $ORACLE_HOME/OPatch/ocm/bin/emocmrsp Executing /u01/app/product/11.2.0/crs/perl/bin/perl /u01/app/oracle/product/11.2.0/db/OPatch/crs/patch11203.pl -patchdir /u02 -patchn 22646198 -oh /u01/app/oracle/product/11.2.0/db/ -ocmrf /u01/app/oracle/product/11.2.0/db/OPatch/ocm/bin/emocmrsp -paramfile /u01/app/product/11.2.0/crs/crs/install/crsconfig_params This is the main log file: /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatchauto2016-05-11_23-11-32.log This file will show your detected configuration and all the steps that opatchauto attempted to do on your system: /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatchauto2016-05-11_23-11-32.report.log 2016-05-11 23:11:32: Starting Clusterware Patch Setup Using configuration parameter file: /u01/app/product/11.2.0/crs/crs/install/crsconfig_params Stopping RAC /u01/app/oracle/product/11.2.0/db ... Stopped RAC /u01/app/oracle/product/11.2.0/db successfully patch /u02/22646198/22502456 apply successful for home /u01/app/oracle/product/11.2.0/db patch /u02/22646198/22502549/custom/server/22502549 apply successful for home /u01/app/oracle/product/11.2.0/db Starting RAC /u01/app/oracle/product/11.2.0/db ... Started RAC /u01/app/oracle/product/11.2.0/db successfully opatch auto succeeded.
[grid@jyrac1 app]$ crsctl stat res -t -------------------------------------------------------------------------------- NAME TARGET STATE SERVER STATE_DETAILS -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.CRSDG.dg ONLINE ONLINE jyrac1 ONLINE ONLINE jyrac2 ora.DATADG.dg ONLINE ONLINE jyrac1 ONLINE ONLINE jyrac2 ora.LISTENER.lsnr ONLINE ONLINE jyrac1 ONLINE ONLINE jyrac2 ora.asm ONLINE ONLINE jyrac1 Started ONLINE ONLINE jyrac2 Started ora.gsd ONLINE OFFLINE jyrac1 ONLINE OFFLINE jyrac2 ora.net1.network ONLINE ONLINE jyrac1 ONLINE ONLINE jyrac2 ora.ons ONLINE ONLINE jyrac1 ONLINE ONLINE jyrac2 ora.registry.acfs ONLINE ONLINE jyrac1 ONLINE ONLINE jyrac2 -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE jyrac1 ora.cvu 1 ONLINE ONLINE jyrac1 ora.jyrac.db 1 ONLINE ONLINE jyrac1 Open 2 ONLINE ONLINE jyrac2 Open ora.jyrac1.vip 1 ONLINE ONLINE jyrac1 ora.jyrac2.vip 1 ONLINE ONLINE jyrac2 ora.oc4j 1 ONLINE ONLINE jyrac1 ora.scan1.vip 1 ONLINE ONLINE jyrac1
成功后,我们还是更新脚本(仅仅在第一节点)
登陆数据库执行脚本
oracle@jyrac1 u02]$cd $ORACLE_HOME/rdbms/admin oracle@jyrac1 admin]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Thu May 12 08:28:05 2016 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - Production With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options SQL> @catbundle.sql psu apply
六.验证
[grid@jyrac1 app]$ $ORACLE_HOME/OPatch/opatch lspatches 22502505;ACFS Patch Set Update : 11.2.0.4.160419 (22502505) 22502549;OCW Patch Set Update : 11.2.0.4.160419 (22502549) 22502456;Database Patch Set Update : 11.2.0.4.160419 (22502456) OPatch succeeded. [grid@jyrac2 crs]$ $ORACLE_HOME/OPatch/opatch lspatches 22502505;ACFS Patch Set Update : 11.2.0.4.160419 (22502505) 22502549;OCW Patch Set Update : 11.2.0.4.160419 (22502549) 22502456;Database Patch Set Update : 11.2.0.4.160419 (22502456) OPatch succeeded. [oracle@jyrac1 admin]$ $ORACLE_HOME/OPatch/opatch lspatches 22502549;OCW Patch Set Update : 11.2.0.4.160419 (22502549) 22502456;Database Patch Set Update : 11.2.0.4.160419 (22502456) OPatch succeeded. [oracle@jyrac2 dbs]$ $ORACLE_HOME/OPatch/opatch lspatches 22502549;OCW Patch Set Update : 11.2.0.4.160419 (22502549) 22502456;Database Patch Set Update : 11.2.0.4.160419 (22502456) OPatch succeeded.
或者
[grid@jyrac1 app]$ $ORACLE_HOME/OPatch/opatch lsinventory Oracle Interim Patch Installer version 11.2.0.3.12 Copyright (c) 2016, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/product/11.2.0/crs Central Inventory : /u01/app/oraInventory from : /u01/app/product/11.2.0/crs/oraInst.loc OPatch version : 11.2.0.3.12 OUI version : 11.2.0.4.0 Log file location : /u01/app/product/11.2.0/crs/cfgtoollogs/opatch/opatch2016-05-12_08-32-14AM_1.log Lsinventory Output file location : /u01/app/product/11.2.0/crs/cfgtoollogs/opatch/lsinv/lsinventory2016-05-12_08-32-14AM.txt -------------------------------------------------------------------------------- Local Machine Information:: Hostname: jyrac1 ARU platform id: 46 ARU platform description:: Linux x86 Installed Top-level Products (1): Oracle Grid Infrastructure 11g 11.2.0.4.0 There are 1 products installed in this Oracle Home. Interim patches (3) : Patch 22502505 : applied on Wed May 11 22:07:58 CST 2016 Unique Patch ID: 19945546 Patch description: "ACFS Patch Set Update : 11.2.0.4.160419 (22502505)" Created on 4 Mar 2016, 00:05:12 hrs PST8PDT Bugs fixed: 21369858, 16318126, 19690653, 17503605, 17203009, 17359415, 20140148 17611362, 17164243, 19053182, 17696547, 17488768, 18168684, 21519796 18143006, 21208140, 17428148, 17070158, 20438706, 17510275, 17172303 18610307, 17376318, 17721778, 22198405, 17699423, 18915417, 18155334 18321597, 19919907, 18185024, 17636008, 17363999, 20681968, 17475946 Patch 22502549 : applied on Wed May 11 22:07:25 CST 2016 Unique Patch ID: 19945546 Patch description: "OCW Patch Set Update : 11.2.0.4.160419 (22502549)" Created on 18 Mar 2016, 05:57:45 hrs PST8PDT Bugs fixed: 19270660, 18328800, 18508710, 18691572, 20038451, 21251192, 21232394 20365005, 17750548, 17387214, 17617807, 14497275, 20219458, 17733927 18180541, 18962892, 17292250, 17378618, 16759171, 20110156, 17843489 17065496, 13991403, 17273020, 17155238, 20012766, 21245437, 18261183 18053580, 20218012, 17013634, 17886392, 20995001, 17039197, 17947785 16317771, 10052729, 22353346, 20340620, 16237657, 20317221, 15917869 18199185, 18399991, 20186278, 17374271, 18024089, 16849642, 20746251 20246071, 14270845, 20552947, 18882642, 18414137, 17001914, 17927970 14378120, 16346413, 15986647, 18068871, 21222147, 18143836, 16206997 21982225, 19168690, 20235511, 18343490, 21875360, 16613232, 19276791 17722664, 20440643, 12928658, 18952577, 18520351, 16249829, 18226143 16076412, 18265482, 18229842, 17172091, 20676340, 17818075, 20091753 18231837, 14373486, 20136892, 17483479, 20551654, 18120545, 18729166 13843841, 21225209, 17405302, 18709496, 18330979, 18744838, 17087371 20531190, 14525998, 18187697, 20598625, 14385860, 18348155, 19479503 12928592, 17516024, 18370031, 17764053, 19272663, 17551223, 14671408 18272135, 14207615, 21255373, 17500165, 18875012, 14769643, 18464784 19558324, 18848125, 19241857, 14851828, 17955615, 20315294, 14693336 16284825, 17352230, 20014326, 17238586, 17089344, 17405605, 21327402 17531342, 19398098, 17159489, 17640316, 13823394, 16543190, 22024217 17983675, 20795241, 17598201, 17481314, 16281493, 18346135, 15986311 19601468, 17208793, 18700935, 18999857, 14076173, 18428146, 18352845 17435488, 20408163, 17592037, 18352846, 19616601, 17391726, 17387779 14777968, 15851860, 16206882, 20141091, 21113068, 20175174, 17305100 15832129, 19885321, 16901346, 17985714, 18536826, 17780903, 18752378 18946768, 16876500, 16875342, 17769597, 19955755, 16429265, 18336452 17273003, 17209968, 16988311, 20094984, 19319357, 17059927, 17046460 18053631, 16867761, 18774591, 21442094, 20235486, 19359787, 15869775 19642566, 17447588, 16798862, 15920201 Patch 22502456 : applied on Wed May 11 22:05:13 CST 2016 Unique Patch ID: 19878058 Patch description: "Database Patch Set Update : 11.2.0.4.160419 (22502456)" Created on 9 Mar 2016, 19:56:01 hrs Sub-patch 21948347; "Database Patch Set Update : 11.2.0.4.160119 (21948347)" Sub-patch 21352635; "Database Patch Set Update : 11.2.0.4.8 (21352635)" Sub-patch 20760982; "Database Patch Set Update : 11.2.0.4.7 (20760982)" Sub-patch 20299013; "Database Patch Set Update : 11.2.0.4.6 (20299013)" Sub-patch 19769489; "Database Patch Set Update : 11.2.0.4.5 (19769489)" Sub-patch 19121551; "Database Patch Set Update : 11.2.0.4.4 (19121551)" Sub-patch 18522509; "Database Patch Set Update : 11.2.0.4.3 (18522509)" Sub-patch 18031668; "Database Patch Set Update : 11.2.0.4.2 (18031668)" Sub-patch 17478514; "Database Patch Set Update : 11.2.0.4.1 (17478514)" Bugs fixed: 17288409, 21051852, 17811429, 18607546, 17205719, 20506699, 17816865 17922254, 17754782, 16934803, 13364795, 17311728, 17441661, 17284817 16992075, 17446237, 14015842, 19972569, 21756677, 21538558, 20925795 17449815, 17375354, 19463897, 13866822, 17982555, 17235750, 17478514 18317531, 14338435, 18235390, 20803583, 13944971, 20142975, 17811789 16929165, 18704244, 20506706, 17546973, 20334344, 14054676, 17088068 17346091, 18264060, 17343514, 21538567, 19680952, 18471685, 19211724 13951456, 21847223, 16315398, 18744139, 16850630, 19049453, 18673304 17883081, 19915271, 18641419, 18262334, 17006183, 16065166, 18277454 16833527, 10136473, 18051556, 17865671, 17852463, 18554871, 17853498 18334586, 17551709, 17588480, 19827973, 17344412, 17842825, 18828868 17025461, 11883252, 13609098, 17239687, 17602269, 19197175, 22195457 18316692, 17313525, 12611721, 19544839, 18964939, 17600719, 18191164 19393542, 17571306, 18482502, 20777150, 19466309, 17040527, 17165204 18098207, 16785708, 17465741, 17174582, 16180763, 16777840, 12982566 19463893, 22195465, 16875449, 12816846, 17237521, 19358317, 17811438 17811447, 21983325, 17945983, 18762750, 16912439, 17184721, 18061914 17282229, 18331850, 18202441, 17082359, 18723434, 21972320, 19554106 14034426, 18339044, 19458377, 17752995, 20448824, 17891943, 17258090 17767676, 16668584, 18384391, 17040764, 17381384, 15913355, 18356166 14084247, 20596234, 20506715, 21756661, 13853126, 18203837, 14245531 21756699, 16043574, 22195441, 17848897, 17877323, 21453153, 17468141 20861693, 17786518, 17912217, 17037130, 18155762, 16956380, 17478145 17394950, 18641461, 18189036, 18619917, 17027426, 21352646, 16268425 22195492, 19584068, 18436307, 17265217, 17634921, 13498382, 21526048 19258504, 20004087, 17443671, 22195485, 18000422, 20004021, 22321756 17571039, 21067387, 16344544, 18009564, 14354737, 21286665, 18135678 18614015, 20441797, 18362222, 17835048, 16472716, 17936109, 17050888 17325413, 14010183, 18747196, 17761775, 16721594, 17082983, 20067212 21179898, 17302277, 18084625, 15990359, 18203835, 17297939, 17811456 16731148, 21168487, 13829543, 17215560, 14133975, 17694209, 17385178 18091059, 8322815, 17586955, 17201159, 17655634, 18331812, 19730508 18868646, 17648596, 16220077, 16069901, 17348614, 17393915, 17274537 17957017, 18096714, 17308789, 18436647, 14285317, 19289642, 14764829 18328509, 17622427, 22195477, 16943711, 22502493, 14368995, 17346671 18996843, 17783588, 21343838, 16618694, 17672719, 18856999, 18783224 17851160, 17546761, 17798953, 18273830, 22092979, 16596890, 19972566 16384983, 17726838, 17360606, 22321741, 13645875, 18199537, 16542886 21787056, 17889549, 14565184, 17071721, 17610798, 20299015, 21343897 22893153, 20657441, 17397545, 18230522, 16360112, 19769489, 12905058 18641451, 12747740, 18430495, 17016369, 17042658, 14602788, 17551063 19972568, 21517440, 18508861, 19788842, 14657740, 17332800, 13837378 19972564, 17186905, 18315328, 19699191, 17437634, 22353199, 18093615 19006849, 19013183, 17296856, 18674024, 17232014, 16855292, 17762296 14692762, 21051840, 17705023, 19121551, 21330264, 19854503, 21868720 19309466, 18681862, 18554763, 20558005, 17390160, 18456514, 16306373 13955826, 18139690, 17501491, 17752121, 21668627, 17299889, 17889583 18673325, 19721304, 18293054, 17242746, 17951233, 17649265, 18094246 19615136, 17011832, 16870214, 17477958, 18522509, 20631274, 16091637 17323222, 16595641, 16524926, 18228645, 18282562, 17596908, 17156148 18031668, 16494615, 22683225, 17545847, 17655240, 17614134, 13558557 17341326, 17891946, 17716305, 16392068, 19271443, 21351877, 18092127 18440047, 17614227, 14106803, 16903536, 18973907, 18673342, 19032867 17389192, 17612828, 16194160, 17006570, 17721717, 17390431, 17570240 16863422, 18325460, 19727057, 16422541, 19972570, 17267114, 18244962 21538485, 18765602, 18203838, 16198143, 17246576, 14829250, 17835627 18247991, 14458214, 21051862, 16692232, 17786278, 17227277, 16042673 16314254, 16228604, 16837842, 17393683, 17787259, 20331945, 20074391 15861775, 16399083, 18018515, 22683212, 18260550, 21051858, 17036973 16613964, 17080436, 16579084, 18384537, 18280813, 20296213, 16901385 15979965, 18441944, 16450169, 9756271, 17892268, 11733603, 16285691 17587063, 21343775, 16538760, 18180390, 18193833, 21387964, 21051833 17238511, 17824637, 16571443, 18306996, 14852021, 18674047, 17853456 12364061, 22195448 Rac system comprising of multiple nodes Local node = jyrac1 Remote node = jyrac2 -------------------------------------------------------------------------------- OPatch succeeded. [grid@jyrac2 crs]$ $ORACLE_HOME/OPatch/opatch lsinventory Oracle Interim Patch Installer version 11.2.0.3.12 Copyright (c) 2016, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/product/11.2.0/crs Central Inventory : /u01/app/oraInventory from : /u01/app/product/11.2.0/crs/oraInst.loc OPatch version : 11.2.0.3.12 OUI version : 11.2.0.4.0 Log file location : /u01/app/product/11.2.0/crs/cfgtoollogs/opatch/opatch2016-05-12_08-32-27AM_1.log Lsinventory Output file location : /u01/app/product/11.2.0/crs/cfgtoollogs/opatch/lsinv/lsinventory2016-05-12_08-32-27AM.txt -------------------------------------------------------------------------------- Local Machine Information:: Hostname: jyrac2 ARU platform id: 46 ARU platform description:: Linux x86 Installed Top-level Products (1): Oracle Grid Infrastructure 11g 11.2.0.4.0 There are 1 products installed in this Oracle Home. Interim patches (3) : Patch 22502505 : applied on Wed May 11 22:07:58 CST 2016 Unique Patch ID: 19945546 Patch description: "ACFS Patch Set Update : 11.2.0.4.160419 (22502505)" Created on 4 Mar 2016, 00:05:12 hrs PST8PDT Bugs fixed: 21369858, 16318126, 19690653, 17503605, 17203009, 17359415, 20140148 17611362, 17164243, 19053182, 17696547, 17488768, 18168684, 21519796 18143006, 21208140, 17428148, 17070158, 20438706, 17510275, 17172303 18610307, 17376318, 17721778, 22198405, 17699423, 18915417, 18155334 18321597, 19919907, 18185024, 17636008, 17363999, 20681968, 17475946 Patch 22502549 : applied on Wed May 11 22:07:25 CST 2016 Unique Patch ID: 19945546 Patch description: "OCW Patch Set Update : 11.2.0.4.160419 (22502549)" Created on 18 Mar 2016, 05:57:45 hrs PST8PDT Bugs fixed: 19270660, 18328800, 18508710, 18691572, 20038451, 21251192, 21232394 20365005, 17750548, 17387214, 17617807, 14497275, 20219458, 17733927 18180541, 18962892, 17292250, 17378618, 16759171, 20110156, 17843489 17065496, 13991403, 17273020, 17155238, 20012766, 21245437, 18261183 18053580, 20218012, 17013634, 17886392, 20995001, 17039197, 17947785 16317771, 10052729, 22353346, 20340620, 16237657, 20317221, 15917869 18199185, 18399991, 20186278, 17374271, 18024089, 16849642, 20746251 20246071, 14270845, 20552947, 18882642, 18414137, 17001914, 17927970 14378120, 16346413, 15986647, 18068871, 21222147, 18143836, 16206997 21982225, 19168690, 20235511, 18343490, 21875360, 16613232, 19276791 17722664, 20440643, 12928658, 18952577, 18520351, 16249829, 18226143 16076412, 18265482, 18229842, 17172091, 20676340, 17818075, 20091753 18231837, 14373486, 20136892, 17483479, 20551654, 18120545, 18729166 13843841, 21225209, 17405302, 18709496, 18330979, 18744838, 17087371 20531190, 14525998, 18187697, 20598625, 14385860, 18348155, 19479503 12928592, 17516024, 18370031, 17764053, 19272663, 17551223, 14671408 18272135, 14207615, 21255373, 17500165, 18875012, 14769643, 18464784 19558324, 18848125, 19241857, 14851828, 17955615, 20315294, 14693336 16284825, 17352230, 20014326, 17238586, 17089344, 17405605, 21327402 17531342, 19398098, 17159489, 17640316, 13823394, 16543190, 22024217 17983675, 20795241, 17598201, 17481314, 16281493, 18346135, 15986311 19601468, 17208793, 18700935, 18999857, 14076173, 18428146, 18352845 17435488, 20408163, 17592037, 18352846, 19616601, 17391726, 17387779 14777968, 15851860, 16206882, 20141091, 21113068, 20175174, 17305100 15832129, 19885321, 16901346, 17985714, 18536826, 17780903, 18752378 18946768, 16876500, 16875342, 17769597, 19955755, 16429265, 18336452 17273003, 17209968, 16988311, 20094984, 19319357, 17059927, 17046460 18053631, 16867761, 18774591, 21442094, 20235486, 19359787, 15869775 19642566, 17447588, 16798862, 15920201 Patch 22502456 : applied on Wed May 11 22:05:13 CST 2016 Unique Patch ID: 19878058 Patch description: "Database Patch Set Update : 11.2.0.4.160419 (22502456)" Created on 9 Mar 2016, 19:56:01 hrs Sub-patch 21948347; "Database Patch Set Update : 11.2.0.4.160119 (21948347)" Sub-patch 21352635; "Database Patch Set Update : 11.2.0.4.8 (21352635)" Sub-patch 20760982; "Database Patch Set Update : 11.2.0.4.7 (20760982)" Sub-patch 20299013; "Database Patch Set Update : 11.2.0.4.6 (20299013)" Sub-patch 19769489; "Database Patch Set Update : 11.2.0.4.5 (19769489)" Sub-patch 19121551; "Database Patch Set Update : 11.2.0.4.4 (19121551)" Sub-patch 18522509; "Database Patch Set Update : 11.2.0.4.3 (18522509)" Sub-patch 18031668; "Database Patch Set Update : 11.2.0.4.2 (18031668)" Sub-patch 17478514; "Database Patch Set Update : 11.2.0.4.1 (17478514)" Bugs fixed: 17288409, 21051852, 17811429, 18607546, 17205719, 20506699, 17816865 17922254, 17754782, 16934803, 13364795, 17311728, 17441661, 17284817 16992075, 17446237, 14015842, 19972569, 21756677, 21538558, 20925795 17449815, 17375354, 19463897, 13866822, 17982555, 17235750, 17478514 18317531, 14338435, 18235390, 20803583, 13944971, 20142975, 17811789 16929165, 18704244, 20506706, 17546973, 20334344, 14054676, 17088068 17346091, 18264060, 17343514, 21538567, 19680952, 18471685, 19211724 13951456, 21847223, 16315398, 18744139, 16850630, 19049453, 18673304 17883081, 19915271, 18641419, 18262334, 17006183, 16065166, 18277454 16833527, 10136473, 18051556, 17865671, 17852463, 18554871, 17853498 18334586, 17551709, 17588480, 19827973, 17344412, 17842825, 18828868 17025461, 11883252, 13609098, 17239687, 17602269, 19197175, 22195457 18316692, 17313525, 12611721, 19544839, 18964939, 17600719, 18191164 19393542, 17571306, 18482502, 20777150, 19466309, 17040527, 17165204 18098207, 16785708, 17465741, 17174582, 16180763, 16777840, 12982566 19463893, 22195465, 16875449, 12816846, 17237521, 19358317, 17811438 17811447, 21983325, 17945983, 18762750, 16912439, 17184721, 18061914 17282229, 18331850, 18202441, 17082359, 18723434, 21972320, 19554106 14034426, 18339044, 19458377, 17752995, 20448824, 17891943, 17258090 17767676, 16668584, 18384391, 17040764, 17381384, 15913355, 18356166 14084247, 20596234, 20506715, 21756661, 13853126, 18203837, 14245531 21756699, 16043574, 22195441, 17848897, 17877323, 21453153, 17468141 20861693, 17786518, 17912217, 17037130, 18155762, 16956380, 17478145 17394950, 18641461, 18189036, 18619917, 17027426, 21352646, 16268425 22195492, 19584068, 18436307, 17265217, 17634921, 13498382, 21526048 19258504, 20004087, 17443671, 22195485, 18000422, 20004021, 22321756 17571039, 21067387, 16344544, 18009564, 14354737, 21286665, 18135678 18614015, 20441797, 18362222, 17835048, 16472716, 17936109, 17050888 17325413, 14010183, 18747196, 17761775, 16721594, 17082983, 20067212 21179898, 17302277, 18084625, 15990359, 18203835, 17297939, 17811456 16731148, 21168487, 13829543, 17215560, 14133975, 17694209, 17385178 18091059, 8322815, 17586955, 17201159, 17655634, 18331812, 19730508 18868646, 17648596, 16220077, 16069901, 17348614, 17393915, 17274537 17957017, 18096714, 17308789, 18436647, 14285317, 19289642, 14764829 18328509, 17622427, 22195477, 16943711, 22502493, 14368995, 17346671 18996843, 17783588, 21343838, 16618694, 17672719, 18856999, 18783224 17851160, 17546761, 17798953, 18273830, 22092979, 16596890, 19972566 16384983, 17726838, 17360606, 22321741, 13645875, 18199537, 16542886 21787056, 17889549, 14565184, 17071721, 17610798, 20299015, 21343897 22893153, 20657441, 17397545, 18230522, 16360112, 19769489, 12905058 18641451, 12747740, 18430495, 17016369, 17042658, 14602788, 17551063 19972568, 21517440, 18508861, 19788842, 14657740, 17332800, 13837378 19972564, 17186905, 18315328, 19699191, 17437634, 22353199, 18093615 19006849, 19013183, 17296856, 18674024, 17232014, 16855292, 17762296 14692762, 21051840, 17705023, 19121551, 21330264, 19854503, 21868720 19309466, 18681862, 18554763, 20558005, 17390160, 18456514, 16306373 13955826, 18139690, 17501491, 17752121, 21668627, 17299889, 17889583 18673325, 19721304, 18293054, 17242746, 17951233, 17649265, 18094246 19615136, 17011832, 16870214, 17477958, 18522509, 20631274, 16091637 17323222, 16595641, 16524926, 18228645, 18282562, 17596908, 17156148 18031668, 16494615, 22683225, 17545847, 17655240, 17614134, 13558557 17341326, 17891946, 17716305, 16392068, 19271443, 21351877, 18092127 18440047, 17614227, 14106803, 16903536, 18973907, 18673342, 19032867 17389192, 17612828, 16194160, 17006570, 17721717, 17390431, 17570240 16863422, 18325460, 19727057, 16422541, 19972570, 17267114, 18244962 21538485, 18765602, 18203838, 16198143, 17246576, 14829250, 17835627 18247991, 14458214, 21051862, 16692232, 17786278, 17227277, 16042673 16314254, 16228604, 16837842, 17393683, 17787259, 20331945, 20074391 15861775, 16399083, 18018515, 22683212, 18260550, 21051858, 17036973 16613964, 17080436, 16579084, 18384537, 18280813, 20296213, 16901385 15979965, 18441944, 16450169, 9756271, 17892268, 11733603, 16285691 17587063, 21343775, 16538760, 18180390, 18193833, 21387964, 21051833 17238511, 17824637, 16571443, 18306996, 14852021, 18674047, 17853456 12364061, 22195448 Rac system comprising of multiple nodes Local node = jyrac1 Remote node = jyrac2 -------------------------------------------------------------------------------- OPatch succeeded. [oracle@jyrac1 admin]$ $ORACLE_HOME/OPatch/opatch lsinventory Oracle Interim Patch Installer version 11.2.0.3.12 Copyright (c) 2016, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/11.2.0/db Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0/db/oraInst.loc OPatch version : 11.2.0.3.12 OUI version : 11.2.0.4.0 Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2016-05-12_08-32-35AM_1.log Lsinventory Output file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/lsinv/lsinventory2016-05-12_08-32-35AM.txt -------------------------------------------------------------------------------- Local Machine Information:: Hostname: jyrac1 ARU platform id: 46 ARU platform description:: Linux x86 Installed Top-level Products (1): Oracle Database 11g 11.2.0.4.0 There are 1 products installed in this Oracle Home. Interim patches (2) : Patch 22502549 : applied on Wed May 11 23:03:19 CST 2016 Unique Patch ID: 19945546 Patch description: "OCW Patch Set Update : 11.2.0.4.160419 (22502549)" Created on 18 Mar 2016, 05:57:37 hrs PST8PDT Bugs fixed: 9999999 Patch 22502456 : applied on Wed May 11 23:01:20 CST 2016 Unique Patch ID: 19878058 Patch description: "Database Patch Set Update : 11.2.0.4.160419 (22502456)" Created on 9 Mar 2016, 19:56:01 hrs Sub-patch 21948347; "Database Patch Set Update : 11.2.0.4.160119 (21948347)" Sub-patch 21352635; "Database Patch Set Update : 11.2.0.4.8 (21352635)" Sub-patch 20760982; "Database Patch Set Update : 11.2.0.4.7 (20760982)" Sub-patch 20299013; "Database Patch Set Update : 11.2.0.4.6 (20299013)" Sub-patch 19769489; "Database Patch Set Update : 11.2.0.4.5 (19769489)" Sub-patch 19121551; "Database Patch Set Update : 11.2.0.4.4 (19121551)" Sub-patch 18522509; "Database Patch Set Update : 11.2.0.4.3 (18522509)" Sub-patch 18031668; "Database Patch Set Update : 11.2.0.4.2 (18031668)" Sub-patch 17478514; "Database Patch Set Update : 11.2.0.4.1 (17478514)" Bugs fixed: 17288409, 21051852, 17811429, 18607546, 17205719, 20506699, 17816865 17922254, 17754782, 16934803, 13364795, 17311728, 17441661, 17284817 16992075, 17446237, 14015842, 19972569, 21756677, 21538558, 20925795 17449815, 17375354, 19463897, 13866822, 17982555, 17235750, 17478514 18317531, 14338435, 18235390, 20803583, 13944971, 20142975, 17811789 16929165, 18704244, 20506706, 17546973, 20334344, 14054676, 17088068 17346091, 18264060, 17343514, 21538567, 19680952, 18471685, 19211724 13951456, 21847223, 16315398, 18744139, 16850630, 19049453, 18673304 17883081, 19915271, 18641419, 18262334, 17006183, 16065166, 18277454 16833527, 10136473, 18051556, 17865671, 17852463, 18554871, 17853498 18334586, 17551709, 17588480, 19827973, 17344412, 17842825, 18828868 17025461, 11883252, 13609098, 17239687, 17602269, 19197175, 22195457 18316692, 17313525, 12611721, 19544839, 18964939, 17600719, 18191164 19393542, 17571306, 18482502, 20777150, 19466309, 17040527, 17165204 18098207, 16785708, 17465741, 17174582, 16180763, 16777840, 12982566 19463893, 22195465, 16875449, 12816846, 17237521, 19358317, 17811438 17811447, 21983325, 17945983, 18762750, 16912439, 17184721, 18061914 17282229, 18331850, 18202441, 17082359, 18723434, 21972320, 19554106 14034426, 18339044, 19458377, 17752995, 20448824, 17891943, 17258090 17767676, 16668584, 18384391, 17040764, 17381384, 15913355, 18356166 14084247, 20596234, 20506715, 21756661, 13853126, 18203837, 14245531 21756699, 16043574, 22195441, 17848897, 17877323, 21453153, 17468141 20861693, 17786518, 17912217, 17037130, 18155762, 16956380, 17478145 17394950, 18641461, 18189036, 18619917, 17027426, 21352646, 16268425 22195492, 19584068, 18436307, 17265217, 17634921, 13498382, 21526048 19258504, 20004087, 17443671, 22195485, 18000422, 20004021, 22321756 17571039, 21067387, 16344544, 18009564, 14354737, 21286665, 18135678 18614015, 20441797, 18362222, 17835048, 16472716, 17936109, 17050888 17325413, 14010183, 18747196, 17761775, 16721594, 17082983, 20067212 21179898, 17302277, 18084625, 15990359, 18203835, 17297939, 17811456 16731148, 21168487, 13829543, 17215560, 14133975, 17694209, 17385178 18091059, 8322815, 17586955, 17201159, 17655634, 18331812, 19730508 18868646, 17648596, 16220077, 16069901, 17348614, 17393915, 17274537 17957017, 18096714, 17308789, 18436647, 14285317, 19289642, 14764829 18328509, 17622427, 22195477, 16943711, 22502493, 14368995, 17346671 18996843, 17783588, 21343838, 16618694, 17672719, 18856999, 18783224 17851160, 17546761, 17798953, 18273830, 22092979, 16596890, 19972566 16384983, 17726838, 17360606, 22321741, 13645875, 18199537, 16542886 21787056, 17889549, 14565184, 17071721, 17610798, 20299015, 21343897 22893153, 20657441, 17397545, 18230522, 16360112, 19769489, 12905058 18641451, 12747740, 18430495, 17016369, 17042658, 14602788, 17551063 19972568, 21517440, 18508861, 19788842, 14657740, 17332800, 13837378 19972564, 17186905, 18315328, 19699191, 17437634, 22353199, 18093615 19006849, 19013183, 17296856, 18674024, 17232014, 16855292, 17762296 14692762, 21051840, 17705023, 19121551, 21330264, 19854503, 21868720 19309466, 18681862, 18554763, 20558005, 17390160, 18456514, 16306373 13955826, 18139690, 17501491, 17752121, 21668627, 17299889, 17889583 18673325, 19721304, 18293054, 17242746, 17951233, 17649265, 18094246 19615136, 17011832, 16870214, 17477958, 18522509, 20631274, 16091637 17323222, 16595641, 16524926, 18228645, 18282562, 17596908, 17156148 18031668, 16494615, 22683225, 17545847, 17655240, 17614134, 13558557 17341326, 17891946, 17716305, 16392068, 19271443, 21351877, 18092127 18440047, 17614227, 14106803, 16903536, 18973907, 18673342, 19032867 17389192, 17612828, 16194160, 17006570, 17721717, 17390431, 17570240 16863422, 18325460, 19727057, 16422541, 19972570, 17267114, 18244962 21538485, 18765602, 18203838, 16198143, 17246576, 14829250, 17835627 18247991, 14458214, 21051862, 16692232, 17786278, 17227277, 16042673 16314254, 16228604, 16837842, 17393683, 17787259, 20331945, 20074391 15861775, 16399083, 18018515, 22683212, 18260550, 21051858, 17036973 16613964, 17080436, 16579084, 18384537, 18280813, 20296213, 16901385 15979965, 18441944, 16450169, 9756271, 17892268, 11733603, 16285691 17587063, 21343775, 16538760, 18180390, 18193833, 21387964, 21051833 17238511, 17824637, 16571443, 18306996, 14852021, 18674047, 17853456 12364061, 22195448 Rac system comprising of multiple nodes Local node = jyrac1 Remote node = jyrac2 -------------------------------------------------------------------------------- OPatch succeeded. [oracle@jyrac2 dbs]$ $ORACLE_HOME/OPatch/opatch lsinventory Oracle Interim Patch Installer version 11.2.0.3.12 Copyright (c) 2016, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/11.2.0/db Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0/db/oraInst.loc OPatch version : 11.2.0.3.12 OUI version : 11.2.0.4.0 Log file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch2016-05-12_08-32-33AM_1.log Lsinventory Output file location : /u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/lsinv/lsinventory2016-05-12_08-32-33AM.txt -------------------------------------------------------------------------------- Local Machine Information:: Hostname: jyrac2 ARU platform id: 46 ARU platform description:: Linux x86 Installed Top-level Products (1): Oracle Database 11g 11.2.0.4.0 There are 1 products installed in this Oracle Home. Interim patches (2) : Patch 22502549 : applied on Wed May 11 23:17:40 CST 2016 Unique Patch ID: 19945546 Patch description: "OCW Patch Set Update : 11.2.0.4.160419 (22502549)" Created on 18 Mar 2016, 05:57:37 hrs PST8PDT Bugs fixed: 9999999 Patch 22502456 : applied on Wed May 11 23:15:56 CST 2016 Unique Patch ID: 19878058 Patch description: "Database Patch Set Update : 11.2.0.4.160419 (22502456)" Created on 9 Mar 2016, 19:56:01 hrs Sub-patch 21948347; "Database Patch Set Update : 11.2.0.4.160119 (21948347)" Sub-patch 21352635; "Database Patch Set Update : 11.2.0.4.8 (21352635)" Sub-patch 20760982; "Database Patch Set Update : 11.2.0.4.7 (20760982)" Sub-patch 20299013; "Database Patch Set Update : 11.2.0.4.6 (20299013)" Sub-patch 19769489; "Database Patch Set Update : 11.2.0.4.5 (19769489)" Sub-patch 19121551; "Database Patch Set Update : 11.2.0.4.4 (19121551)" Sub-patch 18522509; "Database Patch Set Update : 11.2.0.4.3 (18522509)" Sub-patch 18031668; "Database Patch Set Update : 11.2.0.4.2 (18031668)" Sub-patch 17478514; "Database Patch Set Update : 11.2.0.4.1 (17478514)" Bugs fixed: 17288409, 21051852, 17811429, 18607546, 17205719, 20506699, 17816865 17922254, 17754782, 16934803, 13364795, 17311728, 17441661, 17284817 16992075, 17446237, 14015842, 19972569, 21756677, 21538558, 20925795 17449815, 17375354, 19463897, 13866822, 17982555, 17235750, 17478514 18317531, 14338435, 18235390, 20803583, 13944971, 20142975, 17811789 16929165, 18704244, 20506706, 17546973, 20334344, 14054676, 17088068 17346091, 18264060, 17343514, 21538567, 19680952, 18471685, 19211724 13951456, 21847223, 16315398, 18744139, 16850630, 19049453, 18673304 17883081, 19915271, 18641419, 18262334, 17006183, 16065166, 18277454 16833527, 10136473, 18051556, 17865671, 17852463, 18554871, 17853498 18334586, 17551709, 17588480, 19827973, 17344412, 17842825, 18828868 17025461, 11883252, 13609098, 17239687, 17602269, 19197175, 22195457 18316692, 17313525, 12611721, 19544839, 18964939, 17600719, 18191164 19393542, 17571306, 18482502, 20777150, 19466309, 17040527, 17165204 18098207, 16785708, 17465741, 17174582, 16180763, 16777840, 12982566 19463893, 22195465, 16875449, 12816846, 17237521, 19358317, 17811438 17811447, 21983325, 17945983, 18762750, 16912439, 17184721, 18061914 17282229, 18331850, 18202441, 17082359, 18723434, 21972320, 19554106 14034426, 18339044, 19458377, 17752995, 20448824, 17891943, 17258090 17767676, 16668584, 18384391, 17040764, 17381384, 15913355, 18356166 14084247, 20596234, 20506715, 21756661, 13853126, 18203837, 14245531 21756699, 16043574, 22195441, 17848897, 17877323, 21453153, 17468141 20861693, 17786518, 17912217, 17037130, 18155762, 16956380, 17478145 17394950, 18641461, 18189036, 18619917, 17027426, 21352646, 16268425 22195492, 19584068, 18436307, 17265217, 17634921, 13498382, 21526048 19258504, 20004087, 17443671, 22195485, 18000422, 20004021, 22321756 17571039, 21067387, 16344544, 18009564, 14354737, 21286665, 18135678 18614015, 20441797, 18362222, 17835048, 16472716, 17936109, 17050888 17325413, 14010183, 18747196, 17761775, 16721594, 17082983, 20067212 21179898, 17302277, 18084625, 15990359, 18203835, 17297939, 17811456 16731148, 21168487, 13829543, 17215560, 14133975, 17694209, 17385178 18091059, 8322815, 17586955, 17201159, 17655634, 18331812, 19730508 18868646, 17648596, 16220077, 16069901, 17348614, 17393915, 17274537 17957017, 18096714, 17308789, 18436647, 14285317, 19289642, 14764829 18328509, 17622427, 22195477, 16943711, 22502493, 14368995, 17346671 18996843, 17783588, 21343838, 16618694, 17672719, 18856999, 18783224 17851160, 17546761, 17798953, 18273830, 22092979, 16596890, 19972566 16384983, 17726838, 17360606, 22321741, 13645875, 18199537, 16542886 21787056, 17889549, 14565184, 17071721, 17610798, 20299015, 21343897 22893153, 20657441, 17397545, 18230522, 16360112, 19769489, 12905058 18641451, 12747740, 18430495, 17016369, 17042658, 14602788, 17551063 19972568, 21517440, 18508861, 19788842, 14657740, 17332800, 13837378 19972564, 17186905, 18315328, 19699191, 17437634, 22353199, 18093615 19006849, 19013183, 17296856, 18674024, 17232014, 16855292, 17762296 14692762, 21051840, 17705023, 19121551, 21330264, 19854503, 21868720 19309466, 18681862, 18554763, 20558005, 17390160, 18456514, 16306373 13955826, 18139690, 17501491, 17752121, 21668627, 17299889, 17889583 18673325, 19721304, 18293054, 17242746, 17951233, 17649265, 18094246 19615136, 17011832, 16870214, 17477958, 18522509, 20631274, 16091637 17323222, 16595641, 16524926, 18228645, 18282562, 17596908, 17156148 18031668, 16494615, 22683225, 17545847, 17655240, 17614134, 13558557 17341326, 17891946, 17716305, 16392068, 19271443, 21351877, 18092127 18440047, 17614227, 14106803, 16903536, 18973907, 18673342, 19032867 17389192, 17612828, 16194160, 17006570, 17721717, 17390431, 17570240 16863422, 18325460, 19727057, 16422541, 19972570, 17267114, 18244962 21538485, 18765602, 18203838, 16198143, 17246576, 14829250, 17835627 18247991, 14458214, 21051862, 16692232, 17786278, 17227277, 16042673 16314254, 16228604, 16837842, 17393683, 17787259, 20331945, 20074391 15861775, 16399083, 18018515, 22683212, 18260550, 21051858, 17036973 16613964, 17080436, 16579084, 18384537, 18280813, 20296213, 16901385 15979965, 18441944, 16450169, 9756271, 17892268, 11733603, 16285691 17587063, 21343775, 16538760, 18180390, 18193833, 21387964, 21051833 17238511, 17824637, 16571443, 18306996, 14852021, 18674047, 17853456 12364061, 22195448 Rac system comprising of multiple nodes Local node = jyrac2 Remote node = jyrac1 -------------------------------------------------------------------------------- OPatch succeeded.
到此将Oracle 11.2.0.4升级到11.2.0.4.160419的操作完成