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
[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.
thank you ..........
ReplyDeletemy problem was cleared...
this is perfect solution....