记一次打PSU26635745的过程

来源:互联网 发布:中南网络大学教育平台 编辑:程序博客网 时间:2024/04/29 16:04

步骤还是那个步骤,关键还是要仔细看下readme。

大概步骤如下:

在安装的过程中,各个节点的GI和Oracle是处于运行状态的。

1 升级Opatch目录,grid用户,oracle用户都需要升级,升级前最好备份下原来的Opatch,或者ORACLE_HOME,这里我只备份了Opatch

cp -rf  OPatch $ORACLE_HOME


2 停掉EM,我的环境没有EM


3 在GRID用户下,生成配置文件

su - grid

$ORACLE_HOME/OPatch/ocm/bin/emocmrsp -no_banner -output /home/grid/config.rsp


4 root用户下进行安装补丁

su root

/u01/app/11.2.0/grid/OPatch/opatch auto /../26635745 -ocmrf /home/grid/config.rsp


5 运行脚本 (只需要在一个节点上运行)

@?/rdbms/admin/catbundle.sql psu apply


以上1-4 步骤,两个节点上都要运行。


-------------以下是碰到的问题

节点1应用Opatch正常,节点2 应用Opatch,提示数据上的patch失败。 很快就完毕了 。但是最终Optache提示成功。 使用Opatch命令 lsinventory查看,这个节点上是没有补丁的。

[root@host02 26635745]# /u01/app/11.2.0/grid/OPatch/opatch auto /home/oracle/26635745 -ocmrf /home/grid/config.rspExecuting /u01/app/11.2.0/grid/perl/bin/perl /u01/app/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /home/oracle -patchn 26635745 -ocmrf /home/grid/config.rsp -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_paramsThis is the main log file: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2017-12-22_21-11-42.logThis file will show your detected configuration and all the steps that opatchauto attempted to do on your system:/u01/app/11.2.0/grid/cfgtoollogs/opatchauto2017-12-22_21-11-42.report.log2017-12-22 21:11:42: Starting Clusterware Patch SetupUsing configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_paramsStopping RAC /u01/app/oracle/product/11.2.0/db_1 ...Stopped RAC /u01/app/oracle/product/11.2.0/db_1 successfullypatch /home/oracle/26635745/26392168  apply failed  for home  /u01/app/oracle/product/11.2.0/db_1Starting RAC /u01/app/oracle/product/11.2.0/db_1 ...Started RAC /u01/app/oracle/product/11.2.0/db_1 successfullyopatch auto succeeded.[root@host02 26635745]# 


查看日志

Verifying environment and performing prerequisite checks...Prerequisite check "CheckActiveFilesAndExecutables" failed.The details are:Following executables are active :/u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1Prerequisite check "CheckActiveFilesAndExecutables" failed.The details are:Following executables are active :/u01/app/oracle/product/11.2.0/db_1/lib/libsqlplus.soUtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.Prerequisite check "CheckActiveFilesAndExecutables" failed.Log file location: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2017-12-22_22-10-31PM_1.logOPatch failed with error code 73


    [Dec 22, 2017 10:10:37 PM] [INFO]   Running prerequisite checks...    [Dec 22, 2017 10:10:37 PM] [INFO]   Space Needed : 759.668MB    [Dec 22, 2017 10:10:38 PM] [INFO]   Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 17478514    [Dec 22, 2017 10:10:38 PM] [INFO]   Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 18031668    [Dec 22, 2017 10:10:38 PM] [INFO]   Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 18522509    [Dec 22, 2017 10:10:38 PM] [INFO]   Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 19121551    [Dec 22, 2017 10:10:38 PM] [INFO]   Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 19769489    [Dec 22, 2017 10:10:38 PM] [INFO]   Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 20299013    [Dec 22, 2017 10:10:38 PM] [INFO]   Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 20760982    [Dec 22, 2017 10:10:38 PM] [INFO]   Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 21352635    [Dec 22, 2017 10:10:38 PM] [INFO]   Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 21948347    [Dec 22, 2017 10:10:38 PM] [INFO]   Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 22502456    [Dec 22, 2017 10:10:38 PM] [INFO]   Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 23054359    [Dec 22, 2017 10:10:38 PM] [INFO]   Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 24006111    [Dec 22, 2017 10:10:38 PM] [INFO]   Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 24732075    [Dec 22, 2017 10:10:38 PM] [INFO]   Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 25869727    [Dec 22, 2017 10:10:38 PM] [INFO]   Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 26609445    [Dec 22, 2017 10:10:38 PM] [INFO]   Prereq checkPatchApplicableOnCurrentPlatform Passed for patch : 26392168    [Dec 22, 2017 10:10:39 PM] [INFO]   Start fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/bin/oracle at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Finish fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/bin/oracle at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Start fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/bin/amdu at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Finish fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/bin/amdu at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Start fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/bin/kfed at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Finish fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/bin/kfed at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Start fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/bin/kfod at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Finish fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/bin/kfod at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Start fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/bin/renamedg at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Finish fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/bin/renamedg at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Start fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/bin/orion at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Finish fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/bin/orion at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Start fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/bin/rman at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Finish fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/bin/rman at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Start fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1 at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Finish fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1 at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Files in use by a process: /u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1 PID(  29865 )    [Dec 22, 2017 10:10:39 PM] [INFO]   Start fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/lib/liborasdk.so.11.1 at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Finish fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/lib/liborasdk.so.11.1 at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Following executables are active :                                        /u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1    [Dec 22, 2017 10:10:39 PM] [INFO]   Prerequisite check "CheckActiveFilesAndExecutables" failed.                                        The details are:                                                                                                                        Following executables are active :                                        /u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1    [Dec 22, 2017 10:10:39 PM] [INFO]   Start fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/bin/proc at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Finish fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/bin/proc at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Start fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/lib/liborasdkbase.so.11.1 at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Finish fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/lib/liborasdkbase.so.11.1 at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Start fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/bin/wrap at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Finish fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/bin/wrap at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Start fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/bin/e2eme at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Finish fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/bin/e2eme at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Start fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/bin/extjob at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Finish fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/bin/extjob at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Start fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/bin/extjobo at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Finish fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/bin/extjobo at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Start fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/bin/kgmgr at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Finish fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/bin/kgmgr at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Start fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/bin/emtgtctl2 at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Finish fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/bin/emtgtctl2 at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Start fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/lib/libnmemso.so at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Finish fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/lib/libnmemso.so at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Start fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/lib/libsqlplus.so at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Finish fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/lib/libsqlplus.so at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Files in use by a process: /u01/app/oracle/product/11.2.0/db_1/lib/libsqlplus.so PID(  29865 )    [Dec 22, 2017 10:10:39 PM] [INFO]   Following executables are active :                                        /u01/app/oracle/product/11.2.0/db_1/lib/libsqlplus.so    [Dec 22, 2017 10:10:39 PM] [INFO]   Prerequisite check "CheckActiveFilesAndExecutables" failed.                                        The details are:                                                                                                                        Following executables are active :                                        /u01/app/oracle/product/11.2.0/db_1/lib/libsqlplus.so    [Dec 22, 2017 10:10:39 PM] [INFO]   Start fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/bin/exp at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Finish fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/bin/exp at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Start fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/bin/imp at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Finish fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/bin/imp at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Start fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/bin/dgmgrl at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Finish fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/bin/dgmgrl at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Start fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/bin/ldapadd at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Finish fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/bin/ldapadd at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Start fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/bin/ldapaddmt at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Finish fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/bin/ldapaddmt at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Start fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/bin/ldapmodify at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Finish fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/bin/ldapmodify at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Start fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/bin/ldapmodifymt at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Finish fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/bin/ldapmodifymt at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Start fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/bin/lsnrctl at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Finish fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/bin/lsnrctl at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Start fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/bin/tnslsnr at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Finish fuser command /sbin/fuser /u01/app/oracle/product/11.2.0/db_1/bin/tnslsnr at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [SEVERE] OUI-67073:UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.Prerequisite check "CheckActiveFilesAndExecuta    bles" failed.    [Dec 22, 2017 10:10:39 PM] [INFO]   Finishing UtilSession at Fri Dec 22 22:10:39 HKT 2017    [Dec 22, 2017 10:10:39 PM] [INFO]   Log file location: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2017-12-22_22-10-31PM_1.log    [Dec 22, 2017 10:10:39 PM] [INFO]   Stack Description: java.lang.RuntimeException: Prerequisite check "CheckActiveFilesAndExecutables" failed.Prerequisite c


根据错误提示,最后想起了,自己用sqlplus连接了(先用sqlplus连接,又!回来,又su oracle之类的)。 然后彻底退出来。 然后再次安装补丁,可以了。

    [root@host02 bin]# /u01/app/11.2.0/grid/OPatch/opatch auto /home/oracle/26635745 -ocmrf /u01/app/grid/ocm.rsp    Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir /home/oracle -patchn 26635745 -ocmrf /u01/app/grid/ocm.rsp -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params    This is the main log file: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2017-12-22_22-33-08.log    This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:    /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2017-12-22_22-33-08.report.log    2017-12-22 22:33:08: Starting Clusterware Patch Setup    Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params    Stopping RAC /u01/app/oracle/product/11.2.0/db_1 ...    Stopped RAC /u01/app/oracle/product/11.2.0/db_1 successfully    patch /home/oracle/26635745/26392168  apply successful for home  /u01/app/oracle/product/11.2.0/db_1    patch /home/oracle/26635745/26609929/custom/server/26609929  apply successful for home  /u01/app/oracle/product/11.2.0/db_1    Starting RAC /u01/app/oracle/product/11.2.0/db_1 ...    Started RAC /u01/app/oracle/product/11.2.0/db_1 successfully    opatch auto succeeded.    [root@host02 bin]#








原创粉丝点击