Oracle11.2.0.4 RAC打最新PSU 20180717

OS：Redhat 6.8

DB：Oracle 11.2.0.4  RAC

这里打补丁是达到11.2.0.4.20180717这个版本，是加载的OJVM+GI的补丁。需求根据客户要求做相应的修改。
 

更新替换OPatch：

[root@ynzd1 ~]# cd $ORACLE_HOME [root@ynzd1 11.2.0]# mv OPatch OPatch_bak1 [root@ynzd1 11.2.0]#  [root@ynzd1 11.2.0]#  [root@ynzd1 11.2.0]# unzip p6880880_112000_Linux-x86-64.zip  Archive:  p6880880_112000_Linux-x86-64.zip    creating: OPatch/    creating: OPatch/oracle_common/    creating: OPatch/oracle_common/modules/   inflating: OPatch/oracle_common/modules/com.oracle.glcm.common-logging_1.6.4.0.jar     inflating: OPatch/emdpatch.pl          creating: OPatch/config/  extracting: OPatch/config/opatch.properties      creating: OPatch/jre/    creating: OPatch/jre/javaws/   inflating: OPatch/jre/javaws/javaws     inflating: OPatch/jre/COPYRIGHT      extracting: OPatch/jre/README          inflating: OPatch/jre/Welcome.html   省略、、、、、、、、、、   [root@ynzd1 11.2.0]# chown grid:oinstall -R OPatch

解压补丁：

[root@ynzd1 11.2.0]# cd /soft [root@ynzd1 soft]# ls -rlt total 1016352 -rw-r--r-- 1 root root 140724601 Sep 19 14:13 p27734982_112040_Linux-x86-64.zip -rw-r--r-- 1 root root 900011220 Sep 19 14:16 p27967757_112040_Linux-x86-64.zip [root@ynzd1 soft]# unzip p27967757_112040_Linux-x86-64.zip  Archive:  p27967757_112040_Linux-x86-64.zip    creating: 27967757/    creating: 27967757/27734982/    creating: 27967757/27734982/27734982/    creating: 27967757/27734982/27734982/etc/    creating: 27967757/27734982/27734982/etc/config/   inflating: 27967757/27734982/27734982/etc/config/actions.xml     inflating: 27967757/27734982/27734982/etc/config/inventory.xml     inflating: 27967757/27734982/27734982/etc/config/composite.xml     inflating: 27967757/27734982/27734982/etc/config/deploy.xml      creating: 27967757/27734982/27734982/etc/xml/   inflating: 27967757/27734982/27734982/etc/xml/ShiphomeDirectoryStructure.xml     inflating: 27967757/27734982/27734982/etc/xml/GenericActions.xml   省略、、、、、、、、、、 [root@ynzd1 soft]# chmod 775 -R 27967757/ [root@ynzd1 soft]# chown grid:oinstall -R 27967757/ [root@ynzd1 soft]# chmod 775 -R PatchSearch.xml  [root@ynzd1 soft]# chown grid:oinstall -R PatchSearch.xml

生成ocm.rsp

ynzd1[/oracle/grid/11.2.0/OPatch/ocm/bin]$./emocmrsp -no_banner -output /tmp/ocm.rsp Provide your email address to be informed of security issues, install and initiate Oracle Configuration Manager. Easier for you if you use your My Oracle Support Email address/User Name. Visit http://www.oracle.com/support/policies.html for details. Email address/User Name:  You have not provided an email address for notification of security issues. Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]:  y The OCM configuration response file (/tmp/ocm.rsp) was successfully created. ynzd1[/oracle/grid/11.2.0/OPatch/ocm/bin]$

执行安装

[root@ynzd1 soft]#  /oracle/grid/11.2.0/OPatch/opatch auto /soft/27967757 -ocmrf /tmp/ocm.rsp Executing /oracle/grid/11.2.0/perl/bin/perl /oracle/grid/11.2.0/OPatch/crs/patch11203.pl -patchdir /soft -patchn 27967757 -ocmrf /tmp/ocm.rsp -paramfile /oracle/grid/11.2.0/crs/install/crsconfig_params This is the main log file: /oracle/grid/11.2.0/cfgtoollogs/opatchauto2018-09-25_12-13-46.log This file will show your detected configuration and all the steps that opatchauto attempted to do on your system: /oracle/grid/11.2.0/cfgtoollogs/opatchauto2018-09-25_12-13-46.report.log 2018-09-25 12:13:46: Starting Clusterware Patch Setup Using configuration parameter file: /oracle/grid/11.2.0/crs/install/crsconfig_params Stopping RAC /oracle/ora11g/product ... Stopped RAC /oracle/ora11g/product successfully Stopping CRS... Stopped CRS successfully patch /soft/27967757/27734982  apply failed  for home  /oracle/grid/11.2.0 Starting CRS... Installing Trace File Analyzer CRS-4123: Oracle High Availability Services has been started. Starting RAC /oracle/ora11g/product ... Started RAC /oracle/ora11g/product successfully opatch auto succeeded. [root@ynzd1 soft]#

apply失败。查看日志

 

省略、、、、、、、、、、  Oracle Home       : /oracle/grid/11.2.0  Central Inventory : /oracle/grid/oraInventory     from           : /oracle/grid/11.2.0/oraInst.loc  OPatch version    : 11.2.0.3.19  OUI version       : 11.2.0.4.0  Log file location : /oracle/grid/11.2.0/cfgtoollogs/opatch/opatch2018-09-25_11-21-28AM_1.log    Verifying environment and performing prerequisite checks...  Prerequisite check "CheckActiveFilesAndExecutables" failed.  The details are:      Following executables are active :  /oracle/grid/11.2.0/lib/libclntsh.so.11.1  Prerequisite check "CheckActiveFilesAndExecutables" failed.  The details are:      Following executables are active :  /oracle/grid/11.2.0/lib/libsqlplus.so  UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.Prerequisite check "CheckActiveFilesAndExecutables" failed.  Log file location: /oracle/grid/11.2.0/cfgtoollogs/opatch/opatch2018-09-25_11-21-28AM_1.log    OPatch failed with error code 73 2018-09-25 11:21:40: patch /soft/27967757/27734982  apply failed  for home  /oracle/grid/11.2.0 省略、、、、、、、、、、

查看报错进程： /oracle/grid/11.2.0/lib/libclntsh.so.11.1、 /oracle/grid/11.2.0/lib/libsqlplus.so
 

ynzd1[/home/grid]$fuser /oracle/grid/11.2.0/lib/libsqlplus.so /oracle/grid/11.2.0/lib/libsqlplus.so:  6932m ynzd1[/home/grid]$ps -ef|grep 6932 grid      6932  6727  0 Aug31 pts/1    00:00:00 /oracle/grid/11.2.0/bin/sqlplus -S -N      grid     38962 38296  0 12:25 pts/5    00:00:00 grep 6932 ynzd1[/home/grid]$kill -9 6932 [root@ynzd1 soft]# fuser /oracle/grid/11.2.0/lib/libclntsh.so.11.1 /oracle/grid/11.2.0/lib/libclntsh.so.11.1:  6727m 51198m 51241m 51318m 51329m 51342m 51353m 51355m 51373m 51387m 51398m 51431m 52778m 52798m 55146m 55263m 55300m 55304m 55407m 55408m 55440m [root@ynzd1 soft]# ps -ef|grep 6727 grid      6727  6697 63 Aug31 pts/1    15-21:04:04 /oracle/grid/11.2.0/jdk/jre/bin/java -Doracle.installer.not_bootstrap=true -DORACLE_HOME=/oracle/grid/11.2.0 -Dsun.java2d.font.DisableAlgorithmicStyles=true -DDISPLAY=:1.0 -DIGNORE_PREREQS= -DJDBC_PROTOCOL=thin -mx128m -classpath /oracle/grid/11.2.0/assistants/asmca/jlib/asmca.jar:/oracle/grid/11.2.0/assistants/jlib/assistantsCommon.jar:/oracle/grid/11.2.0/jlib/ewt3.jar:/oracle/grid/11.2.0/jlib/ewtcompat-3_3_15.jar:/oracle/grid/11.2.0/jlib/share.jar:/oracle/grid/11.2.0/jlib/help4.jar:/oracle/grid/11.2.0/jlib/jewt4.jar:/oracle/grid/11.2.0/jlib/oracle_ice5.jar:/oracle/grid/11.2.0/jlib/kodiak.jar:/oracle/grid/11.2.0/lib/xmlparserv2.jar:/oracle/grid/11.2.0/jlib/orai18n.jar:/oracle/grid/11.2.0/jlib/ldapjclnt11.jar:/oracle/grid/11.2.0/jlib/netcfg.jar:/oracle/grid/11.2.0/jlib/ojmisc.jar:/oracle/grid/11.2.0/jlib/oraclepki103.jar:/oracle/grid/11.2.0/jlib/opm.jar:/oracle/grid/11.2.0/jdbc/lib/ojdbc5.jar:/oracle/grid/11.2.0/jlib/srvm.jar:/oracle/grid/11.2.0/jlib/srvmhas.jar:/oracle/grid/11.2.0/jlib/srvmasm.jar:/oracle/grid/11.2.0/classes:/oracle/grid/11.2.0/jlib/oemlt.jar:/oracle/grid/11.2.0/jlib/emca.jar:/oracle/grid/11.2.0/sysman/jlib/emCORE.jar:/oracle/grid/11.2.0/oc4j/j2ee/home/oc4j.jar:/oracle/grid/11.2.0/oc4j/j2ee/home/db_oc4j_deploy.jar:/oracle/grid/11.2.0/jlib/emConfigInstall.jar:/oracle/grid/11.2.0/oui/jlib/OraInstaller.jar:/oracle/grid/11.2.0/oui/jlib/OraPrereq.jar:/oracle/grid/11.2.0/inventory/prereqs/oui/OraPrereqChecks.jar:/oracle/grid/11.2.0/oui/jlib/OraPrereqChecks.jar:/oracle/grid/11.2.0/oui/jlib/OraCheckPoint.jar:/oracle/grid/11.2.0/jlib/cvu.jar:/oracle/grid/11.2.0/assistants/asmca/doc/asmcahelp.jar:/oracle/grid/11.2.0/oc4j/j2ee/home/lib/http_client.jar oracle.sysman.assistants.usmca.Usmca root     57503 21670  0 12:32 pts/5    00:00:00 grep 6727 [root@ynzd1 soft]# kill -9 6727

再次执行

[root@ynzd1 soft]#  /oracle/grid/11.2.0/OPatch/opatch auto /soft/27967757 -ocmrf /tmp/ocm.rsp  Executing /oracle/grid/11.2.0/perl/bin/perl /oracle/grid/11.2.0/OPatch/crs/patch11203.pl -patchdir /soft -patchn 27967757 -ocmrf /tmp/ocm.rsp -paramfile /oracle/grid/11.2.0/crs/install/crsconfig_params This is the main log file: /oracle/grid/11.2.0/cfgtoollogs/opatchauto2018-09-25_12-33-18.log This file will show your detected configuration and all the steps that opatchauto attempted to do on your system: /oracle/grid/11.2.0/cfgtoollogs/opatchauto2018-09-25_12-33-18.report.log 2018-09-25 12:33:18: Starting Clusterware Patch Setup Using configuration parameter file: /oracle/grid/11.2.0/crs/install/crsconfig_params Stopping RAC /oracle/ora11g/product ... Stopped RAC /oracle/ora11g/product successfully Stopping CRS... Stopped CRS successfully patch /soft/27967757/27734982  apply successful for home  /oracle/grid/11.2.0  patch /soft/27967757/27441052  apply successful for home  /oracle/grid/11.2.0  Starting CRS... Installing Trace File Analyzer CRS-4123: Oracle High Availability Services has been started. Starting RAC /oracle/ora11g/product ... Started RAC /oracle/ora11g/product successfully opatch auto succeeded. [root@ynzd1 soft]#

二节点重复以上步骤

 

查看补丁情况：

ynzd1[/home/grid]$opatch lspatches 27441052;OCW PATCH SET UPDATE: 11.2.0.4.180417 (27441052) 27734982;Database Patch Set Update : 11.2.0.4.180717 (27734982) 27959254;ACFS Patch Set Update : 11.2.0.4.180717 (27959254) OPatch succeeded. ynzd1[/home/grid]$exit [root@ynzd1 ~]# su - oracle ynzd1[/home/oracle]$opatch lspatches 27441052;OCW PATCH SET UPDATE: 11.2.0.4.180417 (27441052) 27734982;Database Patch Set Update : 11.2.0.4.180717 (27734982) 27475598;OJVM PATCH SET UPDATE 11.2.0.4.180417 ynzd1[/home/oracle]$

 

更新DB实例

cd $ ORACLE_HOME / rdbms / admin  sqlplus / nolog  SQL> CONNECT / AS SYSDBA  SQL> STARTUP  SQL> @catbundle.sql psu apply  SQL> QUIT     cd $ ORACLE_HOME / rdbms / admin  sqlplus / nolog  SQL> CONNECT / AS SYSDBA  SQL> @utlrp.sql   SQL> @ dbmsjdev.sql  SQL> exec dbms_java_dev.disable

补丁安装结束。