opatch lsinventory failed after oracle upgrade

All posts relating to Oracle database administration.

Moderator: Tim...

opatch lsinventory failed after oracle upgrade

Postby macco10 » Tue Jun 04, 2013 6:38 pm

Hi Guys,

./opatch lsinventory -> failed after Oracle upgrade from 10.2.4 to 11.2.0.2
I got error:
GENERIC OPATCH VERSION - FOR USE IN SAP ENVIRONMENT ONLY
========================================================
Oracle Interim Patch Installer version 11.2.0.3.1
Copyright (c) 2012, Oracle Corporation. All rights reserved.


Oracle Home : /oracle/<SID>/112_64
Central Inventory : /oracle/<SID>/oraInventory
from : /oracle/<SID>/112_64/oraInst.loc
OPatch version : 11.2.0.3.1
OUI version : 11.2.0.2.0
Log file location : /oracle/<SID>/112_64/cfgtoollogs/opatch/opatch2013-06-04_20-28-32PM_1.log

List of Homes on this system:

Home name= <SID>_102_64, Location= "/oracle/<SID>/102_64"
Inventory load failed... OPatch cannot load inventory for the given Oracle Home.
Possible causes are:
Oracle Home dir. path does not exist in Central Inventory
Oracle Home is a symbolic link
Oracle Home inventory is corrupted
LsInventorySession failed: OracleHomeInventory gets null oracleHomeInfo

OPatch failed with error code 73

I backed up oraInventory before upgrade and copied back after upgrade.
Please, help. Thanx!
macco10
Member
 
Posts: 8
Joined: Fri Jan 27, 2012 2:25 pm

Re: opatch lsinventory failed after oracle upgrade

Postby Tim... » Wed Jun 05, 2013 7:54 am

Hi.

Question: Did you get the latest version of opatch from M.O.S. ?

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17950
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: opatch lsinventory failed after oracle upgrade

Postby macco10 » Thu Jun 06, 2013 5:16 am

Hi Tim,

I have dowloaded patches from SAP Market Place.
macco10
Member
 
Posts: 8
Joined: Fri Jan 27, 2012 2:25 pm

Re: opatch lsinventory failed after oracle upgrade

Postby Tim... » Thu Jun 06, 2013 7:30 am

Hi.

I think you misunderstood. Oracle supply a utility called "opatch". That is the utility you are using to do the lsinventory. The version that ships with the database is rarely the latest version. The first thing you need to do is download the latest version of "opatch" from M.O.S. and use that to check your inventory.

If that works, great. If it doesn't, then you need to raise an SR with Oracle Support (M.O.S.) to see how you can repair your inventory.

Typically, your inventory will be amended when you do your software installation, prior to the upgrade. If your installation of the new software has been successful, your inventory should be fine from them on. Upgrading a database will not have a detrimental affect on it. I don;t understand how you've got into this position, but assuming you can't remove and reinstall everything to sort out your inventory, your best bet is to progress this through Oracle Support.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17950
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: opatch lsinventory failed after oracle upgrade

Postby macco10 » Sun Jun 09, 2013 5:58 am

Hi Tim,
thank you for your suggestion.
I have downloaded also last version of OPatch. I will notify you about solution, when problem will be solved.
macco10
Member
 
Posts: 8
Joined: Fri Jan 27, 2012 2:25 pm

Re: opatch lsinventory failed after oracle upgrade

Postby Tim... » Sun Jun 09, 2013 6:49 am

:)
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17950
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle Database Administration

Who is online

Users browsing this forum: No registered users and 1 guest