Quest Foglight for Oracle

Environment:

• Oracle DBs hosted on AIX, managed by dedicated team.
• DELLs Foglight 5.7.X is used to monitor DBs and involved components (e.g. servers)
   

Problem:

• Get Health State of Ora DBs into OpsMgr to be used in Distributed Applications
• Extract DB status directly from Foglight.

Approach:

1. Foglight's command line tool “foglcmd” is used to export topology information including health state into XML files
2. Any Windows Server which is already monitored via OpsMgr is specified to be the “Foglight MonitoringServer”.
3. A Scheduled Tasks run periodically “foglcmd” on the “Foglight MonitoringServer” to pull the current data into files.
4. The “Foglight MonitoringServer” hosts the Management Pack and runs discovery- and monitoring scripts which parse the XML files to feed OpsMgr with the information.

Result:

Diagram showing state of components including meta information; state is bubbled up through relations.

State views showing meta information in form of lists.

Prepararation:

Foglight

A dedicated user account should be created and permitted in Foglight to query information. Add it to the red highlighted group.

Foglight-Monitoring-Server:

Choose one usual Windows Server which is been monitored via SCOM.

• Set the following registry key to promote it to the “OraglceFoglight Monitoring Server”:

[HKEY_LOCAL_MACHINE\SOFTWARE\ABC\ OracleFoglightMonitoringServer]

• Copy fglcmd.zip from the foglight server, typically located in <InstallDirectory>\tools to the “Oracle Monitoring Server” and extract it.
• Add into fglcmd.bat the following line which need to reflect the installed Java Version. – E.g.
  set JAVA_HOME=C:\Program Files\Java\jre1.8.0_102
   
• Download the internal server certificate of the management server as Base64 and import it to the Java certificate store:
  C:\Program Files\Java\jre1.8.0_102\bin>keytool -importcert -file C:\foglightb64.cer -alias delinfoglight -keystore ../lib/security/cacerts -storepass changeit
   
• Create a directory C:\Temp\FoglightMonitoring\
• Create Scheduled Task to run the batch files which retrieves the Oracle environment information from Foglight. – customize the following script: QryFoglightSrv.cmd
  
  Agent, Database, TableSpace, Servers and Listener are the components which are been queried.

  Each of the components will create one XML file, stored in C:\Temp\FoglightMonitoring\

  • fogoracledboAgentModel.xml
  • fogoracledboDatabase.xml
  • fogoracledboListenerstatus.xml
  • fogoracledboServers.xml
  • fogoracledboTablespace.xml

Internals

About Discoveries

• MonitoringServer is discovered by via 'FilteredRegistryProvider', details above.
• TableSpace, Servers, Listener, Database, Agent and DatabaseSystem are discovered by 'TimedPowerShell.DiscoveryProvider' which used paramerized DiscoverDBOs.ps1
• DiscoverDBOs.ps1 is exptecting the XML files in C:\Temp\FoglightMonitoring\
• Relations are discovered by 'TimedPowerShell.DiscoveryProvider' which use DiscoverDBORelations.ps1

About Monitors

• TableSpace, Servers, Listener, Database, Agent are monitored via custom – module monitor. The monitor itself is MonitorDBOAdv.vbs.
• MonitorDBAdv.vbs uses the 'aggregateState' is judge. State changes are according to value.
• 0-2 = 'Healthy',  3 and 4 = 'Critical'.

About Views

Each element has an own state view located in the dedicated folder 'ABC Database Oracle Foglight Folder'.