Idea ID: 2805990

Ability for the scanner to Discover Oracle database as installed by using all available oraInst.loc

Status : Delivered
over 1 year ago

We are trying to identify oracle database as installed through the Inventory discovery by scanner job.  As of now, the scanner uses only /etc/oraInst.loc file to identify the Oracle Home to collect the information about Oracle database installed.  

oraInst.loc file doesn't exist only on /etc/ directory.  As per the Database admin, the right oraInst.loc file can be present on different locations based on the installation type and it is always not necessary that /etc/oraInst.loc file to have the right Oracle home path.   

Due to the existing way of identifying the Oracle Home path, we are not discovering Oracle database as Installed on 300+ server where Oracle is actually installed and also running.   

Customer is using the UCMDB to discovery, to identify Oracle database as installed and also whether it is running.  In these scenarios,  Oracle connection and topology job identifies the database as running but, the scanner didnt discover it as installed. 

Software compliance is done through the installed software.  Hence, not collecting this information on 300+ servers provide incorrect results on the Oracle database license management for the customer.   

It will be good, if the scanner can collect the Oracle Home path from the oraInst.loc file from various location instead of finding only at /etc/oraInst.dir  to identify the various Oracle database version installed on the server.  

 

oraInst.loc file on one server:   

 

find / -name oraInst.loc -exec ls -l {} \;

-rw-r-----. 1 XXXX YYYY 56 Mar  6  2018 /etc/oraInst.loc

-rw-r-----. 1 XXXX YYYY56 Mar  6  2018 /u01/app/oracle/product/12.2.0.1/oraInst.loc

-rw-r-----. 1 XXXX YYYY 56 Mar  6  2018 /u01/app/oracle/product/11.2.0.4/oraInst.loc

-rw-r-----. 1 XXXX YYYY56 Mar  6  2018 /u01/app/oracle/product/12.1.0.2/oraInst.loc

-rw-r-----. 1 XXXX YYYY 127 Feb  6 22:07 /oemagent/app/oracle/product/agentbasedir/agent_13.1.0.0.0/oraInst.loc

 

Attaching the screenshot for reference.