oracle成功的原因,【案例】Oracle报错OUI-67076产生原因和MOS官方解决办法

天萃荷净

运维DBA反映在升级Oracle数据库时报错OUI-67076:OracleHomeInventory was not able to create a lock file，结合MOS官方解决办法。

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

[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@11rahttp://www.oracleplus.netc1 .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)

升级数据字典的信息

本文固定链接: http://www.htz.pw/2014/08/21/oui-67076oraclehomeinventory-was-not-able-to-create-a-lock-file.html | 认真就输

--------------------------------------ORACLE-DBA----------------------------------------

最权威、专业的Oracle案例资源汇总之【案例】Oracle报错OUI-67076产生原因和MOS官方解决办法