oraInventory in Oracle

thanks for the supprt Mr.ATUL can u give some information abt configuring standby database in the coming posts

cheers
chandoo

Chandoo,
I discussed about standby in past at

http://becomeappsdba.blogspot.com/2006/11/oracle-dataguard-for-business.html

http://becomeappsdba.blogspot.com/2006/11/configure-oracle-dataguard.html

Good Post,Simple and clear-cut explanation about oraInventory.

Sam
http://appsdbablog.com

Thanks Sam,
I often read your blog , they are quite interesting. Good to hear from you .

Atul

Hi Atul

We are trying to attach a home to orainventory which was created jus by copying an oracle home. Can u plz help me with this….
Rupa.

Rupa,
Could you try ./runInsaller with option mentioned in pos & let me know if you face any issues .

Atul

Atul,

I was trying to use runInstaller (10.2 version as 9i doesn’t have attachHome ability) to attach a 9.2.0.8 home on Solaris.

The session failed with the following:

Starting Oracle Universal Installer…

No pre-requisite checks found in oraparam.ini, no system pre-requisite checks will be executed.
The inventory pointer is located at /var/opt/oracle/oraInst.loc
The inventory is located at /opt/oracle/oraInventory
‘AttachHome’ failed.

Wonder if you had such experience, i.e. attach 9208 home via 10.2.0.3 runInstaller?

Thanks.

Hi Anonymous for any issues you can raise them at forum http://teachMeOracle.com/forum

Atul

Nice to know more about Oracle Inventory, i faced few Inventory corruption issues, when installing OPATCH on a Multiple Oracle Database Version’s, its a test server with Oracle 8i(8.1.7),9i Home and as well Oracle 10g as well…

$opatch lsinventory
Invoking OPatch 10.2.0.3.0

Oracle interim Patch Installer version 10.2.0.3.0
Copyright (c) 2005, Oracle Corporation. All rights reserved..

Oracle Home : /u001/app/oracle/product/10.203
Central Inventory : /u001/app/oracle/product/10./oraInventory
from : /var/opt/oracle/oraInst.loc
OPatch version : 10.2.0.3.0
OUI version : 10.2.0.3.0
OUI location : /u001/app/oracle/product/10.203/oui
Log file location : /u001/app/oracle/product/10.203/cfgtoollogs/opatch/o patch2008-05-14_18-16-56PM.log

List of Homes on this system:

Home name= ******, Location= “/u001/app/oracle/product/10.DSPWEB”
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::load() gets null oracleHomeInfo

OPatch failed with error code 73

…With Oracle Support could able to resolve this.
Thanks
Ravi

hi atul,
plz give me answers for these questions :

I am applying OPatch I don’t have oraInventory ?can I apply?
How many concurrent mangers can be used ?waht is the limit?
suppose my concurrent manager status is showing Inactive ?what is the reason?
If a patch is failed in the middle of the patch?I don’t want to apply the patch continue?
what is transaction manager and product manager?what is the significance?
My cloning is successfully completed but my appslistener is not getting up?what is the problem?
hw frequently u do preform patching?
how frequently u perform cloning?
how much time it will take to complete cloning?
what is the purpose of the appsutil folder in ORACLE_HOME?
After cloning my oraInventory got corrupted ?can I apply my Opatch?
wht command is used to kill the process which is using largest memory?
I am applying patch can I open another session and run adadmin
I am not able to start concurrent manager?what is the probelm?
after registering the top in custom directory?u will run autoconfig r not?

thank you

[…] Installation including registration of DB ORACLE_HOME in inventory. To know more about inventory click here Step 2 – 20-40% – Oracle Database creation including copy of data files from staging area to data […]

[…] installation issues are logged under oraInventory/logs/[filename].log (for more on oraInventory click here ) but how to identify oraInventory location on system […]

[…] 6. If you are not familiar with oraInventory then learn more about oraInventory here […]

Hi Sir & Madam,
iam very thankful for u dat,
iam getting good information about my subject..
if any doubts will arise, i will send the comment..

bash-4.2$ opatch lsinventory
Invoking OPatch 10.2.0.4.3

Oracle Interim Patch Installer version 10.2.0.4.3
Copyright (c) 2007, Oracle Corporation. All rights reserved.

Oracle Home : /u01/app/oracle/product/11.2.0.4/db_1
Central Inventory : /u01/app/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.4.3
OUI version : 11.2.0.4.0
OUI location : /u01/app/oracle/product/11.2.0.4/db_1/oui
Log file location : /u01/app/oracle/product/11.2.0.4/db_1/cfgtoollogs/opatch/opatch2015-10-08_22-39-33PM.log

List of Homes on this system:

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
bash-4.2$ opatch version
Invoking OPatch 10.2.0.4.3

OPatch Version: 10.2.0.4.3

OPatch succeeded.
bash-4.2$ pwd
/u01/app/oracle/product/11.2.0.4/db_1/oui/bin
bash-4.2$
bash-4.2$ ./runInstaller -silent -attachHome -invPtrLoc ./oraInst.loc
Starting Oracle Universal Installer…

Checking swap space: must be greater than 500 MB. Actual 28672 MB Passed
The operation failed as it was called without path of the Oracle Home being attached.
bash-4.2$

please help me.immediately.Production issue.

[…] earlier but installation files were later removed. Old installation location was still present in  oraInventory which was creating this issue while installing OHS again under same […]

Hi
I am using R12.2.4 and on Test instance i have 2 logical SERVER /opt/oracle/TEST03 and /opt/oracle/TEST04. For cloning after extract back place the PROD directory on /opt/oracle/PROD and rename as TEST03 and TEST04.

Now On PROD my global Inventory is set as /etc/oraInst.loc
inventory_loc=/opt/oracle/oraInventory

So for cloning on TEST Server what global Inventory i will set and what local inventory i will set? Please guide me.

Thanks!