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

Idea ID 2805990

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

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. 

3 Comments
Micro Focus Expert
Micro Focus Expert
Thank you for sharing your idea! It’s open for comments and kudos, and we’re looking forward to input from the community. Once there is enough community traction, it will be further reviewed by the product team. 
Micro Focus Expert
Micro Focus Expert
Status changed to: Waiting for Votes
 
Micro Focus Expert
Micro Focus Expert
Status changed to: Accepted

Great news, this idea has been accepted on our product roadmap. Subscribe to receive updates. (This is not a formal commitment, and subject to change)

The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.