Extended Monitoring Guide

  • Docs Home
  • Community Home
5. Monitor Multiple SIDs with DNS Aliases
Prev Chapter 40. Oracle Next

5. Monitor Multiple SIDs with DNS Aliases

For environments with a larger number of Oracle databases, one strategy that works well is to associate a DNS alias (CNAME) with each Oracle instance. For example, if the Oracle instance is named ERPPROD, then add a DNS alias like oracle_erpprod (DNS is case-insensitive). If this is done, and the DNS alias is used rather than the actual hostname (such as in tnsnames.ora or Oracle naming service) then all services can refer to the same hostname. When the database is moved to another server all applications (including Zenoss) will be able to continue to use that same hostname.

If the above strategy is followed, the procedure for adding Oracle instances becomes adding new devices for each SID, regardless of the physical device where the Oracle SID is running on.

  1. From the navigation bar, click on the Add Device item under the Management section.

  2. Enter in the following information:

    Table 40.3. Adding Oracle SIDs with DNS Aliases

    NameDescription

    Device Name

    The DNS alias name of the SID (eg oracle_erpprod).

    Device Class Path

    A path under /Server/Oracle

    Discovery Protocol

    Set this to none.


  3. Click on the Add Device button to add the device.

  4. Click on the new device.

  5. Edit the appropriate zProperties for the device(s).

    Table 40.4. Oracle zProperties

    NameDescription

    zOracleUser

    Username with access to the virtual tables.

    zOraclePassword

    Password for the above user.

    zOracleInstance

    The Oracle SID to monitor (eg ERPPROD).


  6. Click Save to save your changes.

Prev Up Next
4. Monitor Multiple SIDs without DNS Aliases Home 6. Daemons