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 ...How to import certificates for monitoring Oracle database with SSL authentication?
For users using Applications Manager version 14250 and below: One-way SSL: (Client authentication disabled) 1. Open the command prompt using 'Run as administrator' option and navigate to the Applications Manager installation directory. 2. Import your ...Troubleshooting URL Monitor
When configuring a URL monitor in Applications Manager, you might encounter several errors related to accessibility, configuration, or server-side issues. Below are common errors along with step-by-step troubleshooting instructions to help you ...