Oracle Database

Configure Oracle DB Monitoring

1. Navigate to Dashboards → Administrator.

2. In the Administrator dashboard, locate the "Oracle Instances" panel and click to start adding a system for monitoring.

Figure 1: Adding a New Oracle Instance

3. In the "Create New Oracle Instance" wizard, fill out all the necessary information. Click to add the system.

Figure 2: Creating a New Oracle Instance

4. A pop-up message will confirm that the Oracle DBMS has been added successfully. Click OK to dismiss and proceed to configure the Oracle account to be used for monitoring.

Figure 3: Oracle DBMS Created Successfully

5. Provide the account information in the wizard and click to complete the configuration.

Note: Please take note of the account requirements when configuring the monitoring account.

Figure 4: Oracle Instance Account Information

6. A pop-up message will confirm that the JDBC Oracle account has been created successfully. Click OK to complete the process.

Figure 5: Oracle Account Confirmation

7. The newly added system will appear in the Oracle Instances panel.

Figure 6: Oracle Instances

Note: It may take a few minutes for the status to change to "In Progress." Refresh the panel if needed. If there are configuration issues, such as incorrect connection parameters or an invalid account, the status will remain "Ready". Troubleshoot by displaying the log. Click for the new record, or click the object icon and select Log from the pop-up menu.

8. The Oracle Server will show up in the service grid within 5-15 minutes.

Figure 7: Oracle Databases in IT-Conductor Service Grid

Account Requirements

When selecting an Oracle User, please ensure the user is granted "CREATE SESSION" and "OEM_MONITOR" roles, and "SELECT ON V$DIAG_ALERT_EXT".

The latter two are only relevant when creating a new user used for monitoring.

Automation users may have different requirements depending on the nature of the automation activities.