Pages

Tuesday 29 October 2013

OPatch failed with error code 73



I tried to apply the patch to database instance and got the error as below.

[oracle@test01db 13936066]$ opatch apply
Oracle Interim Patch Installer version 11.2.0.3.5
Copyright (c) 2013, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/11203/testdbms
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11203/testdbms/oraInst.loc
OPatch version    : 11.2.0.3.5
OUI version       : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11203/testdbms/cfgtoollogs/opatch/13936066_Oct_29_2013_09_24_25/apply2013-10-29_09-24-25AM_1.log

Applying interim patch '13936066' to OH '/u01/app/oracle/product/11203/testdbms'
Verifying environment and performing prerequisite checks...
[ Error during Oracle Home discovery Phase]. Detail: OPatchSession cannot load inventory for the given Oracle Home /u01/app/oracle/product/11203/testdbms. Possible causes are:
   No read or write permission to ORACLE_HOME/.patch_storage
   Central Inventory is locked by another OUI instance
   No read permission to Central Inventory
   The lock file exists in ORACLE_HOME/.patch_storage
   The Oracle Home does not exist in Central Inventory

[ Error during Oracle Home discovery Phase]. Detail: OPatch failed: ApplySession failed to prepare the system. Unable to create patchObject
Possible causes are:
   ORACLE_HOME/inventory/oneoffs/16311483 is corrupted
   No read permission to above directory
Please remove one-off entry [ 16311483 ] from /u01/app/oracle/product/11203/testdbms/inventory/ContentsXML/comps.xml and retry if above directory corrupted, or Please check the contents of the directory ORACLE_HOME/inventory/oneoffs/16311483 for read permission
Log file location: /u01/app/oracle/product/11203/testdbms/cfgtoollogs/opatch/13936066_Oct_29_2013_09_24_25/apply2013-10-29_09-24-25AM_1.log

Recommended actions: Please make sure no other OPatch or OUI processes is running. Try running $ORACLE_HOME/oui/bin/runInstsaller.

OPatch failed with error code 22


When I checked the inventory, got the error as below.

[oracle@test01db ContentsXML]$ opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.5
Copyright (c) 2013, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/11203/testdbms
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11203/testdbms/oraInst.loc
OPatch version    : 11.2.0.3.5
OUI version       : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11203/testdbms/cfgtoollogs/opatch/opatch2013-10-29_09-50-44AM_1.log



Inventory load failed... OPatch cannot load inventory for the given Oracle Home.

LsInventorySession failed: Unable to create patchObject
Possible causes are:
   ORACLE_HOME/inventory/oneoffs/16311483 is corrupted
   No read permission to above directory
Please remove one-off entry [ 16311483 ] from /u01/app/oracle/product/11203/testdbms/inventory/ContentsXML/comps.xml and retry if above directory corrupted, or Please check the contents of the directory ORACLE_HOME/inventory/oneoffs/16311483 for read permission

OPatch failed with error code 73



So when I checked the patch 16311483 at $ORACLE_HOME/inventory/oneoffs, couldn't find it.

[oracle@test01db ContentsXML]$ ls -lrt $ORACLE_HOME/inventory/oneoffs/16311483
ls: /u01/app/oracle/product/11203/testdbms/inventory/oneoffs/16311483: No such file or directory
[oracle@test01db ContentsXML]$


Solution:

Take the backup of /u01/app/oracle/product/11203/testdbms/inventory/ContentsXML/comps.xml file and then remove  "16311483" corresponding entry(from ) from comps.xml. After that check the inventory as below.


[oracle@test01db ContentsXML]$ opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.5
Copyright (c) 2013, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/11203/testdbms
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11203/testdbms/oraInst.loc
OPatch version    : 11.2.0.3.5
OUI version       : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11203/testdbms/cfgtoollogs/opatch/opatch2013-10-29_10-13-01AM_1.log

Lsinventory Output file location : /u01/app/oracle/product/11203/testdbms/cfgtoollogs/opatch/lsinv/lsinventory2013-10-29_10-13-01AM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (1):

Oracle Database 11g                                                  11.2.0.3.0
There are 1 products installed in this Oracle Home.


Interim patches (1) :

Patch  12646746     : applied on Tue Oct 29 05:45:31 UTC 2013
Unique Patch ID:  14825629
   Created on 14 May 2012, 16:17:31 hrs PST8PDT
   Bugs fixed:
     12646746



--------------------------------------------------------------------------------

OPatch succeeded.


1 comment:

  1. thank you ..........

    my problem was cleared...

    this is perfect solution....

    ReplyDelete