RESOLUTION 1 Using the database agent administration panel *This is the recommend method*
Steps to add OS monitoring to a database agent.
- Select (Check box) the agent in the database dashboard
- Select the database agent checkbox
- Select "Settings" and "Administration"
- Choose Connection Details and click Set credentials
- In the Set credentials box under OS Monitoring, click Edit Host Connection Details radial button and checkmark Enable OS Monitoring.
- Choose the desired connection method and appropriate the Authentication selection.
- Configure the required OS credentials then click the validate button.
- When the validate return is successful, click save to write the changes updating the Agent for OS monitoring.
Note: During the validation process the resource mapping is getting created.
RESOLUTION 2 Manually creating credentials
- Setup an infrastructure agent for the database server
- Enable the OS monitoring for the database agent
- Go to "Administration | Agents | Agent Status" dashboard
- Select the problematic agent
- Click on "Edit Properties"
- Find "Host OS Platform" and set the parameter "Enable OS collections" to "True" and the select the correct OS from the "Platform" drop down list
- Add the resource mapping of the OS credential for database monitoring connection
- Go to "Administration | Credential" dashboard
- Click on "Manage Credentials"
- Find the needed credential, click the "Edit" icon in the second column and select "Resource Mappings"
- Click on "Add" and select the following mapping:
Unix: "SSH Connection for DB Monitoring"
or Windows: "WMI Connection for DB Monitoring" - "Target Host Name" if the host name will be used or "Target Host Address" if the IP will be used
- Select radio button "equals" and matching type "Domain Name"
- Now click on "Add a New Domain Name" or "Add a New IP Address" and enter the host name or IP address
- Click on "Add" and the newly resource mapping is create
- Next click Add 'AND' Condition on the newly created resource mapping
- Select Agent name for Access Resources Using
- Click on Add a New String
- Enter the Database Agent Name. This value is case sensitive and must match the entry under Agent Name taken from Dashboards | Administration | Agents | Agent status
- Click on "Save" to save the changes
- Finally restart the database agent.
It will take few minutes until OS data will be displayed on the database dashboards.