I am not able to add Oracle monitor, it says "Permission denied".
Reason: The required privileges are missing.
Solution: For creating new Oracle database monitor, you should have:
1. Admin privileges.
2. Minimum User privileges ->user with CONNECT and SELECT_CATALOG_ROLE roles.
Some might try changing the SYS as SYSDBA for adding Oracle monitor. It is not possible to change the SYS as SYSDBA because Applications Manager uses JDBC for connecting with Oracle.
In JDBC mode, changing of user into another user privilege is not possible.
1. Admin privileges.
2. Minimum User privileges ->user with CONNECT and SELECT_CATALOG_ROLE roles.
Some might try changing the SYS as SYSDBA for adding Oracle monitor. It is not possible to change the SYS as SYSDBA because Applications Manager uses JDBC for connecting with Oracle.
In JDBC mode, changing of user into another user privilege is not possible.
Prerequisites for monitoring Oracle Pluggable Database (PDB) metrics:
- SYS or SYSTEM or Common user with CONNECT and SELECT_CATALOG_ROLE roles is required to monitor Oracle PDBs.
- If Common user is chosen for monitoring, then the below privilege has to be provided by connecting to the CDB container with SYS user:
alter user set container_data=all container = current;
For example:
alter user C##APM set container_data=all container = current;
The C##APM user has now been given the SELECT role privilege to access all the objects.
New to ADSelfService Plus?
Related Articles
The Oracle monitor is not working / The Oracle monitor is not collecting any data. What can I do?
Reason 1 - This could be because the Oracle user provided in Applications Manager does not have the necessary permission to run the query Go to <AppManager/logs> directory and check if you have an error print in stderr.txt / stderr.txt.1 / ...Self monitor Applications Manager using Real User Monitoring
We can monitor the Applications Manager using Real User Monitoring with a Java Script injection and this can be used to measure the Applications Manager's performance continuously. All you need is to install and setup the Real User Monitoring (RUM) ...How to resolve the "ORA-01017 : Invalid Username/Password; Logon denied" error in an Oracle monitor
In Applications Manager, users might encounter the following error while attempting to add or monitor the Oracle database. This error indicates an issue with authentication credentials or other related configuration settings. To troubleshoot this ...Unable to add some Oracle Monitor(s) in linux machine
Problem: While trying to add Oracle monitor in linux machine it fails with following error message. ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found Cause: This is due to jar incompatibility while adding Oracle ...Real User Monitor (RUM) - Troubleshooting
If the monitor has not polled data for a long time, follow the steps below for troubleshooting: Step 1: Check prerequisites to be done Real User Monitor requires the RUM Agent to be installed and mapped to the Applications Manager. Refer the help ...