Extended Monitoring Guide

  • Docs Home
  • Community Home
3. Enable Monitoring
Prev Chapter 40. Oracle Next

3. Enable Monitoring

3.1. Authorize Oracle Performance Data Access

For each Oracle instance to be monitored, create an Oracle user that has read privileges to the v$statname and v$sysstat tables. These virtual tables contain the information that Zenoss uses in order to report on Oracle performance.

3.2. Configure Zenoss

All Oracle services must have a device entry under the /Devices/Server/Oracle device class.

  1. Navigate to the device or device class under the /Devices/Server/Oracle device class in the Zenoss web interface.

  2. If applying changes to a device, click the page menu, then select More → zProperties.

    If applying changes to a device class, click on the zProperties tab.

  3. Edit the appropriate zProperties for the device or devices.

    Table 40.2. Oracle zProperties

    NameDescription

    zOracleUser

    Username with access to the virtual tables.

    zOraclePassword

    Password for the above user.

    zOracleInstance

    The Oracle SID to monitor.


  4. Click Save to save your changes.

    You will now be able to start collecting the Oracle server metrics from this device.

  5. Navigate to the Perf tab and you should see some placeholders for graphs. After approximately 15 minutes you should see the graphs start to become populated with information.

Prev Up Next
2. Prerequisites Home 4. Monitor Multiple SIDs without DNS Aliases