cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • 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

OracleTroubleshootingPreview.png

 

Was this article helpful? Yes No
100% helpful (1/1)
Comments
cartejam
By
Level 5

Is this report available for FNMS cloud customers?

pwesthorp
By
Flexera Alumni

Hi @cartejam ,

While I can't speak directly for the author, I'm pretty certain that this report is only available on-premises, based on him writing "that can be implemented on premise", and that it requires a customer SQL view that cannot be implemented for individual customers in the cloud implementation.

HTH 

nrousseau1
By Level 10 Champion
Level 10 Champion

Hello @cartejam ,

Indeed, the report is using a SQL query and is not available on FNMS SaaS.

Best regards,

Nicolas

krystel_campos
By
Level 5

Hi Nicolas,  is there a place where we can check what the failure mean on the report example:  "OracleInventorySomeFailed"  and "OracleInventoryServiceFailed"?

Version history
Last update:
‎Jun 23, 2021 09:19 AM
Updated by: