Rediscovering Oracle's beautiful oraInst. loc

Rediscovering Oracle's beautiful oraInst. loc

The operating system version of the platform is amazing. Smart people will know it at a glance, and I will not have any code words!

Oracle @ rh64 oraInventory] $ opatch lsinv
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation. All rights reserved.

Oracle Home:/u01/app/db11g/product/11.2.0/dbhome_1
Central Inventory:/u01/app/oraInventory ====>>> you can see that this is a Central Inventory
From:/u01/app/db11g/product/11.2.0/dbhome_1/oraInst. loc ====>>> you can see that this is an Oracle Home Inventory
OPatch version: 11.2.0.3.6
OUI version: 11.2.0.4.0
Log file location:/u01/app/db11g/product/11.2.0/dbhome_1/export toollogs/opatch/opatch2014-05-15_00-33-12AM_1.log

Lsinventory Output file location:/u01/app/db11g/product/11.2.0/dbhome_1/export toollogs/opatch/lsinv/lsinventory2014-05-15_00-33-12AM.txt

--------------------------------------------------------------------------------
Installed Top-level Products (1 ):

Oracle Database 11g 11.2.0.4.0
There are 1 product (s) installed in this Oracle Home.

Interim patches (1 ):

Patch 18031668: applied on Wed May 14 03:28:24 CST 2014
Unique Patch ID: 17255543
Patch description: "Database Patch Set Update: 11.2.0.4.2 (18031668 )"
Created on 20 Feb 2014, 05:15:58 hrs PST8PDT
Sub-patch 17478514; "Database Patch Set Update: 11.2.0.4.1 (17478514 )"
Bugs fixed:
17288409,163 99083, 17205719,178 11429, 10136473,164 72716, 17614227
17050888,170 40764, 17865671,173 25413, 14010183,177 26838, 13364795
17389192,176 17080436,166, 17284817,174 13964, 17761775 41661
17721717,167 21594, 17390431,182 03837, 17551709,173 44412, 16043574
17446237,168 63422, 18139690,170 71721, 17501491,176 1000098, 17239687
17752121,174 68141, 17602269,182 03835, 17375354,173 13525, 17811456
16731148,141 33975, 18203838,169 56380, 17385178,172 35750, 13866822
17394950,174 78514, 17027426,129 05058, 14338435,164 50169, 13944971
18094246,169 29165, 16785708,172 65217, 17465741,162 16180763
16069901,175 46973, 16285691,173 23222, 18180390,170 88068, 16875449
17016369,174 43671, 16228604,178 11438, 17811447,168 12742, 18031668
16912439,173 32800, 17393683,176 22427, 17545847,171 86905, 16943711
16850630,170 82359, 17346671,148 52021, 17783588,174 37634, 16618694
17341326,172 96856, 17546761,177

--------------------------------------------------------------------------------

OPatch succeeded.
==============>>> The patch has been applied to 11.2.0.4.2. The content in oraInst. loc is as follows:
1. oraInst. loc in Central Inventory
[Oracle @ rh64 oraInventory] $ cat/u01/app/oraInventory/oraInst. loc
Inventory_loc =/u01/app/oraInventory
Inst_group = oinstall
2. oraInst. loc in ORACLE_HOME
[Oracle @ rh64 oraInventory] $ echo $ ORACLE_HOME
/U01/app/db11g/product/11.2.0/dbhome_1
[Oracle @ rh64 oraInventory] $ cat/u01/app/db11g/product/11.2.0/dbhome_1/oraInst. loc
Inventory_loc =/u01/app/oraInventory
Inst_group = oinstall
3. oraInst. loc ====>>> Central Inventory Pointer File under/etc
[Oracle @ rh64 oraInventory] $ cat/etc/oraInst. loc
Inventory_loc =/u01/app/oraInventory
Inst_group = oinstall

Note: it can be seen that the above three files are the same content, are the first line to register the directory location, the second behavior host. Note: If you upgrade the database by installing new software
The directory has changed. Remember to modify these three files at the same time. To avoid errors when OPatch is used.

In oracle official documentation? Universal Installer and OPatch User's Guide 11g Release 2 (11.2) for Windows and UNIX are described in detail.
The registration directories of Oracle Universal Installer Inventory are as follows:
1> Central Inventory Pointer File
2> Central Inventory
3> Oracle Home Inventory

1> Central Inventory Pointer File
Each oracle software installation has its own Central Inventory pointer file
Table 2-2 Default Inventory Pointer File Locations

Platform Default Inventory Pointer Location
Linux. PPC64 AIX/etc/oraInst. loc
Solaris. iSCSI Solaris. X64 hpux hpia hp. TRU64 Linux. IA64 Linux. xSeries/var/opt/oracle/oraInst. loc
Windows. X64 Windows. IA64 HKEY_LOCAL_MACHINE/Software/Oracle/inst. loc

In UNIX, if you do not want to use the Central Inventory located in the directory specified by the inventory pointer file, you can use the-invPtrLoc flag to specify another inventory pointer file. the syntax is as follows:

./RunInstaller-silent-invPtrLoc <Location_of_oraInst.loc> ORACLE _
HOME = "<Location_of_Oracle_Home>"

2> Central Inventory
Central Inventory contains information about all Oracle software products installed on a host.
This includes the Inventory File and Logs Directory.
Oracle strongly recommends that you do not manually modify the following inventory. xml. Otherwise, problems may occur during product installation or patch.

3> Oracle Home Inventory
Including Components File, Home Properties File, Other Folders

How to create a Central Inventory? (See Official Document)
./RunInstaller-silent-attachHome ORACLE_HOME = "<Oracle_Home_Location>"
"CLUSTER_NODES = {<node1, node2 >}" LOCAL_NODE =" <node_name>"
How to Create Removing the Central Inventory? (See Official Document)

Summary:
I now feel that when installing or patching, or cloning software, tar from other places to the software, these three files need to be noted,
In addition, how to reconstruct an accidental loss may also occur. Of course, there are some other log information for your reference. It's not uncommon. Just look at it.