当前位置: 首页 > ORA > 正文

网友打补丁过程中遇到如下问题:

 

[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)

升级数据字典的信息

OUI-67076:OracleHomeInventory was not able to create a lock file:等您坐沙发呢!

发表评论

gravatar

? razz sad evil ! smile oops grin eek shock ??? cool lol mad twisted roll wink idea arrow neutral cry mrgreen

快捷键:Ctrl+Enter