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 Oracle 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.
[Screenshot 1 is not available on this page.]
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.
[Screenshot 2 is not available on this page.]
Sample JDBC URL
Syntax: jdbc:oracle:thin:@[ip]:[port]:[sid]
e.g.
jdbc:oracle:thin:@127.0.0.1:1521:xe
Refer here to view Other databases monitoring configuration.