Oracle Database Monitoring Configuration

DB User Permissions

Create a new user and provide the below two permissions.

1. User should have select access to all the tables.

2.  User should have CONNECT,  AUTHENTICATEDUSER, OEM_ADVISOR, SELECT ANY TABLE, SELECT ANY DICTIONARY permissions.

Syntax:

CREATE USER <new_user> IDENTIFIED BY "<password>" ;
GRANT CONNECT,  AUTHENTICATEDUSER, OEM_ADVISOR, 
SELECT ANY TABLE, SELECT ANY DICTIONARY TO <new_user>;

Replace <new_user> and <password> with the newly created username and password.

Example: Let's consider newly created username is appuser and password is appuserpass.

CREATE USER appuser IDENTIFIED BY "appuserpass" ;
GRANT CONNECT, AUTHENTICATEDUSER, OEM_ADVISOR, 
SELECT ANY TABLE, SELECT ANY DICTIONARY TO appuser;

Step 1: Login into Applicare console, go to Download Agents screen and download SingleAgentWindows. Copy ApplicareSingleAgentWindows.zip file to the machine where oracle is running.

Step 2: Start the agent by running the startAgent.bat (Administrator mode for windows) and startAgent.sh (sudo for linux) inside the ApplicareSingleAgent.zip extracted directory.

Step 3: Once the agent is started, it will be automatically added in the Applicare controller. Login into the Applicare console and go to the Overview menu.

Step 4: Select the newly added agent and click on Edit button.

Step 5: Enable the "Add Database Configuration" checkbox and select "Oracle" option from Database dropdown. Select your  oracle version in Version dropdown. If the version is not available in the dropdown then select the latest version which is available in the dropdown.

Step 6: Enter the JDBC URL, Username and Password and click on update button.

Note:
Checking Test connection is not mandatory. Test connection will test the connection from controller machine to agent machine.

Sample JDBC URL

Syntax: jdbc:oracle:thin:@[ip]:[port]:[database]

samples:

jdbc:oracle:thin:@127.0.0.1:1521:xe

Refer here to view Other Database monitoring configuration.

For Other Docs - Click here