Sunday 30 November 2014

DB : OPatch cannot find a valid oraInst.loc file to locate Central Inventory OPatch failed with error code 104

Error:

[oradev@tsebsdb01 OPatch]$ opatch lsinventory /
Invoking OPatch 11.2.0.1.7

Oracle Interim Patch Installer version 11.2.0.1.7
Copyright (c) 2011, Oracle Corporation.  All rights reserved.


Oracle Home       : /d01/oracle/DEV01/db/tech_st/11.2.0.3
Central Inventory : n/a
   from           :
OPatch version    : 11.2.0.1.7
OUI version       : 11.2.0.3.0
Log file location : n/a

OPatch cannot find a valid oraInst.loc file to locate Central Inventory.

OPatch failed with error code 104
[oradev@tsebsdb01 OPatch]$

Solution:

Use -invPtrLoc with the oraInst.loc full path as highlighted below in green

[oradev@tsebsdb01 OPatch]$ opatch lsinventory -invPtrLoc /d01/oracle/DEV01/db/tech_st/11.2.0.3/oraInst.loc
Invoking OPatch 11.2.0.1.7

Oracle Interim Patch Installer version 11.2.0.1.7
Copyright (c) 2011, Oracle Corporation.  All rights reserved.


Oracle Home       : /d01/oracle/DEV01/db/tech_st/11.2.0.3
Central Inventory : /d01/oracle/DEV01/db/tech_st/11.2.0.3/admin/oui/DEV_tsebsdb01/oraInventory
   from           : /d01/oracle/DEV01/db/tech_st/11.2.0.3/oraInst.loc
OPatch version    : 11.2.0.1.7
OUI version       : 11.2.0.3.0
Log file location : /d01/oracle/DEV01/db/tech_st/11.2.0.3/cfgtoollogs/opatch/opatch2014-11-30_10-31-30AM.log

Lsinventory Output file location : /d01/oracle/DEV01/db/tech_st/11.2.0.3/cfgtoollogs/opatch/lsinv/lsinventory2014-11-30_10-31-30AM.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 (10) :

Patch  13366268     : applied on Thu Feb 20 15:58:22 GST 2014
Unique Patch ID:  14394336
   Created on 21 Dec 2011, 08:14:06 hrs PST8PDT
   Bugs fixed:
     13366268

No comments:

Post a Comment

Oracle : Database Startup Time

 Oracle Instance Startup Time SET LINES 2000 SET PAGES 9999 COLUMN INSTANCE_NAME FOR A20 SELECT     instance_name,     to_char(startup_time,...