OraInventory not available

[Former Member]

Hi Basis Expert,

We are planning to do Oracle upgrade from 10.2.0.4 to 11.2.0.2 in our Pre Production system.

As per the SAP Oracle Upgrade Guide. We will have to take backup of oracle home, oratab, oraInst.loc and OraInventory.

But i found that OraInventory is not available in /oracle/<SID>

So please let me know can we go ahead with the oracle upgrade without this Oraventory backup?

Appreciate your help.

Regards,

Anil Shenoy

[Former Member · Accepted solution]

BTW, location of oraInventory can be verified from the contents of file 'oraInst.loc', as far as I remember.

Let's check that as well.

Thanks

[Former Member · Accepted solution]

Hi DatabaseSAP and others,

I checked the system and found that oraInventory is not available under /oracle and also under /oracle/<SID>

Also checked oraInst.loc and found

/etc$ more oraInst.loc

inventory_loc=/oracle/SCC/oraInventory

inst_group=dba

We did the following steps in our Pre Prod system and observed that oraInventory got created yesterday as per the time stamp

drwxr-xr-x 3 orascc dba 256 Dec 26 12:13 oraInventory

Steps which we performed are

1)Database Backup of the system

2)oracle home / oratab and oraInst.loc backup

3)Executed brconnect -u / -c -f stats -t all -f collect -p 4 before the oracle upgrade

4)umask set to 022

5)Also checked following environment variables are not set

TWO_TASK

ORA_NLS

ORA_NLS32

ORA_NLS10

ORA_NLS33

6)Executed RUNINSTALLER_CHECK

I would like to know why oraInventory was not available as a part of oracle 10g upgrade and how cum it got created when we executed the above steps for 11g upgrade.

Please help me.

Regards,

Anil Shenoy

[Former Member · Accepted solution]

Hello Anil,

Did you check lsinventory command as well, before executing these preparation steps ?

And what lsinventory shows now ? This command should show the exact location of 'oraInst.loc' and 'oraInventory'.

$ORACLE_HOME/OPatch/opatch lsinventory

Thanks

[Former Member · Accepted solution]

Hi DatabaseSAP and others,

I executed opatch lsinventory . Please find the output of the command below

p19637dtw261:orascc> pwd

/oracle/SCC/102_64/OPatch

p19637dtw261:orascc> ls -ltr

total 72

-rw-rr 1 orascc dba 2571 Aug 08 2006 opatch.pl

-rw-rr 1 orascc dba 19263 Dec 26 2006 emdpatch.pl

-rwxr-xr-x 1 orascc dba 6813 Mar 13 2008 opatch

drwxr-x--- 4 orascc dba 256 Dec 02 2010 opatchprereqs

-rw-rr 1 orascc dba 49 Dec 02 2010 opatch.ini

drwxr-x--- 2 orascc dba 256 Dec 02 2010 jlib

drwxr-x--- 2 orascc dba 256 Dec 02 2010 docs

p19637dtw261:orascc> opatch lsinventory

JVMXM008: Error occured while initialising System ClassException in thread "main" Could not create JVM.

OPatch failed with error code 1

p19637dtw261:orascc>

Appreciate your help.

Regards,

Anil Shenoy.

[former_member188883 · Accepted solution]

Hi Anil,

Is JAVA_HOME mentioned in the environment of ora<sid> user . Please check the same.

In case its missing add and try again.

Regards,

Deepak Kori

[Former Member · Accepted solution]

Hi Deepak / DatabaseSAP and others,

I tried adding JAVA_HOME=/usr/java14 (export JAVA_HOME=/usr/java14) from orascc and again executed optach lsinventory.

But still i am getting the same error

p19637dtw261:orascc> ls -ltr

total 72

-rw-rr 1 orascc dba 2571 Aug 08 2006 opatch.pl

-rw-rr 1 orascc dba 19263 Dec 26 2006 emdpatch.pl

-rwxr-xr-x 1 orascc dba 6813 Mar 13 2008 opatch

drwxr-x--- 4 orascc dba 256 Dec 02 2010 opatchprereqs

-rw-rr 1 orascc dba 49 Dec 02 2010 opatch.ini

drwxr-x--- 2 orascc dba 256 Dec 02 2010 jlib

drwxr-x--- 2 orascc dba 256 Dec 02 2010 docs

p19637dtw261:orascc> opatch lsinventory

JVMXM008: Error occured while initialising System ClassException in thread "main" Could not create JVM.

OPatch failed with error code 1

We are not sure whether we can go ahead with oracle 11g upgrade or not.

Regards,

Anil Shenoy

[former_member188883 · Accepted solution]

Hi,

It appears that you do not have appropriate permissions in the 'specific folder' to access resources needed to start the JVM. You either need to get permissions(preferred) or run as root.

Please check and revert.

Regards,

Deepak Kori

[Former Member · Accepted solution]

Hi Deepak and others,

I tried running it from root user. Please find the output below

/oracle/SCC/102_64/OPatch$ opatch lsinventory ksh: opatch: not found. /oracle/SCC/102_64/OPatch$

Also checked the permission and it looks fine

Regards,

Anil Shenoy

[Former Member · Accepted solution]

Hi Anil,

Verify if the Path for $ORACLE_HOME/OPatch is defined in your Environment Variables.

Regards,

Kaleem

[Former Member · Accepted solution]

> p19637dtw261:orascc> opatch lsinventory
> JVMXM008: Error occured while initialising System ClassException in thread "main" Could not create JVM.
> 
> OPatch failed with error code 1
> 
> We are not sure whether we can go ahead with oracle 11g upgrade or not.

You should not, until this lsinventory gets resolved.

This JVM error seems a known issue, we faced it sometimes in some systems, really can't remember at the moment what workaround we did.

You try to search for it, and I will keep my search ON too.

Thanks

[former_member188883 · Accepted solution]

Hi Anil,

/oracle/SCC/102_64/OPatch$ opatch lsinventory
ksh: opatch: not found.

Please run with root user as follows

p19637dtw261}/oracle/SCC/102_64/OPatch$./opatch lsinventory

Let us know the results.

Regards,

Deepak Kori

[Former Member · Accepted solution]

Hi Anil,

The /oracle/oraInventory exists also in oracle 10g but it will be useful only during the upgrade as the upgrade program checks the oraInventory to find out the source release data.

Probable cause is some body would has deleted the dir and now while running the pre checks step of oracle 11g the dir has got created again.

Thanks and Regards,

Suresh Tatikonda.

[Former Member · Accepted solution]

Hi Basis Expert,

Thanks for your support.

We could upgrade the database to 11g successfully without oraInventory backup.

Regards,

Anil

[Former Member]

Is it not under /oracle (instead of under '/oracle/SID') ?