Steps To Recreate Central Inventory(oraInventory) In RDBMS Homes_556834.1
Steps To Recreate Central Inventory(oraInventory) In RDBMS Homes (Doc ID 556834.1)
In this Document
Goal |
Solution |
References |
Applies to:
Oracle Universal Installer - Version 10.2.0.1.0 and later
Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Oracle Database - Standard Edition - Version 10.2.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 03-Jan-2013***
Goal
How to recreate oraInventory (Central Inventory) in RDBMS Homes if the central inventory is corrupted or lost?
Solution
STEP 1:
Locating the central inventory
-
The location of the central inventory can be found from the central inventory pointer.
Windows - By default the location of the Central inventory will be in "C:\Program Files\Oracle\Inventory"
- The location of the central inventory can be found from the central inventory pointer which can be found from the key "inst_loc".
-
The key can be found by:
1. Go to "Run" window (Press Windows Key + r)
2. Type "regedit" and enter
3. Expand HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE
4. Find the value of the key "inst_loc"
Note : The following command will also show the inventory pointer in Windows XP,2003 and Vista
C:\>reg query HKLM\SOFTWARE\ORACLE /v inst_loc
Unix/Linux - The location of the central inventory can be found from the central inventory pointer can be found from the file /etc/oraInst.loc (AIX and Linux) or /var/opt/oracle/oraInst.loc (Platform specific)
-
If an oraInst.loc file does not exist, then create one as below with the following entries:
inventory_loc=
inst_group=
Example:
inventory_loc=/u01/oracle/oraInventory
inst_group=oinstall
Note: Make sure that the Oracle Owner has proper permissions (755) on the location specified for the oraInventory.
STEP 2:
Remove the Central inventory (if it exists)
Use the following command to rename the oraInventory (Unix/Linux)
% mv oraInventory oraInventory_orig
Use the Windows Explorer or the "move" command to rename the Inventory (Windows) located under c:\Program Files\oracle (default location)
STEP 3:
Change the directory to the oui location.
Use the following command to change the directory to the oui location.
(Unix/Linux): % cd $ORACLE_HOME/oui/bin
(Windows): > cd %ORACLE_HOME%\oui\bin
STEP 4:
Attaching the Home for Oracle Database 10.2.0.1 and above.
Execute runInstaller with -attachHome option for Oracle Home.
% ./runInstaller -silent -ignoreSysPrereqs -attachHome ORACLE_HOME="" ORACLE_HOME_NAME=" "
> setup.exe -silent -ignoreSysPrereqs -attachHome ORACLE_HOME="" ORACLE_HOME_NAME=" "
For Example:
ORACLE_HOME=/u01/app/oracle/product/10.2.0.3
ORACLE_HOME_NAME=OraDb10g_home1
% ./runInstaller -silent -ignoreSysPrereqs -attachHome ORACLE_HOME="/u01/app/oracle/product/10.2.0.3" ORACLE_HOME_NAME="OraDb10g_home1"
If you have more than one oracle home you have to repeat STEP 4 for all remaining Oracle Homes making sure to provide unique ORACLE_HOME_NAME's for each ORACLE_HOME.
Note:
Recreation of Central Inventory in RDBMS Homes is only supported from 10.2.0.1.0 and later.
No downtime is required for recreating the global inventory (oraInventory)
Log files for this operation can be found at the following location :
- Unix platforms : oraInventory/logs (full path of oraInventory is given in used oraInst.loc)
- Windows platforms : c:\program files\oracle\inventory\logs
At this location you will see these two files (.out is useless anyway) :
AttachHome
oraInstall
From 10gr2 these files are also found in
(see Note 403212.1 : Location Of Logs For Opatch And OUI)
References
NOTE:1156586.1 - Master Note For Oracle Database Server Installation
NOTE:1351051.2 - Information Center: Install and Configure Database Server/Client Installations
NOTE:414600.1 - Strategies for a Corrupted Oracle Central Inventory
NOTE:472854.1 - How to Recreate the OraInventory on UNIX Systems
|
|
- Oracle Database Products > Oracle Database Suite > Oracle Database > Oracle Database - Enterprise Edition > Dataserver Installation and Relinking issue > Inventory issues
- Oracle Database Products > Oracle Database Suite > Oracle Database > Oracle Database - Standard Edition > Standard Edition Installation and Relinking Issues > Inventory issues
- Oracle Database Products > Oracle Database Suite > Oracle Database > Oracle Universal Installer > Oracle Universal Installer > Generic OUI Issues
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/17252115/viewspace-1246837/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Central Inventory (oraInventory) - inventory.xml 4AIXML
- Central Inventory (oraInventory) - inventory.xml 3AIXML
- Central Inventory (oraInventory) - inventory.xml 2AIXML
- Central Inventory (oraInventory) - inventory.xml 1AIXML
- Oracle的Central Inventory和Local inventory詳解Oracle
- How to Recreate the OraInventory on UNIX Systems [ID 472854.1]AI
- Strategies for a Corrupted Oracle Central Inventory [ID 414600.1]Oracle
- Steps to Recreate ASM Diskgroups (文件 ID 268481.1)ASM
- 打補丁報錯Opatch error : "Unable to lock Central InventoryError
- 【RAC】重建Central Inventory檔案-RAC核心技術學習筆記筆記
- OPatch cannot find a valid oraInst.loc file to locate Central InventoryAI
- ORACLE EM recreateOracle
- 重建oraInventory目錄AI
- Deploy an Oracle include oraInventoryOracleAI
- oracle INVENTORY 詳解Oracle
- oracle 11g em recreateOracle
- 從Oracle oraInventory中de-register 或 detach Oracle Home,或重新生成oraInventoryOracleAI
- create a database stepsDatabase
- First steps with Incus
- opatch命令報錯Inventory is corrupted
- About the Oracle Universal Installer Inventory!Oracle
- RDBMS VS XML VS NoSQLXMLSQL
- Oracle RDBMS History Over the YearsOracle
- steps()的學習
- SSH steps of developingdev
- CSS 動畫的 stepsCSS動畫
- Quick steps to rebuild the CRSRebuild
- MyEclipse - Updating index central|http://central.maven.org/maven2/EclipseIndexHTTPMaven
- DROP AND RECREATE ONLINE REDOLOG FILES
- Ansible 進階 | 動態 Inventory
- GCD-1 Grand Central DispatchGC
- Bad magic number for central directory
- 重建控制檔案 recreate control file
- dataguard switchover & failover steps (rac)AI
- 【筆記】RDBMS和NOSQL之比較筆記SQL
- 微軟正式釋出 Azure IoT Central微軟
- I'm shocked that they chose for the City to be the central hub
- Ansible: No inventory was passed, only implicit localhost is availablelocalhostAI