Oracle Database Monitoring Configuration

Database 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.

e.g. If the new username is appuser and the password is appuserpass.

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

Step 1: Install Applicare SingleAgent in the machine where MySQL Database is running. Follow the steps for installing Applicare SingleAgent

Step 2: After starting the agent, It will be automatically registered in the Applicare controller. Log in to the Applicare console and navigate to the Overview menu.

Step 3: Choose the newly added agent and click on Edit button.

Step 4: Check the "Add Database Configuration" checkbox and choose "Oracle" from the Database dropdown menu. Then, select your Oracle version from the Version dropdown. If your version is not listed, select the most recent version available.

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

Testing the connection is optional. The "Test connection" feature verifies the link between the controller machine and the agent machine. 

Sample JDBC URL

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

e.g.

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

Refer here to view Other databases monitoring configuration.

Docs Home