Oracle Inventory Quality Troubleshooting Custom Report

• Owner: Nicolas Rousseau
• Owner Email Address: nrousseau@flexera.com
• Solution Type: Custom SQL Report
• Flexera Product & Version: 2017+
• Environment: ON PREM
• Development Effort (Days): 1
• Implementation Effort (Days): 0.1
• Disclaimer:

SOLUTIONS ARE PROVIDED ON AN "AS IS" BASIS. NEITHER FLEXERA NOR ITS SUPPLIERS MAKE ANY WARRANTIES, EXPRESS OR IMPLIED, STATUTORY OR OTHERWISE, INCLUDING BUT NOT LIMITED TO WARRANTIES OF MERCHANTABILITY, TITLE, FITNESS FOR A PARTICULAR PURPOSE OR NONINFRINGEMENT. LICENSEE MAY HAVE OTHER STATUTORY RIGHTS. HOWEVER, TO THE FULL EXTENT PERMITTED BY LAW, THE DURATION OF STATUTORILY REQUIRED WARRANTIES, IF ANY, WILL BE LIMITED TO THE SHORTER OF (I) THE STATUTORILY REQUIRED PERIOD OR (II) THIRTY (30) DAYS FROM LICENSEE’S ACCEPTANCE OF THE AGREEMENT.

Goal of the views and approach

Troubleshooting Oracle inventory issues can be fastidious, particularly when it come to analyzing the logs, discovered device detail per discovered device detail. 

The SQL view, that can be implemented on premise, catches all servers from the “All Discovered Devices” that are flagged as having Oracle installed. It also catches computers that may have Oracle Unspecified Edition Installed and are not in this list, it then brings the following data:

• Server Name
• IP address
• List of inventoried instances
• Log if the last Oracle inventory failed
• Last Oracle log for the server
• Last Discovery date

The report parses the error logs and prioritizes the issues:

• Priority 1
  • Agent has identified Oracle from OUI evidences and no instance has been inventoried.
  • Oracle has been correctly recognized (with an edition) but no instance has been inventoried.
  • The server seems not inventoried and seems to have Oracle Installed from Discovery Information. Deploy and agent
  • No Instance was Inventoried and Invalid Credentials. OS Authentication not enabled?
• Priority 2:
  • It looks like standby data guard instances have not been inventoried (db not in Open state)
• Priority 3:
  • Some instances have been inventoried on the server, but others have failed in the last inventory

Preview