How to setup multiple Oracle agents using the advance mode (4227328)

How can multiple new Oracle database agents be added to Foglight for monitoring using a single installer wizard panel?

• Instance connections are made through JDBC and the following needs validity as it’s used to established DB connectivity to the monitored Oracle instance host:
• Valid resolvable/pingable hostname or IP
• Valid active connection port default 1521
• Valid  Oracle SID or Service name as it exactly appears in the tnsnames.ora file
• Available user with sys credentials to run permissions script
• OS connections types:
• SSH, WinRM or WMI connections are needed for Operating System metric retrieval.
• If Using SSH, open port default 22

The following video details how to create multiple Oracle database agents using the Advanced mode.

In Foglight 6.0 and higher the Global View databases dashboard is available here:

1. To add Agents, log into the Foglight web console with a Foglight user, click on Databases to access the databases dashboard.

2. Click Monitor and select Oracle, the Monitor Oracle Instance setup GUI should display in a simple screen format requesting the needed setup configurations for creating a single instance.  

3. For setting up multiple agents click on Use this option to discover multiple Oracle instances redirects to the Advance Oracle Monitoring Wizard, Foglight agent manager selection view.  Use this screen to select the Host that Foglight will use to monitor your Oracle instances. Choose the recommended Host or select another Host that has the Foglight Agent Management software installed. 

4. Click validate to verify the Agent Manager system resources.  When the status validates? Click next.   

5. Click Add instances propose two methods for configuring Foglight to monitor Oracle databases.  Loading a TNS file copied from the database system or manually configuring the parameters.  Both methods are covered in the demo.

6. Load TNS file allows selecting multiple database instances and also configures the connection profile.  Click on load file, locate and choose the accessible tnsnames.ora file then click ok.  A populated list of databases will display in accordance to the tnsnames.ora file.   Select the database instance or instances of choice from the list and click ok.

7. The necessary connection fields are pre populated.  Click Set credentials to complete the configurations.

8. The Add Manually option requires to manually key the connection parameters.  Enter the host name where the Oracle database instance is located.   Change the port if it’s something other than the default.  Supply the Service or SID. 

   The host appears in the table for further configuration.  Isolate the host to configure independently.  Click set credentials.   

9. Under Oracle connection, specify the database login credentials.

10.  Within Monitoring Extension, click Specify OS Credentials for complete OS metrics.  Appropriate the authentication then enter OS user and key in the password .   As an alternative there is an option to use stored OS credentials from the foglight lockbox click select from stored credentials.  Click apply

11. Adjust Alarm sensitivity level if other than default.  Sensitivity level controls the type of alarms that will get triggered.  

12. click Validate validation takes place.

13. Click on insufficient privileges under status if it displays during validation.  A Grant privileges box pops up, the database user needs sufficient permissions to access Oracle data dictionary views.  A sysdba user is needed to run the grant privileges script.  Either copy the script and run it on the database or enter a sysdba user, the sysdba credentials are not saved only required for completing the granting stage.  Click grant and the cycles of validations displays.  Once all the checks have been authenticated the status should indicate validated and the agent is prepped for the final creation stage.

14. To change the display name on how the monitoring agent will appear in the databases dashboards, click on Display name and enter the desired entry.  Once monitoring is completed, the option of changing the display name is not available.

15. Click next to view the instances stage for monitoring.  To proceed with monitoring the listed Instances, click next. 

16. Initialization begins and it may take a few minutes to setup the Foglight Oracle agents for the listed instances.    

17. The table will list a Monitored status for successful agent creation.  Monitoring is now available for the instances.  Click finish to view the agents in the databases dashboards.  Metrics may take a couple of cycles before the dashboard is fully populated.