I am not able to add Oracle monitor, it says "Permission denied".
Reason:
Applications Manager requires access to specific Oracle system views in order to collect database performance and availability metrics. If the configured Oracle user lacks sufficient privileges, the monitor cannot be added successfully and a permission denied error may occur.
Solution:
For creating new Oracle database monitor, ensure that the monitoring Oracle user has the necessary permissions:
1. Administrator privileges
2. CONNECT and SELECT_CATALOG_ROLE roles
2. CONNECT and SELECT_CATALOG_ROLE roles
3. Refer Prerequisites or grant view for the Oracle views (oracle-views.html) file attached to this article.
Note: 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 or is not collecting any data. What can I do?
Reason: If the Oracle monitor in ManageEngine Applications Manager is not collecting any data, the issue is most commonly caused by insufficient database privileges to execute the query by the Oracle user configured in the monitor. Solution: Go to ...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) ...Real User Monitor (RUM) - Troubleshooting guide
If your Real User Monitor has not collected data for an extended period, follow the steps below to troubleshoot the issue. Step 1: Verify the RUM Agent configuration Real User Monitoring requires the RUM Agent to be installed and mapped to ...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 ...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 ...