共计 13370 个字符,预计需要花费 34 分钟才能阅读完成。
这篇文章给大家介绍 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@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/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@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/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 用户执行以下命令:
[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.