Database Manager

MySQL Database Plugin and Oracle Database Plugin

The Databases plugin is automatically enabled when you add a new device to SevOne NMS to enable you to monitor the MySQL database metrics and/or Oracle database metrics for the databases you designate on the device.

Devices for which you enable the Databases plugin can display the following MySQL database indicator data on the Device Summary page.

• Database Name - Displays the database name.

• Description - Displays the database description.

• Availability - Displays database availability.

• Traffic (in and out) - Displays the traffic in and out.

Perform the following steps to enable the Databases plugin for each device from which to poll databases metrics.

1. From the navigation bar, click Devices menu and select Device Manager.

2. Either add a device with the Databases plugin or edit a device to enable the Databases plugin.

   • Click Add Device to display the New Device page.

   • Click to display the Edit Device page.

3. - Click the plugin drop-down (displays SNMP by default) and select Databases.

4. Select the Allow MySQL Database Polling check box to enable discovery of MySQL objects and to poll MySQL metrics.

5. Select the Allow Oracle Database Polling check box to enable discovery of Oracle objects and to poll Oracle metrics.

6. On the New Device page, click Save as New to display the Edit Device page to perform the next steps.

7. On the Edit Device page, click Manage This Devices Databases to display the Database Manager.

8. Click Add Database to display fields that enable you to designate the databases to poll on the device.

9. In the Name field, enter the database name.

10. In the Description field, enter the description of the database to display.

11. Click the Type drop-down and select MySQL to add a MySQL database or select Oracle to add an Oracle database.

12. In the Username field, enter the username SevOne NMS needs to authenticate onto the database on the device. See the Minimum User Requirements section below for a list of the minimal requirements the Databases poller needs.

13. In the Password field, enter the password SevOne NMS needs to authenticate onto the database.

14. In the Confirm Password field, re-enter the password.

15. In the Port field, enter the port on the device for SevOne NMS to use to listen for data. For the Oracle type database, enter the Oracle Net Listener port, typically 1521.

16. For Oracle databases, in the Connection String field, enter the Oracle service name (e.g., PROD).

17. Click Save.

18. Repeat these steps to manage the databases.

Minimum User Requirements

The following are the minimum permissions SevOne NMS needs to poll Oracle database metrics and MySQL database metrics. Grant the Select permission for the following views and tables:

• dba_data_files

• dba_free_space

• dba_tablespaces

• dba_segments

• v$datafile

• v$dispatcher

• v$filestat

• v$instance

• v$latch

• v$librarycache

• v$lock

• v$rollstat

• v$rowcache

• v$sesstat

• v$statname

• v$sysstat