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.
- From the top navigation bar, select Administration. In the right panel, the Solutions view will be displayed.
- Select Oracle Database from the Solutions list on the right.
- Click the Configure icon. The Manage Solution window will appear.
Click the Add
icon above theInstance Namelist on the left to create multiple adapter instances.
- In the Manage Solution window, enter the following information:
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.
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.
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.
- 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
To validate data collection, see: Validating Data Collection (Oracle Database).