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 Configureconfigure_icon icon. The Manage Solution window will appear.

    Click the Add


     icon above theInstance Namelist on the left to create multiple adapter instances.

  4. In the Manage Solution window, enter the following information:
    1. Instance Settings:

      • 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. Connect Information:

      • Host: Hostname or IP address of your Oracle Database instance

      • 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).

      • Collector/Group: Default Collector/Group is automatically selected. Click the drop-down menu if you want to run the collection on a different node.

    3. Advanced Settings

      • Port: Default port is TCP port 1521 (non-SSL), but can be overridden (e.g., Default TCP port of 2484 for SSL)

      • SSL Configuration: Default setting is Verify.

      • Collect Filesystem Statistics: Default setting is True .

      • Collect Archive Logs: Default setting is False .

      • Connection Pool Size: 3

      • Collect Events: Default setting is True .

      • Order Queries By: Average Time/Elapsed Time/User I/O Wait Time/Buffer Gets/Physical Read Requests/Executions/Parse Calls/Sharable Memory/Child Count

      • Total Query Limit: Number to limit queries by

      • Active Query Limit: Number to limit queries by

      • Support Autodiscovery: Default setting is True, which enables the adapter instance to create resources for you. This should not be set to False.

  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