opatch auto如何将11.2.0.4 rac升级到11.2.0.4.160419
这篇文章给大家介绍opatch auto如何将11.2.0.4 rac升级到11.2.0.4.160419，内容非常详细，感兴趣的小伙伴们可以参考借鉴，希望对大家能有所帮助。
之前执行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@jyrac1soft]#ls-lrttotal51556-rw-r--r--1rootroot52733900May1111:11p6880880_112000_Linux.zip[root@jyrac2soft]#ls-lrttotal51556-rw-r--r--1rootroot52733900May1112:08p6880880_112000_Linux.zip
备份grid与oracle软件的原Opatch目录
[root@jyrac1soft]#cd/u01/app/product/11.2.0/crs[root@jyrac1crs]#mvOPatchOPatch_bak[root@jyrac2soft]#cd/u01/app/product/11.2.0/crs[root@jyrac2crs]#mvOPatchOPatch_bak[root@jyrac1db]#cd/u01/app/oracle/product/11.2.0/db[root@jyrac1db]#mvOPatchOPatch_bak[root@jyrac2crs]#cd/u01/app/oracle/product/11.2.0/db[root@jyrac2db]#mvOPatchOPatch_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/patch21203.pl
inflating: OPatch/crs/installPatch.excl
inflating: OPatch/crs/patch21202.pl
inflating: OPatch/crs/auto_patch.pl
creating: OPatch/crs/log/
inflating: OPatch/crs/patch212.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@jyrac2soft]#unzipp6880880_112000_Linux-x86-64.zipArchive:p6880880_112000_Linux-x86-64.zipcreating:OPatch/inflating:OPatch/opatchdiaginflating:OPatch/opatch.plcreating:OPatch/jlib/inflating:OPatch/jlib/oracle.opatchcore.classpath.jarinflating:OPatch/jlib/opatch.jarinflating:OPatch/jlib/oracle.opatch.classpath.jarinflating:OPatch/jlib/oracle.opatch.classpath.unix.jarinflating:OPatch/jlib/oracle.opatch.classpath.windows.jarinflating:OPatch/jlib/opatchsdk.jarinflating:OPatch/jlib/oracle.opatchcore.classpath.unix.jarinflating:OPatch/jlib/oracle.opatchcore.classpath.windows.jarcreating:OPatch/crs/inflating:OPatch/crs/patch21203.plinflating:OPatch/crs/installPatch.exclinflating:OPatch/crs/patch21202.plinflating:OPatch/crs/auto_patch.plcreating:OPatch/crs/log/inflating:OPatch/crs/patch212.plinflating:OPatch/crs/patchDB.plinflating:OPatch/crs/opatchautoinflating:OPatch/crs/CRSProductDriver.jarinflating:OPatch/crs/driver.jarcreating:OPatch/ocm/creating:OPatch/ocm/doc/extracting:OPatch/ocm/ocm.zipinflating:OPatch/ocm/ocm_platforms.txtcreating:OPatch/ocm/lib/inflating:OPatch/ocm/lib/emocmclnt.jarinflating:OPatch/ocm/lib/xmlparserv2.jarinflating:OPatch/ocm/lib/http_client.jarinflating:OPatch/ocm/lib/emocmclnt-14.jarinflating:OPatch/ocm/lib/regexp.jarinflating:OPatch/ocm/lib/jnet.jarinflating:OPatch/ocm/lib/jsse.jarinflating:OPatch/ocm/lib/osdt_core3.jarinflating:OPatch/ocm/lib/osdt_jce.jarinflating:OPatch/ocm/lib/emocmcommon.jarinflating:OPatch/ocm/lib/log4j-core.jarinflating:OPatch/ocm/lib/jcert.jarcreating:OPatch/ocm/bin/inflating:OPatch/ocm/bin/emocmrspinflating:OPatch/opatchcreating:OPatch/opatchauto-dir/creating:OPatch/opatchauto-dir/opatchautocore/inflating:OPatch/opatchauto-dir/opatchautocore/oplaninflating:OPatch/opatchauto-dir/opatchautocore/opatchautobinarycreating:OPatch/opatchauto-dir/opatchautocore/jlib/inflating:OPatch/opatchauto-dir/opatchautocore/jlib/ValidationRules.jarinflating:OPatch/opatchauto-dir/opatchautocore/jlib/patchsdk.jarinflating:OPatch/opatchauto-dir/opatchautocore/jlib/ProductDriver.jarinflating:OPatch/opatchauto-dir/opatchautocore/jlib/osysmodel-utils.jarinflating:OPatch/opatchauto-dir/opatchautocore/jlib/OsysModel.jarcreating:OPatch/opatchauto-dir/opatchautocore/jlib/apache-commons/inflating:OPatch/opatchauto-dir/opatchautocore/jlib/apache-commons/commons-compress-1.4.jarinflating:OPatch/opatchauto-dir/opatchautocore/jlib/apache-commons/commons-cli-1.0.jarinflating:OPatch/opatchauto-dir/opatchautocore/jlib/oplan_core.jarinflating:OPatch/opatchauto-dir/opatchautocore/jlib/oracle.oplan.classpath.jarinflating:OPatch/opatchauto-dir/opatchautocore/jlib/bundle.jarinflating:OPatch/opatchauto-dir/opatchautocore/jlib/oplan_sample.jarinflating:OPatch/opatchauto-dir/opatchautocore/jlib/Validation.jarcreating:OPatch/opatchauto-dir/opatchautocore/jlib/jaxb/inflating:OPatch/opatchauto-dir/opatchautocore/jlib/jaxb/activation.jarinflating:OPatch/opatchauto-dir/opatchautocore/jlib/jaxb/jsr173_1.0_api.jarinflating:OPatch/opatchauto-dir/opatchautocore/jlib/jaxb/jaxb-api.jarinflating:OPatch/opatchauto-dir/opatchautocore/jlib/jaxb/jaxb-impl.jarinflating:OPatch/opatchauto-dir/opatchautocore/jlib/automation.jarinflating:OPatch/opatchauto-dir/opatchautocore/oplan.batinflating:OPatch/opatchauto-dir/opatchautocore/README.txtinflating:OPatch/opatchauto-dir/opatchautocore/README.htmlcreating:OPatch/opatchauto-dir/opatchautodb/creating:OPatch/opatchauto-dir/opatchautodb/jlib/inflating:OPatch/opatchauto-dir/opatchautodb/jlib/oracle.oplan.db.classpath.jarinflating:OPatch/opatchauto-dir/opatchautodb/jlib/oplan_db.jarinflating:OPatch/emdpatch.plcreating:OPatch/scripts/inflating:OPatch/scripts/opatch_wls.batinflating:OPatch/scripts/opatch_jvm_discovery.batinflating:OPatch/scripts/opatch_wlsinflating:OPatch/scripts/opatch_jvm_discoveryinflating:OPatch/operrinflating:OPatch/operr_readme.txtinflating:OPatch/operr.batcreating:OPatch/opatchprereqs/inflating:OPatch/opatchprereqs/prerequisite.propertiescreating:OPatch/opatchprereqs/oui/inflating:OPatch/opatchprereqs/oui/knowledgesrc.xmlcreating:OPatch/opatchprereqs/opatch/inflating:OPatch/opatchprereqs/opatch/runtime_prereq.xmlinflating:OPatch/opatchprereqs/opatch/rulemap.xmlinflating:OPatch/opatchprereqs/opatch/opatch_prereq.xmlinflating:OPatch/opatch.batcreating:OPatch/oplan/creating:OPatch/oplan/jlib/creating:OPatch/oplan/jlib/apache-commons/inflating:OPatch/oplan/jlib/apache-commons/commons-cli-1.0.jarcreating:OPatch/oplan/jlib/jaxb/inflating:OPatch/oplan/jlib/jaxb/jsr173_1.0_api.jarinflating:OPatch/oplan/jlib/jaxb/jaxb-impl.jarinflating:OPatch/oplan/jlib/jaxb/activation.jarinflating:OPatch/oplan/jlib/jaxb/jaxb-api.jarinflating:OPatch/oplan/jlib/Validation.jarinflating:OPatch/oplan/jlib/oracle.oplan.classpath.jarinflating:OPatch/oplan/jlib/OuiDriver.jarinflating:OPatch/oplan/jlib/EMrepoDrivers.jarinflating:OPatch/oplan/jlib/JMXDrivers.jarinflating:OPatch/oplan/jlib/bundle.jarinflating:OPatch/oplan/jlib/CRSProductDriver.jarinflating:OPatch/oplan/jlib/oplan.jarinflating:OPatch/oplan/jlib/ValidationRules.jarinflating:OPatch/oplan/jlib/osysmodel-utils.jarinflating:OPatch/oplan/jlib/automation.jarinflating:OPatch/oplan/README.htmlinflating:OPatch/oplan/README.txtinflating:OPatch/oplan/oplan.batinflating:OPatch/oplan/oplaninflating:OPatch/opatchdiag.batinflating:OPatch/README.txtextracting:OPatch/version.txtcreating:OPatch/docs/inflating:OPatch/docs/cversion.txtinflating:OPatch/docs/Prereq_Users_Guide.txtinflating:OPatch/docs/FAQinflating:OPatch/docs/Users_Guide.txt
以root用户执行以下命令:
[root@jyrac1soft]#cp-ROPatch/u01/app/product/11.2.0/crs/[root@jyrac1~]$cd/u01/app/product/11.2.0/crs/[root@jyrac1~]$chown-Rgrid:oinstallOPatch[root@jyrac2soft]#cp-ROPatch/u01/app/product/11.2.0/crs/[root@jyrac2~]$cd/u01/app/product/11.2.0/crs/[root@jyrac2~]$chown-Rgrid:oinstallOPatch[root@jyrac1soft]#cp-ROPatch/u01/app/oracle/product/11.2.0/db/[root@jyrac1soft]#cd/u01/app/oracle/product/11.2.0/db[root@jyrac1db]#chown-Roracle:oinstallOPatch[root@jyrac2soft]#cp-ROPatch/u01/app/oracle/product/11.2.0/db/[root@jyrac2soft]#cd/u01/app/oracle/product/11.2.0/db[root@jyrac2db]#chown-Roracle:oinstallOPatch
以grid与oracle用户来进行测试
[root@jyrac1crs]#su-grid[grid@jyrac1~]$cd/u01/app/product/11.2.0/crs/OPatch[grid@jyrac1OPatch]$./opatchversionOPatchVersion:11.2.0.3.12OPatchsucceeded.[root@jyrac2crs]#su-grid[grid@jyrac2~]$cd/u01/app/product/11.2.0/crs/OPatch/[grid@jyrac2OPatch]$./opatchversionOPatchVersion:11.2.0.3.12OPatchsucceeded.
[root@jyrac1db]#su-oracle[oracle@jyrac1~]$cd/u01/app/oracle/product/11.2.0/db/OPatch[oracle@jyrac1OPatch]$./opatchversionOPatchVersion:11.2.0.3.12OPatchsucceeded.[root@jyrac2db]#su-oracle[oracle@jyrac2~]$cd/u01/app/oracle/product/11.2.0/db/OPatch[oracle@jyrac2OPatch]$./opatchversionOPatchVersion:11.2.0.3.12OPatchsucceeded.
三.将补丁上传到所有节点并解压
[root@jyrac1soft]#unzipp22646198_112040_LINUX.zip[root@jyrac1u02]#chown-Rgrid:oinstall22646198[root@jyrac1u02]#chmod-R75522646198[root@jyrac2soft]#unzipp22646198_112040_LINUX.zip[root@jyrac2u02]#chown-Rgrid:oinstall22646198[root@jyrac2u02]#chmod-R75522646198
四.检查需要打的补丁与现有补丁是否冲突
[grid@jyrac1OPatch]$cd/u02/22646198/[grid@jyrac122646198]$$ORACLE_HOME/OPatch/opatchprereqCheckConflictAgainstOHWithDetail-ph./OracleInterimPatchInstallerversion11.2.0.3.12Copyright(c)2016,OracleCorporation.Allrightsreserved.PREREQsessionOracleHome:/u01/app/product/11.2.0/crsCentralInventory:/u01/app/oraInventoryfrom:/u01/app/product/11.2.0/crs/oraInst.locOPatchversion:11.2.0.3.12OUIversion:11.2.0.4.0Logfilelocation:/u01/app/product/11.2.0/crs/cfgtoollogs/opatch/opatch3016-05-11_21-54-31PM_1.logInvokingprereq"checkconflictagainstohwithdetail"Prereq"checkConflictAgainstOHWithDetail"passed.OPatchsucceeded.
[grid@jyrac2OPatch]$cd/u02/22646198/[grid@jyrac222646198]$$ORACLE_HOME/OPatch/opatchprereqCheckConflictAgainstOHWithDetail-ph./OracleInterimPatchInstallerversion11.2.0.3.12Copyright(c)2016,OracleCorporation.Allrightsreserved.PREREQsessionOracleHome:/u01/app/product/11.2.0/crsCentralInventory:/u01/app/oraInventoryfrom:/u01/app/product/11.2.0/crs/oraInst.locOPatchversion:11.2.0.3.12OUIversion:11.2.0.4.0Logfilelocation:/u01/app/product/11.2.0/crs/cfgtoollogs/opatch/opatch3016-05-11_21-54-31PM_1.logInvokingprereq"checkconflictagainstohwithdetail"Prereq"checkConflictAgainstOHWithDetail"passed.OPatchsucceeded.
五.OPatch apply(所有节点均需执行)(无需关闭任何组件及资源)
[root@jyrac1u02]#exportORACLE_HOME=/u01/app/product/11.2.0/crs[root@jyrac1u02]#$ORACLE_HOME/OPatch/opatchauto/u02/22646198/-oh$ORACLE_HOME/-ocmrf$ORACLE_HOME/OPatch/ocm/bin/emocmrspExecuting/u01/app/product/11.2.0/crs/perl/bin/perl/u01/app/product/11.2.0/crs/OPatch/crs/patch21203.pl-patchdir/u02-patchn22646198-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_paramsThisisthemainlogfile:/u01/app/product/11.2.0/crs/cfgtoollogs/opatchauto2016-05-11_21-59-41.logThisfilewillshowyourdetectedconfigurationandallthestepsthatopatchautoattemptedtodoonyoursystem:/u01/app/product/11.2.0/crs/cfgtoollogs/opatchauto2016-05-11_21-59-41.report.log2016-05-1121:59:41:StartingClusterwarePatchSetupUsingconfigurationparameterfile:/u01/app/product/11.2.0/crs/crs/install/crsconfig_paramsStoppingCRS...StoppedCRSsuccessfullypatch/u02/22646198/22502456applysuccessfulforhome/u01/app/product/11.2.0/crspatch/u02/22646198/22502549applysuccessfulforhome/u01/app/product/11.2.0/crspatch/u02/22646198/22502505applysuccessfulforhome/u01/app/product/11.2.0/crsStartingCRS...InstallingTraceFileAnalyzerCRS-4123:OracleHighAvailabilityServiceshasbeenstarted.opatchautosucceeded.
[root@jyrac2app]#exportORACLE_HOME=/u01/app/product/11.2.0/crs[root@jyrac2app]#$ORACLE_HOME/OPatch/opatchauto/u02/22646198/-oh$ORACLE_HOME/-ocmrf$ORACLE_HOME/OPatch/ocm/bin/emocmrspExecuting/u01/app/product/11.2.0/crs/perl/bin/perl/u01/app/product/11.2.0/crs/OPatch/crs/patch21203.pl-patchdir/u02-patchn22646198-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_paramsThisisthemainlogfile:/u01/app/product/11.2.0/crs/cfgtoollogs/opatchauto2016-05-11_22-32-49.logThisfilewillshowyourdetectedconfigurationandallthestepsthatopatchautoattemptedtodoonyoursystem:/u01/app/product/11.2.0/crs/cfgtoollogs/opatchauto2016-05-11_22-32-49.report.log2016-05-1122:32:49:StartingClusterwarePatchSetupUsingconfigurationparameterfile:/u01/app/product/11.2.0/crs/crs/install/crsconfig_paramsStoppingCRS...StoppedCRSsuccessfullypatch/u02/22646198/22502456applysuccessfulforhome/u01/app/product/11.2.0/crspatch/u02/22646198/22502549applysuccessfulforhome/u01/app/product/11.2.0/crspatch/u02/22646198/22502505applysuccessfulforhome/u01/app/product/11.2.0/crsStartingCRS...InstallingTraceFileAnalyzerCRS-4123:OracleHighAvailabilityServiceshasbeenstarted.opatchautosucceeded.
[grid@jyrac1app]$crsctlstatres-t--------------------------------------------------------------------------------NAMETARGETSTATESERVERSTATE_DETAILS--------------------------------------------------------------------------------LocalResources--------------------------------------------------------------------------------ora.CRSDG.dgONLINEONLINEjyrac1ONLINEONLINEjyrac2ora.DATADG.dgONLINEONLINEjyrac1ONLINEONLINEjyrac2ora.LISTENER.lsnrONLINEONLINEjyrac1ONLINEONLINEjyrac2ora.asmONLINEONLINEjyrac1StartedONLINEONLINEjyrac2Startedora.gsdONLINEOFFLINEjyrac1ONLINEOFFLINEjyrac2ora.net1.networkONLINEONLINEjyrac1ONLINEONLINEjyrac2ora.onsONLINEONLINEjyrac1ONLINEONLINEjyrac2ora.registry.acfsONLINEONLINEjyrac1ONLINEONLINEjyrac2--------------------------------------------------------------------------------ClusterResources--------------------------------------------------------------------------------ora.LISTENER_SCAN1.lsnr1ONLINEONLINEjyrac1ora.cvu1ONLINEONLINEjyrac1ora.jyrac.db1ONLINEONLINEjyrac1Open2ONLINEOFFLINEInstanceShutdownora.jyrac1.vip1ONLINEONLINEjyrac1ora.jyrac2.vip1ONLINEONLINEjyrac2ora.oc4j1ONLINEONLINEjyrac1ora.scan1.vip1ONLINEONLINEjyrac1
显示opatch成功，但是实例jyrac2不能启动，于是手动启动.
[oracle@jyrac2trace]$sqlplus/assysdbaSQL*Plus:Release11.2.0.4.0ProductiononWedMay1122:45:532016Copyright(c)1982,2013,Oracle.Allrightsreserved.Connectedtoanidleinstance.SQL>startupORA-01078:failureinprocessingsystemparametersORA-01565:errorinidentifyingfile'+DATADG/jyrac/spfilejyrac.ora'ORA-17503:ksfdopn:2Failedtoopenfile+DATADG/jyrac/spfilejyrac.oraORA-01034:ORACLEnotavailableORA-27123:unabletoattachtosharedmemorysegmentLinuxError:13:PermissiondeniedAdditionalinformation:26Additionalinformation:786438
错误信息显示没有权限来访问磁盘组中的参数文件,可能是$ORACLE_HOME/bin/oracle权限出问题了。
[grid@jyrac2crs]$ls-l$ORACLE_HOME/bin/oracle-rwxr-x--x1gridoinstall174947566Dec216:01/u01/app/product/11.2.0/crs/bin/oracle[grid@jyrac2crs]$chmod6751$ORACLE_HOME/bin/oracle[grid@jyrac2crs]$ls-l$ORACLE_HOME/bin/oracle-rwsr-s--x1gridoinstall174947566Dec216:01/u01/app/product/11.2.0/crs/bin/oracle[oracle@jyrac2dbs]$ls-l$ORACLE_HOME/bin/oracle-rwsr-xr-x1oracleasmadmin198797109Dec219:16/u01/app/oracle/product/11.2.0/db/bin/oracle[oracle@jyrac2dbs]$chmod6751$ORACLE_HOME/bin/oracle[oracle@jyrac2dbs]$ls-l$ORACLE_HOME/bin/oracle-rwsr-x--x1oracleasmadmin198797109Dec219:16/u01/app/oracle/product/11.2.0/db/bin/oracleSQL>startupORACLEinstancestarted.TotalSystemGlobalArea669581312bytesFixedSize1366724bytesVariableSize243270972bytesDatabaseBuffers419430400bytesRedoBuffers5513216bytesDatabasemounted.Databaseopened.
[root@jyrac1u02]#exportORACLE_HOME=/u01/app/oracle/product/11.2.0/db[root@jyrac1u02]#$ORACLE_HOME/OPatch/opatchauto/u02/22646198/-oh$ORACLE_HOME/-ocmrf$ORACLE_HOME/OPatch/ocm/bin/emocmrspExecuting/u01/app/product/11.2.0/crs/perl/bin/perl/u01/app/oracle/product/11.2.0/db/OPatch/crs/patch21203.pl-patchdir/u02-patchn22646198-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_paramsThisisthemainlogfile:/u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatchauto2016-05-11_22-56-19.logThisfilewillshowyourdetectedconfigurationandallthestepsthatopatchautoattemptedtodoonyoursystem:/u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatchauto2016-05-11_22-56-19.report.log2016-05-1122:56:19:StartingClusterwarePatchSetupUsingconfigurationparameterfile:/u01/app/product/11.2.0/crs/crs/install/crsconfig_paramsStoppingRAC/u01/app/oracle/product/11.2.0/db...StoppedRAC/u01/app/oracle/product/11.2.0/dbsuccessfullypatch/u02/22646198/22502456applysuccessfulforhome/u01/app/oracle/product/11.2.0/dbpatch/u02/22646198/22502549/custom/server/22502549applysuccessfulforhome/u01/app/oracle/product/11.2.0/dbStartingRAC/u01/app/oracle/product/11.2.0/db...Failedtostartresourcesfromdatabasehome/u01/app/oracle/product/11.2.0/dbERROR:Referlogfileformoredetails.opatchautofailed.
错误显示patch成功，但在启动RAC数据库时失败,于是手动启动实例jyrac1
[oracle@jyrac1OPatch]$sqlplus/assysdbaSQL*Plus:Release11.2.0.4.0ProductiononWedMay1123:05:012016Copyright(c)1982,2013,Oracle.Allrightsreserved.Connectedtoanidleinstance.SQL>startupORA-01078:failureinprocessingsystemparametersORA-01565:errorinidentifyingfile'+DATADG/jyrac/spfilejyrac.ora'ORA-17503:ksfdopn:10Failedtoopenfile+DATADG/jyrac/spfilejyrac.oraORA-12547:TNS:lostcontactSQL>exitDisconnected
错误信息显示没有权限来访问磁盘组中的参数文件,可能是$ORACLE_HOME/bin/oracle权限出问题了
[grid@jyrac1crs]$ls-l$ORACLE_HOME/bin/oracle-rwxr-x--x1gridoinstall174947566Dec216:01/u01/app/product/11.2.0/crs/bin/oracle[grid@jyrac1crs]$chmod6751$ORACLE_HOME/bin/oracle[grid@jyrac1crs]$ls-l$ORACLE_HOME/bin/oracle-rwsr-s--x1gridoinstall174947566Dec216:01/u01/app/product/11.2.0/crs/bin/oracle[oracle@jyrac1OPatch]$ls-l$ORACLE_HOME/bin/oracle-rwsr-s--x1oracleasmadmin198963317May1123:02/u01/app/oracle/product/11.2.0/db/bin/oracle[oracle@jyrac1OPatch]$chmod6751$ORACLE_HOME/bin/oracle[oracle@jyrac1OPatch]$ls-l$ORACLE_HOME/bin/oracle-rwsr-x--x1oracleasmadmin198963317May1123:02/u01/app/oracle/product/11.2.0/db/bin/oracle[oracle@jyrac1OPatch]$sqlplus/assysdbaSQL*Plus:Release11.2.0.4.0ProductiononWedMay1123:10:402016Copyright(c)1982,2013,Oracle.Allrightsreserved.Connectedtoanidleinstance.SQL>startupORACLEinstancestarted.TotalSystemGlobalArea669581312bytesFixedSize1366724bytesVariableSize243270972bytesDatabaseBuffers419430400bytesRedoBuffers5513216bytesDatabasemounted.Databaseopened.
[root@jyrac2app]#exportORACLE_HOME=/u01/app/oracle/product/11.2.0/db[root@jyrac2app]#$ORACLE_HOME/OPatch/opatchauto/u02/22646198/-oh$ORACLE_HOME/-ocmrf$ORACLE_HOME/OPatch/ocm/bin/emocmrspExecuting/u01/app/product/11.2.0/crs/perl/bin/perl/u01/app/oracle/product/11.2.0/db/OPatch/crs/patch21203.pl-patchdir/u02-patchn22646198-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_paramsThisisthemainlogfile:/u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatchauto2016-05-11_23-11-32.logThisfilewillshowyourdetectedconfigurationandallthestepsthatopatchautoattemptedtodoonyoursystem:/u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatchauto2016-05-11_23-11-32.report.log2016-05-1123:11:32:StartingClusterwarePatchSetupUsingconfigurationparameterfile:/u01/app/product/11.2.0/crs/crs/install/crsconfig_paramsStoppingRAC/u01/app/oracle/product/11.2.0/db...StoppedRAC/u01/app/oracle/product/11.2.0/dbsuccessfullypatch/u02/22646198/22502456applysuccessfulforhome/u01/app/oracle/product/11.2.0/dbpatch/u02/22646198/22502549/custom/server/22502549applysuccessfulforhome/u01/app/oracle/product/11.2.0/dbStartingRAC/u01/app/oracle/product/11.2.0/db...StartedRAC/u01/app/oracle/product/11.2.0/dbsuccessfullyopatchautosucceeded.
[grid@jyrac1app]$crsctlstatres-t--------------------------------------------------------------------------------NAMETARGETSTATESERVERSTATE_DETAILS--------------------------------------------------------------------------------LocalResources--------------------------------------------------------------------------------ora.CRSDG.dgONLINEONLINEjyrac1ONLINEONLINEjyrac2ora.DATADG.dgONLINEONLINEjyrac1ONLINEONLINEjyrac2ora.LISTENER.lsnrONLINEONLINEjyrac1ONLINEONLINEjyrac2ora.asmONLINEONLINEjyrac1StartedONLINEONLINEjyrac2Startedora.gsdONLINEOFFLINEjyrac1ONLINEOFFLINEjyrac2ora.net1.networkONLINEONLINEjyrac1ONLINEONLINEjyrac2ora.onsONLINEONLINEjyrac1ONLINEONLINEjyrac2ora.registry.acfsONLINEONLINEjyrac1ONLINEONLINEjyrac2--------------------------------------------------------------------------------ClusterResources--------------------------------------------------------------------------------ora.LISTENER_SCAN1.lsnr1ONLINEONLINEjyrac1ora.cvu1ONLINEONLINEjyrac1ora.jyrac.db1ONLINEONLINEjyrac1Open2ONLINEONLINEjyrac2Openora.jyrac1.vip1ONLINEONLINEjyrac1ora.jyrac2.vip1ONLINEONLINEjyrac2ora.oc4j1ONLINEONLINEjyrac1ora.scan1.vip1ONLINEONLINEjyrac1
成功后，我们还是更新脚本（仅仅在第一节点)
登陆数据库执行脚本
oracle@jyrac1u02]$cd$ORACLE_HOME/rdbms/adminoracle@jyrac1admin]$sqlplus/assysdbaSQL*Plus:Release11.2.0.4.0ProductiononThuMay1208:28:052016Copyright(c)1982,2013,Oracle.Allrightsreserved.Connectedto:OracleDatabase11gEnterpriseEditionRelease11.2.0.4.0-ProductionWiththePartitioning,RealApplicationClusters,AutomaticStorageManagement,OLAP,DataMiningandRealApplicationTestingoptionsSQL>@catbundle.sqlpsuapply
六.验证
[grid@jyrac1app]$$ORACLE_HOME/OPatch/opatchlspatches22502505;ACFSPatchSetUpdate:11.2.0.4.160419(22502505)22502549;OCWPatchSetUpdate:11.2.0.4.160419(22502549)22502456;DatabasePatchSetUpdate:11.2.0.4.160419(22502456)OPatchsucceeded.[grid@jyrac2crs]$$ORACLE_HOME/OPatch/opatchlspatches22502505;ACFSPatchSetUpdate:11.2.0.4.160419(22502505)22502549;OCWPatchSetUpdate:11.2.0.4.160419(22502549)22502456;DatabasePatchSetUpdate:11.2.0.4.160419(22502456)OPatchsucceeded.[oracle@jyrac1admin]$$ORACLE_HOME/OPatch/opatchlspatches22502549;OCWPatchSetUpdate:11.2.0.4.160419(22502549)22502456;DatabasePatchSetUpdate:11.2.0.4.160419(22502456)OPatchsucceeded.[oracle@jyrac2dbs]$$ORACLE_HOME/OPatch/opatchlspatches22502549;OCWPatchSetUpdate:11.2.0.4.160419(22502549)22502456;DatabasePatchSetUpdate:11.2.0.4.160419(22502456)OPatchsucceeded.
或者
[grid@jyrac1app]$$ORACLE_HOME/OPatch/opatchlsinventoryOracleInterimPatchInstallerversion11.2.0.3.12Copyright(c)2016,OracleCorporation.Allrightsreserved.OracleHome:/u01/app/product/11.2.0/crsCentralInventory:/u01/app/oraInventoryfrom:/u01/app/product/11.2.0/crs/oraInst.locOPatchversion:11.2.0.3.12OUIversion:11.2.0.4.0Logfilelocation:/u01/app/product/11.2.0/crs/cfgtoollogs/opatch/opatch3016-05-12_08-32-14AM_1.logLsinventoryOutputfilelocation:/u01/app/product/11.2.0/crs/cfgtoollogs/opatch/lsinv/lsinventory2016-05-12_08-32-14AM.txt--------------------------------------------------------------------------------LocalMachineInformation::Hostname:jyrac1ARUplatformid:46ARUplatformdescription::Linuxx86InstalledTop-levelProducts(1):OracleGridInfrastructure11g11.2.0.4.0Thereare1productsinstalledinthisOracleHome.Interimpatches(3):Patch22502505:appliedonWedMay1122:07:58CST2016UniquePatchID:19945546Patchdescription:"ACFSPatchSetUpdate:11.2.0.4.160419(22502505)"Createdon4Mar2016,00:05:12hrsPST8PDTBugsfixed:21369858,16318126,19690653,17503605,17203009,17359415,2014014817611362,17164243,19053182,17696547,17488768,18168684,2151979618143006,21208140,17428148,17070158,20438706,17510275,1717230318610307,17376318,17721778,22198405,17699423,18915417,1815533418321597,19919907,18185024,17636008,17363999,20681968,17475946Patch22502549:appliedonWedMay1122:07:25CST2016UniquePatchID:19945546Patchdescription:"OCWPatchSetUpdate:11.2.0.4.160419(22502549)"Createdon18Mar2016,05:57:45hrsPST8PDTBugsfixed:19270660,18328800,18508710,18691572,20038451,21251192,2123239420365005,17750548,17387214,17617807,14497275,20219458,1773392718180541,18962892,17292250,17378618,16759171,20110156,1784348917065496,13991403,17273020,17155238,20012766,21245437,1826118318053580,20218012,17013634,17886392,20995001,17039197,1794778516317771,10052729,22353346,20340620,16237657,20317221,1591786918199185,18399991,20186278,17374271,18024089,16849642,2074625120246071,14270845,20552947,18882642,18414137,17001914,1792797014378120,16346413,15986647,18068871,21222147,18143836,1620699721982225,19168690,20235511,18343490,21875360,16613232,1927679117722664,20440643,12928658,18952577,18520351,16249829,1822614316076412,18265482,18229842,17172091,20676340,17818075,2009175318231837,14373486,20136892,17483479,20551654,18120545,1872916613843841,21225209,17405302,18709496,18330979,18744838,1708737120531190,14525998,18187697,20598625,14385860,18348155,1947950312928592,17516024,18370031,17764053,19272663,17551223,1467140818272135,14207615,21255373,17500165,18875012,14769643,1846478419558324,18848125,19241857,14851828,17955615,20315294,1469333616284825,17352230,20014326,17238586,17089344,17405605,2132740217531342,19398098,17159489,17640316,13823394,16543190,2202421717983675,20795241,17598201,17481314,16281493,18346135,1598631119601468,17208793,18700935,18999857,14076173,18428146,1835284517435488,20408163,17592037,18352846,19616601,17391726,1738777914777968,15851860,16206882,20141091,21113068,20175174,1730510015832129,19885321,16901346,17985714,18536826,17780903,1875237818946768,16876500,16875342,17769597,19955755,16429265,1833645217273003,17209968,16988311,20094984,19319357,17059927,1704646018053631,16867761,18774591,21442094,20235486,19359787,1586977519642566,17447588,16798862,15920201Patch22502456:appliedonWedMay1122:05:13CST2016UniquePatchID:19878058Patchdescription:"DatabasePatchSetUpdate:11.2.0.4.160419(22502456)"Createdon9Mar2016,19:56:01hrsSub-patch21948347;"DatabasePatchSetUpdate:11.2.0.4.160119(21948347)"Sub-patch21352635;"DatabasePatchSetUpdate:11.2.0.4.8(21352635)"Sub-patch20760982;"DatabasePatchSetUpdate:11.2.0.4.7(20760982)"Sub-patch20299013;"DatabasePatchSetUpdate:11.2.0.4.6(20299013)"Sub-patch19769489;"DatabasePatchSetUpdate:11.2.0.4.5(19769489)"Sub-patch19121551;"DatabasePatchSetUpdate:11.2.0.4.4(19121551)"Sub-patch18522509;"DatabasePatchSetUpdate:11.2.0.4.3(18522509)"Sub-patch18031668;"DatabasePatchSetUpdate:11.2.0.4.2(18031668)"Sub-patch17478514;"DatabasePatchSetUpdate:11.2.0.4.1(17478514)"Bugsfixed:17288409,21051852,17811429,18607546,17205719,20506699,1781686517922254,17754782,16934803,13364795,17311728,17441661,1728481716992075,17446237,14015842,19972569,21756677,21538558,2092579517449815,17375354,19463897,13866822,17982555,17235750,1747851418317531,14338435,18235390,20803583,13944971,20142975,1781178916929165,18704244,20506706,17546973,20334344,14054676,1708806817346091,18264060,17343514,21538567,19680952,18471685,1921172413951456,21847223,16315398,18744139,16850630,19049453,1867330417883081,19915271,18641419,18262334,17006183,16065166,1827745416833527,10136473,18051556,17865671,17852463,18554871,1785349818334586,17551709,17588480,19827973,17344412,17842825,1882886817025461,11883252,13609098,17239687,17602269,19197175,2219545718316692,17313525,12611721,19544839,18964939,17600719,1819116419393542,17571306,18482502,20777150,19466309,17040527,1716520418098207,16785708,17465741,17174582,16180763,16777840,1298256619463893,22195465,16875449,12816846,17237521,19358317,1781143817811447,21983325,17945983,18762750,16912439,17184721,1806191417282229,18331850,18202441,17082359,18723434,21972320,1955410614034426,18339044,19458377,17752995,20448824,17891943,1725809017767676,16668584,18384391,17040764,17381384,15913355,1835616614084247,20596234,20506715,21756661,13853126,18203837,1424553121756699,16043574,22195441,17848897,17877323,21453153,1746814120861693,17786518,17912217,17037130,18155762,16956380,1747814517394950,18641461,18189036,18619917,17027426,21352646,1626842522195492,19584068,18436307,17265217,17634921,13498382,2152604819258504,20004087,17443671,22195485,18000422,20004021,2232175617571039,21067387,16344544,18009564,14354737,21286665,1813567818614015,20441797,18362222,17835048,16472716,17936109,1705088817325413,14010183,18747196,17761775,16721594,17082983,2006721221179898,17302277,18084625,15990359,18203835,17297939,1781145616731148,21168487,13829543,17215560,14133975,17694209,1738517818091059,8322815,17586955,17201159,17655634,18331812,1973050818868646,17648596,16220077,16069901,17348614,17393915,1727453717957017,18096714,17308789,18436647,14285317,19289642,1476482918328509,17622427,22195477,16943711,22502493,14368995,1734667118996843,17783588,21343838,16618694,17672719,18856999,1878322417851160,17546761,17798953,18273830,22092979,16596890,1997256616384983,17726838,17360606,22321741,13645875,18199537,1654288621787056,17889549,14565184,17071721,17610798,20299015,2134389722893153,20657441,17397545,18230522,16360112,19769489,1290505818641451,12747740,18430495,17016369,17042658,14602788,1755106319972568,21517440,18508861,19788842,14657740,17332800,1383737819972564,17186905,18315328,19699191,17437634,22353199,1809361519006849,19013183,17296856,18674024,17232014,16855292,1776229614692762,21051840,17705023,19121551,21330264,19854503,2186872019309466,18681862,18554763,20558005,17390160,18456514,1630637313955826,18139690,17501491,17752121,21668627,17299889,1788958318673325,19721304,18293054,17242746,17951233,17649265,1809424619615136,17011832,16870214,17477958,18522509,20631274,1609163717323222,16595641,16524926,18228645,18282562,17596908,1715614818031668,16494615,22683225,17545847,17655240,17614134,1355855717341326,17891946,17716305,16392068,19271443,21351877,1809212718440047,17614227,14106803,16903536,18973907,18673342,1903286717389192,17612828,16194160,17006570,17721717,17390431,1757024016863422,18325460,19727057,16422541,19972570,17267114,1824496221538485,18765602,18203838,16198143,17246576,14829250,1783562718247991,14458214,21051862,16692232,17786278,17227277,1604267316314254,16228604,16837842,17393683,17787259,20331945,2007439115861775,16399083,18018515,22683212,18260550,21051858,1703697316613964,17080436,16579084,18384537,18280813,20296213,1690138515979965,18441944,16450169,9756271,17892268,11733603,1628569117587063,21343775,16538760,18180390,18193833,21387964,2105183317238511,17824637,16571443,18306996,14852021,18674047,1785345612364061,22195448RacsystemcomprisingofmultiplenodesLocalnode=jyrac1Remotenode=jyrac2--------------------------------------------------------------------------------OPatchsucceeded.[grid@jyrac2crs]$$ORACLE_HOME/OPatch/opatchlsinventoryOracleInterimPatchInstallerversion11.2.0.3.12Copyright(c)2016,OracleCorporation.Allrightsreserved.OracleHome:/u01/app/product/11.2.0/crsCentralInventory:/u01/app/oraInventoryfrom:/u01/app/product/11.2.0/crs/oraInst.locOPatchversion:11.2.0.3.12OUIversion:11.2.0.4.0Logfilelocation:/u01/app/product/11.2.0/crs/cfgtoollogs/opatch/opatch3016-05-12_08-32-27AM_1.logLsinventoryOutputfilelocation:/u01/app/product/11.2.0/crs/cfgtoollogs/opatch/lsinv/lsinventory2016-05-12_08-32-27AM.txt--------------------------------------------------------------------------------LocalMachineInformation::Hostname:jyrac2ARUplatformid:46ARUplatformdescription::Linuxx86InstalledTop-levelProducts(1):OracleGridInfrastructure11g11.2.0.4.0Thereare1productsinstalledinthisOracleHome.Interimpatches(3):Patch22502505:appliedonWedMay1122:07:58CST2016UniquePatchID:19945546Patchdescription:"ACFSPatchSetUpdate:11.2.0.4.160419(22502505)"Createdon4Mar2016,00:05:12hrsPST8PDTBugsfixed:21369858,16318126,19690653,17503605,17203009,17359415,2014014817611362,17164243,19053182,17696547,17488768,18168684,2151979618143006,21208140,17428148,17070158,20438706,17510275,1717230318610307,17376318,17721778,22198405,17699423,18915417,1815533418321597,19919907,18185024,17636008,17363999,20681968,17475946Patch22502549:appliedonWedMay1122:07:25CST2016UniquePatchID:19945546Patchdescription:"OCWPatchSetUpdate:11.2.0.4.160419(22502549)"Createdon18Mar2016,05:57:45hrsPST8PDTBugsfixed:19270660,18328800,18508710,18691572,20038451,21251192,2123239420365005,17750548,17387214,17617807,14497275,20219458,1773392718180541,18962892,17292250,17378618,16759171,20110156,1784348917065496,13991403,17273020,17155238,20012766,21245437,1826118318053580,20218012,17013634,17886392,20995001,17039197,1794778516317771,10052729,22353346,20340620,16237657,20317221,1591786918199185,18399991,20186278,17374271,18024089,16849642,2074625120246071,14270845,20552947,18882642,18414137,17001914,1792797014378120,16346413,15986647,18068871,21222147,18143836,1620699721982225,19168690,20235511,18343490,21875360,16613232,1927679117722664,20440643,12928658,18952577,18520351,16249829,1822614316076412,18265482,18229842,17172091,20676340,17818075,2009175318231837,14373486,20136892,17483479,20551654,18120545,1872916613843841,21225209,17405302,18709496,18330979,18744838,1708737120531190,14525998,18187697,20598625,14385860,18348155,1947950312928592,17516024,18370031,17764053,19272663,17551223,1467140818272135,14207615,21255373,17500165,18875012,14769643,1846478419558324,18848125,19241857,14851828,17955615,20315294,1469333616284825,17352230,20014326,17238586,17089344,17405605,2132740217531342,19398098,17159489,17640316,13823394,16543190,2202421717983675,20795241,17598201,17481314,16281493,18346135,1598631119601468,17208793,18700935,18999857,14076173,18428146,1835284517435488,20408163,17592037,18352846,19616601,17391726,1738777914777968,15851860,16206882,20141091,21113068,20175174,1730510015832129,19885321,16901346,17985714,18536826,17780903,1875237818946768,16876500,16875342,17769597,19955755,16429265,1833645217273003,17209968,16988311,20094984,19319357,17059927,1704646018053631,16867761,18774591,21442094,20235486,19359787,1586977519642566,17447588,16798862,15920201Patch22502456:appliedonWedMay1122:05:13CST2016UniquePatchID:19878058Patchdescription:"DatabasePatchSetUpdate:11.2.0.4.160419(22502456)"Createdon9Mar2016,19:56:01hrsSub-patch21948347;"DatabasePatchSetUpdate:11.2.0.4.160119(21948347)"Sub-patch21352635;"DatabasePatchSetUpdate:11.2.0.4.8(21352635)"Sub-patch20760982;"DatabasePatchSetUpdate:11.2.0.4.7(20760982)"Sub-patch20299013;"DatabasePatchSetUpdate:11.2.0.4.6(20299013)"Sub-patch19769489;"DatabasePatchSetUpdate:11.2.0.4.5(19769489)"Sub-patch19121551;"DatabasePatchSetUpdate:11.2.0.4.4(19121551)"Sub-patch18522509;"DatabasePatchSetUpdate:11.2.0.4.3(18522509)"Sub-patch18031668;"DatabasePatchSetUpdate:11.2.0.4.2(18031668)"Sub-patch17478514;"DatabasePatchSetUpdate:11.2.0.4.1(17478514)"Bugsfixed:17288409,21051852,17811429,18607546,17205719,20506699,1781686517922254,17754782,16934803,13364795,17311728,17441661,1728481716992075,17446237,14015842,19972569,21756677,21538558,2092579517449815,17375354,19463897,13866822,17982555,17235750,1747851418317531,14338435,18235390,20803583,13944971,20142975,1781178916929165,18704244,20506706,17546973,20334344,14054676,1708806817346091,18264060,17343514,21538567,19680952,18471685,1921172413951456,21847223,16315398,18744139,16850630,19049453,1867330417883081,19915271,18641419,18262334,17006183,16065166,1827745416833527,10136473,18051556,17865671,17852463,18554871,1785349818334586,17551709,17588480,19827973,17344412,17842825,1882886817025461,11883252,13609098,17239687,17602269,19197175,2219545718316692,17313525,12611721,19544839,18964939,17600719,1819116419393542,17571306,18482502,20777150,19466309,17040527,1716520418098207,16785708,17465741,17174582,16180763,16777840,1298256619463893,22195465,16875449,12816846,17237521,19358317,1781143817811447,21983325,17945983,18762750,16912439,17184721,1806191417282229,18331850,18202441,17082359,18723434,21972320,1955410614034426,18339044,19458377,17752995,20448824,17891943,1725809017767676,16668584,18384391,17040764,17381384,15913355,1835616614084247,20596234,20506715,21756661,13853126,18203837,1424553121756699,16043574,22195441,17848897,17877323,21453153,1746814120861693,17786518,17912217,17037130,18155762,16956380,1747814517394950,18641461,18189036,18619917,17027426,21352646,1626842522195492,19584068,18436307,17265217,17634921,13498382,2152604819258504,20004087,17443671,22195485,18000422,20004021,2232175617571039,21067387,16344544,18009564,14354737,21286665,1813567818614015,20441797,18362222,17835048,16472716,17936109,1705088817325413,14010183,18747196,17761775,16721594,17082983,2006721221179898,17302277,18084625,15990359,18203835,17297939,1781145616731148,21168487,13829543,17215560,14133975,17694209,1738517818091059,8322815,17586955,17201159,17655634,18331812,1973050818868646,17648596,16220077,16069901,17348614,17393915,1727453717957017,18096714,17308789,18436647,14285317,19289642,1476482918328509,17622427,22195477,16943711,22502493,14368995,1734667118996843,17783588,21343838,16618694,17672719,18856999,1878322417851160,17546761,17798953,18273830,22092979,16596890,1997256616384983,17726838,17360606,22321741,13645875,18199537,1654288621787056,17889549,14565184,17071721,17610798,20299015,2134389722893153,20657441,17397545,18230522,16360112,19769489,1290505818641451,12747740,18430495,17016369,17042658,14602788,1755106319972568,21517440,18508861,19788842,14657740,17332800,1383737819972564,17186905,18315328,19699191,17437634,22353199,1809361519006849,19013183,17296856,18674024,17232014,16855292,1776229614692762,21051840,17705023,19121551,21330264,19854503,2186872019309466,18681862,18554763,20558005,17390160,18456514,1630637313955826,18139690,17501491,17752121,21668627,17299889,1788958318673325,19721304,18293054,17242746,17951233,17649265,1809424619615136,17011832,16870214,17477958,18522509,20631274,1609163717323222,16595641,16524926,18228645,18282562,17596908,1715614818031668,16494615,22683225,17545847,17655240,17614134,1355855717341326,17891946,17716305,16392068,19271443,21351877,1809212718440047,17614227,14106803,16903536,18973907,18673342,1903286717389192,17612828,16194160,17006570,17721717,17390431,1757024016863422,18325460,19727057,16422541,19972570,17267114,1824496221538485,18765602,18203838,16198143,17246576,14829250,1783562718247991,14458214,21051862,16692232,17786278,17227277,1604267316314254,16228604,16837842,17393683,17787259,20331945,2007439115861775,16399083,18018515,22683212,18260550,21051858,1703697316613964,17080436,16579084,18384537,18280813,20296213,1690138515979965,18441944,16450169,9756271,17892268,11733603,1628569117587063,21343775,16538760,18180390,18193833,21387964,2105183317238511,17824637,16571443,18306996,14852021,18674047,1785345612364061,22195448RacsystemcomprisingofmultiplenodesLocalnode=jyrac1Remotenode=jyrac2--------------------------------------------------------------------------------OPatchsucceeded.[oracle@jyrac1admin]$$ORACLE_HOME/OPatch/opatchlsinventoryOracleInterimPatchInstallerversion11.2.0.3.12Copyright(c)2016,OracleCorporation.Allrightsreserved.OracleHome:/u01/app/oracle/product/11.2.0/dbCentralInventory:/u01/app/oraInventoryfrom:/u01/app/oracle/product/11.2.0/db/oraInst.locOPatchversion:11.2.0.3.12OUIversion:11.2.0.4.0Logfilelocation:/u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch3016-05-12_08-32-35AM_1.logLsinventoryOutputfilelocation:/u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/lsinv/lsinventory2016-05-12_08-32-35AM.txt--------------------------------------------------------------------------------LocalMachineInformation::Hostname:jyrac1ARUplatformid:46ARUplatformdescription::Linuxx86InstalledTop-levelProducts(1):OracleDatabase11g11.2.0.4.0Thereare1productsinstalledinthisOracleHome.Interimpatches(2):Patch22502549:appliedonWedMay1123:03:19CST2016UniquePatchID:19945546Patchdescription:"OCWPatchSetUpdate:11.2.0.4.160419(22502549)"Createdon18Mar2016,05:57:37hrsPST8PDTBugsfixed:9999999Patch22502456:appliedonWedMay1123:01:20CST2016UniquePatchID:19878058Patchdescription:"DatabasePatchSetUpdate:11.2.0.4.160419(22502456)"Createdon9Mar2016,19:56:01hrsSub-patch21948347;"DatabasePatchSetUpdate:11.2.0.4.160119(21948347)"Sub-patch21352635;"DatabasePatchSetUpdate:11.2.0.4.8(21352635)"Sub-patch20760982;"DatabasePatchSetUpdate:11.2.0.4.7(20760982)"Sub-patch20299013;"DatabasePatchSetUpdate:11.2.0.4.6(20299013)"Sub-patch19769489;"DatabasePatchSetUpdate:11.2.0.4.5(19769489)"Sub-patch19121551;"DatabasePatchSetUpdate:11.2.0.4.4(19121551)"Sub-patch18522509;"DatabasePatchSetUpdate:11.2.0.4.3(18522509)"Sub-patch18031668;"DatabasePatchSetUpdate:11.2.0.4.2(18031668)"Sub-patch17478514;"DatabasePatchSetUpdate:11.2.0.4.1(17478514)"Bugsfixed:17288409,21051852,17811429,18607546,17205719,20506699,1781686517922254,17754782,16934803,13364795,17311728,17441661,1728481716992075,17446237,14015842,19972569,21756677,21538558,2092579517449815,17375354,19463897,13866822,17982555,17235750,1747851418317531,14338435,18235390,20803583,13944971,20142975,1781178916929165,18704244,20506706,17546973,20334344,14054676,1708806817346091,18264060,17343514,21538567,19680952,18471685,1921172413951456,21847223,16315398,18744139,16850630,19049453,1867330417883081,19915271,18641419,18262334,17006183,16065166,1827745416833527,10136473,18051556,17865671,17852463,18554871,1785349818334586,17551709,17588480,19827973,17344412,17842825,1882886817025461,11883252,13609098,17239687,17602269,19197175,2219545718316692,17313525,12611721,19544839,18964939,17600719,1819116419393542,17571306,18482502,20777150,19466309,17040527,1716520418098207,16785708,17465741,17174582,16180763,16777840,1298256619463893,22195465,16875449,12816846,17237521,19358317,1781143817811447,21983325,17945983,18762750,16912439,17184721,1806191417282229,18331850,18202441,17082359,18723434,21972320,1955410614034426,18339044,19458377,17752995,20448824,17891943,1725809017767676,16668584,18384391,17040764,17381384,15913355,1835616614084247,20596234,20506715,21756661,13853126,18203837,1424553121756699,16043574,22195441,17848897,17877323,21453153,1746814120861693,17786518,17912217,17037130,18155762,16956380,1747814517394950,18641461,18189036,18619917,17027426,21352646,1626842522195492,19584068,18436307,17265217,17634921,13498382,2152604819258504,20004087,17443671,22195485,18000422,20004021,2232175617571039,21067387,16344544,18009564,14354737,21286665,1813567818614015,20441797,18362222,17835048,16472716,17936109,1705088817325413,14010183,18747196,17761775,16721594,17082983,2006721221179898,17302277,18084625,15990359,18203835,17297939,1781145616731148,21168487,13829543,17215560,14133975,17694209,1738517818091059,8322815,17586955,17201159,17655634,18331812,1973050818868646,17648596,16220077,16069901,17348614,17393915,1727453717957017,18096714,17308789,18436647,14285317,19289642,1476482918328509,17622427,22195477,16943711,22502493,14368995,1734667118996843,17783588,21343838,16618694,17672719,18856999,1878322417851160,17546761,17798953,18273830,22092979,16596890,1997256616384983,17726838,17360606,22321741,13645875,18199537,1654288621787056,17889549,14565184,17071721,17610798,20299015,2134389722893153,20657441,17397545,18230522,16360112,19769489,1290505818641451,12747740,18430495,17016369,17042658,14602788,1755106319972568,21517440,18508861,19788842,14657740,17332800,1383737819972564,17186905,18315328,19699191,17437634,22353199,1809361519006849,19013183,17296856,18674024,17232014,16855292,1776229614692762,21051840,17705023,19121551,21330264,19854503,2186872019309466,18681862,18554763,20558005,17390160,18456514,1630637313955826,18139690,17501491,17752121,21668627,17299889,1788958318673325,19721304,18293054,17242746,17951233,17649265,1809424619615136,17011832,16870214,17477958,18522509,20631274,1609163717323222,16595641,16524926,18228645,18282562,17596908,1715614818031668,16494615,22683225,17545847,17655240,17614134,1355855717341326,17891946,17716305,16392068,19271443,21351877,1809212718440047,17614227,14106803,16903536,18973907,18673342,1903286717389192,17612828,16194160,17006570,17721717,17390431,1757024016863422,18325460,19727057,16422541,19972570,17267114,1824496221538485,18765602,18203838,16198143,17246576,14829250,1783562718247991,14458214,21051862,16692232,17786278,17227277,1604267316314254,16228604,16837842,17393683,17787259,20331945,2007439115861775,16399083,18018515,22683212,18260550,21051858,1703697316613964,17080436,16579084,18384537,18280813,20296213,1690138515979965,18441944,16450169,9756271,17892268,11733603,1628569117587063,21343775,16538760,18180390,18193833,21387964,2105183317238511,17824637,16571443,18306996,14852021,18674047,1785345612364061,22195448RacsystemcomprisingofmultiplenodesLocalnode=jyrac1Remotenode=jyrac2--------------------------------------------------------------------------------OPatchsucceeded.[oracle@jyrac2dbs]$$ORACLE_HOME/OPatch/opatchlsinventoryOracleInterimPatchInstallerversion11.2.0.3.12Copyright(c)2016,OracleCorporation.Allrightsreserved.OracleHome:/u01/app/oracle/product/11.2.0/dbCentralInventory:/u01/app/oraInventoryfrom:/u01/app/oracle/product/11.2.0/db/oraInst.locOPatchversion:11.2.0.3.12OUIversion:11.2.0.4.0Logfilelocation:/u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/opatch3016-05-12_08-32-33AM_1.logLsinventoryOutputfilelocation:/u01/app/oracle/product/11.2.0/db/cfgtoollogs/opatch/lsinv/lsinventory2016-05-12_08-32-33AM.txt--------------------------------------------------------------------------------LocalMachineInformation::Hostname:jyrac2ARUplatformid:46ARUplatformdescription::Linuxx86InstalledTop-levelProducts(1):OracleDatabase11g11.2.0.4.0Thereare1productsinstalledinthisOracleHome.Interimpatches(2):Patch22502549:appliedonWedMay1123:17:40CST2016UniquePatchID:19945546Patchdescription:"OCWPatchSetUpdate:11.2.0.4.160419(22502549)"Createdon18Mar2016,05:57:37hrsPST8PDTBugsfixed:9999999Patch22502456:appliedonWedMay1123:15:56CST2016UniquePatchID:19878058Patchdescription:"DatabasePatchSetUpdate:11.2.0.4.160419(22502456)"Createdon9Mar2016,19:56:01hrsSub-patch21948347;"DatabasePatchSetUpdate:11.2.0.4.160119(21948347)"Sub-patch21352635;"DatabasePatchSetUpdate:11.2.0.4.8(21352635)"Sub-patch20760982;"DatabasePatchSetUpdate:11.2.0.4.7(20760982)"Sub-patch20299013;"DatabasePatchSetUpdate:11.2.0.4.6(20299013)"Sub-patch19769489;"DatabasePatchSetUpdate:11.2.0.4.5(19769489)"Sub-patch19121551;"DatabasePatchSetUpdate:11.2.0.4.4(19121551)"Sub-patch18522509;"DatabasePatchSetUpdate:11.2.0.4.3(18522509)"Sub-patch18031668;"DatabasePatchSetUpdate:11.2.0.4.2(18031668)"Sub-patch17478514;"DatabasePatchSetUpdate:11.2.0.4.1(17478514)"Bugsfixed:17288409,21051852,17811429,18607546,17205719,20506699,1781686517922254,17754782,16934803,13364795,17311728,17441661,1728481716992075,17446237,14015842,19972569,21756677,21538558,2092579517449815,17375354,19463897,13866822,17982555,17235750,1747851418317531,14338435,18235390,20803583,13944971,20142975,1781178916929165,18704244,20506706,17546973,20334344,14054676,1708806817346091,18264060,17343514,21538567,19680952,18471685,1921172413951456,21847223,16315398,18744139,16850630,19049453,1867330417883081,19915271,18641419,18262334,17006183,16065166,1827745416833527,10136473,18051556,17865671,17852463,18554871,1785349818334586,17551709,17588480,19827973,17344412,17842825,1882886817025461,11883252,13609098,17239687,17602269,19197175,2219545718316692,17313525,12611721,19544839,18964939,17600719,1819116419393542,17571306,18482502,20777150,19466309,17040527,1716520418098207,16785708,17465741,17174582,16180763,16777840,1298256619463893,22195465,16875449,12816846,17237521,19358317,1781143817811447,21983325,17945983,18762750,16912439,17184721,1806191417282229,18331850,18202441,17082359,18723434,21972320,1955410614034426,18339044,19458377,17752995,20448824,17891943,1725809017767676,16668584,18384391,17040764,17381384,15913355,1835616614084247,20596234,20506715,21756661,13853126,18203837,1424553121756699,16043574,22195441,17848897,17877323,21453153,1746814120861693,17786518,17912217,17037130,18155762,16956380,1747814517394950,18641461,18189036,18619917,17027426,21352646,1626842522195492,19584068,18436307,17265217,17634921,13498382,2152604819258504,20004087,17443671,22195485,18000422,20004021,2232175617571039,21067387,16344544,18009564,14354737,21286665,1813567818614015,20441797,18362222,17835048,16472716,17936109,1705088817325413,14010183,18747196,17761775,16721594,17082983,2006721221179898,17302277,18084625,15990359,18203835,17297939,1781145616731148,21168487,13829543,17215560,14133975,17694209,1738517818091059,8322815,17586955,17201159,17655634,18331812,1973050818868646,17648596,16220077,16069901,17348614,17393915,1727453717957017,18096714,17308789,18436647,14285317,19289642,1476482918328509,17622427,22195477,16943711,22502493,14368995,1734667118996843,17783588,21343838,16618694,17672719,18856999,1878322417851160,17546761,17798953,18273830,22092979,16596890,1997256616384983,17726838,17360606,22321741,13645875,18199537,1654288621787056,17889549,14565184,17071721,17610798,20299015,2134389722893153,20657441,17397545,18230522,16360112,19769489,1290505818641451,12747740,18430495,17016369,17042658,14602788,1755106319972568,21517440,18508861,19788842,14657740,17332800,1383737819972564,17186905,18315328,19699191,17437634,22353199,1809361519006849,19013183,17296856,18674024,17232014,16855292,1776229614692762,21051840,17705023,19121551,21330264,19854503,2186872019309466,18681862,18554763,20558005,17390160,18456514,1630637313955826,18139690,17501491,17752121,21668627,17299889,1788958318673325,19721304,18293054,17242746,17951233,17649265,1809424619615136,17011832,16870214,17477958,18522509,20631274,1609163717323222,16595641,16524926,18228645,18282562,17596908,1715614818031668,16494615,22683225,17545847,17655240,17614134,1355855717341326,17891946,17716305,16392068,19271443,21351877,1809212718440047,17614227,14106803,16903536,18973907,18673342,1903286717389192,17612828,16194160,17006570,17721717,17390431,1757024016863422,18325460,19727057,16422541,19972570,17267114,1824496221538485,18765602,18203838,16198143,17246576,14829250,1783562718247991,14458214,21051862,16692232,17786278,17227277,1604267316314254,16228604,16837842,17393683,17787259,20331945,2007439115861775,16399083,18018515,22683212,18260550,21051858,1703697316613964,17080436,16579084,18384537,18280813,20296213,1690138515979965,18441944,16450169,9756271,17892268,11733603,1628569117587063,21343775,16538760,18180390,18193833,21387964,2105183317238511,17824637,16571443,18306996,14852021,18674047,1785345612364061,22195448RacsystemcomprisingofmultiplenodesLocalnode=jyrac2Remotenode=jyrac1--------------------------------------------------------------------------------OPatchsucceeded.
到此将Oracle 11.2.0.4升级到11.2.0.4.160419的操作完成
关于opatch auto如何将11.2.0.4 rac升级到11.2.0.4.160419就分享到这里了，希望以上内容可以对大家有一定的帮助，可以学到更多知识。如果觉得文章不错，可以把它分享出去让更多的人看到。
声明：本站所有文章资源内容，如无特殊说明或标注，均为采集网络资源。如若本站内容侵犯了原著者的合法权益，可联系本站删除。
