Before you can begin using the Management Pack, you must create an adapter instance to identify the host from which the Management Pack will retrieve data.


  1. From the top navigation bar, select Administration. In the right panel, the Solutions view will be displayed.
  2. Select Oracle Database from the Solutions list on the right.
  3. Click the Configure configure_icon icon. The Manage Solution window will appear.
    Note: Click the Add add_icon icon above the Instance Namelist on the left to create multiple adapter instances.

  4. In the Manage Solution window, enter the following information:
    1. Instance Settings:
      • Display Name: A name for this particular instance of the Management Pack.
      • Description: Optional, but it can be helpful to describe multiple adapter instances of the Management Pack.
    2. Basic Settings:
      • Host: Hostname or IP address of your Oracle Database instance
      • Port: Default port is TCP port 1521 (non-SSL), but can be overridden (e.g., Default TCP port of 2484 for SSL)
      • Connection Type: SID/Service Name
      • SID (or Service Name): Enter the actual SID or Service Name, according to selection above.
      • Credential: Select the credential you created when Creating a Credential (Oracle Database).
    3. Advanced Settings
      • Collector: Default Collector/Group is automatically selected. Click the drop-down menu if you want to run the collection on a different node.
      • Support Autodiscovery: Default setting is True, which enables the adapter instance to create resources for you. This should not be set to False.
      • SSL Enable: True/False
      • Query Count: Number to limit queries by
      • Order Queries By: Average Time/Elapsed Time/User I/O Wait Time/Buffer Gets/Physical Read Requests/Executions/Parse Calls/Sharable Memory/Child Count
  5. Click Test Connection to ensure the Management Pack can connect to the specified host, then click Save Settings and Close to save your configuration.

What to do next