问题描述
网友打补丁过程中遇到如下问题:
[oracle@11rac1 ~]$ $ORACLE_HOME/OPatch/opatch lspatches OracleHomeInventory was not able to create a lock file, probably due to a failed OPatch Session. The loaded inventory might not show correctly what you have in the Oracle Home. 17076717;Grid Infrastructure Patch Set Update : 11.2.0.3.8 (HAS Components) ——————————————————————————– The following warnings have occurred during OPatch execution: 1) OUI-67076:OracleHomeInventory was not able to create a lock file, probably due to a failed OPatch Session. The loaded inventory might not show correctly what you have in the Oracle Home. ——————————————————————————– OPatch Session completed with warnings.
这里是由于原来升级失败导致的,由于手动删除lock这个文件。
[oracle@11rac1 ~]$ cd /u01/app/oracle/product/11.2.0/db_1/.patch_storage/ [oracle@11rac1 .patch_storage]$ ls -lrt total 68 drwxr-xr-x 3 oracle dba 4096 Aug 21 23:31 NRollback drwxr-xr-x 4 oracle dba 4096 Aug 21 23:39 16902043_Sep_24_2013_23_20_58 drwxr-xr-x 4 oracle dba 4096 Aug 21 23:39 16619892_Jun_23_2013_09_03_20 drwxr-xr-x 4 oracle dba 4096 Aug 21 23:39 16056266_Mar_12_2013_02_14_47 drwxr-xr-x 4 oracle dba 4096 Aug 21 23:39 14727310_Dec_27_2012_00_06_30 drwxr-xr-x 4 oracle dba 4096 Aug 21 23:39 14275605_Oct_3_2012_18_38_19 drwxr-xr-x 4 oracle dba 4096 Aug 22 00:05 17076717_Oct_11_2013_02_52_50 drwxr-xr-x 6 oracle dba 4096 Aug 22 00:06 NApply -rw-r–r– 1 oracle dba 1807 Aug 22 00:07 record_inventory.txt -rw-r–r– 1 oracle dba 5309 Aug 22 00:07 interim_inventory.txt drwxr-xr-x 7 oracle dba 4096 Aug 22 00:07 13343438_Jan_3_2012_02_50_27 -rw-r–r– 1 oracle dba 0 Aug 22 00:07 patch_free drwxr-xr-x 7 oracle dba 4096 Aug 22 00:07 13696216_Apr_3_2012_22_02_51 drwxr-xr-x 2 oracle dba 4096 Aug 22 00:15 verify -rw-r–r– 1 oracle dba 56 Aug 22 00:15 patch_locked -rw-r–r– 1 oracle dba 93 Aug 22 00:15 LatestOPatchSession.properties drwxr-xr-x 7 oracle dba 4096 Aug 22 00:15 13923374_Jun_13_2012_00_02_44 [oracle@11rac1 .patch_storage]$ mv patch_locked patch_locked.back [oracle@11rac1 .patch_storage]$ $ORACLE_HOME/OPatch/opatch lspatches 17076717;Grid Infrastructure Patch Set Update : 11.2.0.3.8 (HAS Components) 通过lspatches,这里我们看到数据库只升级了一个补丁,另一个补丁没有成功
专家解答
下面手动对DB软件打补丁
[root@11rac1 ~]# $GRID_HOME/OPatch/opatch auto /tmp -ocmrf /tmp/ocm.rsp -oh $ORACLE_HOME Executing /u01/app/11.2.0/grid/perl/bin/perl /u01/app/11.2.0/grid/OPatch/crs/patch11203.pl -patchdir / -patchn tmp -ocmrf /tmp/ocm.rsp -oh /u01/app/oracle/product/11.2.0/db_1 -paramfile /u01/app/11.2.0/grid/crs/install/crsconfig_params /u01/app/11.2.0/grid/crs/install/crsconfig_params /u01/app/11.2.0/grid/crs/install/s_crsconfig_defs This is the main log file: /u01/app/11.2.0/grid/cfgtoollogs/opatchauto2014-08-22_01-44-22.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/opatchauto2014-08-22_01-44-22.report.log 2014-08-22 01:44:22: Starting Clusterware Patch Setup Using configuration parameter file: /u01/app/11.2.0/grid/crs/install/crsconfig_params Unable to determine if /u01/app/oracle/product/11.2.0/db_1 is shared oracle home Enter ‘yes’ if this is not a shared home or if the prerequiste actions are performed to patch this shared home (yes/no):yes patch //tmp/17076717/custom/server/17076717 apply successful for home /u01/app/oracle/product/11.2.0/db_1 patch //tmp/16902043 apply successful for home /u01/app/oracle/product/11.2.0/db_1
查看补丁是否成功
[oracle@11rac1 ~]$ $ORACLE_HOME/OPatch/opatch lspatches 16902043;Database Patch Set Update : 11.2.0.3.8 (16902043) 17076717;Grid Infrastructure Patch Set Update : 11.2.0.3.8 (HAS Components)
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。