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 attached views (Oracle_views.html) file by adding the following views table to the Oracle_views.html file:
|
Views
|
Grant Permission
|
|
GV$LISTENER_NETWORK
|
GRANT SELECT ON GV$LISTENER_NETWORK TO C##MinPer ;
|
|
gv$parameter
|
GRANT SELECT ON gv$parameter TO C##MinPer ;
|
|
V$VERSION
|
GRANT SELECT ON V$VERSION TO C##MinPer ;
|
|
GLOBAL_NAME
|
GRANT SELECT ON GLOBAL_NAME TO C##MinPer ;
|
|
v$pdbs
|
GRANT SELECT ON v$pdbs TO C##MinPer ;
|
|
gv$osstat
|
GRANT SELECT ON gv$osstat TO C##MinPer ;
|
|
gv$cluster_interconnects
|
GRANT SELECT ON gv$cluster_interconnects TO C##MinPer ;
|
|
v$services
|
GRANT SELECT ON v$services TO C##MinPer ;
|
v$archived_log | GRANT SELECT ON v$archived_log TO C##MinPer ; |
v$appman_alertlog_ext | GRANT SELECT ON v$appman_alertlog_ext TO C##MinPer ; |
v$diag_alert_ext | GRANT SELECT ON v$diag_alert_ext TO C##MinPer ; |
v$appman_redolog_cp_ext | GRANT SELECT ON v$appman_redolog_cp_ext TO C##MinPer ; |
v$appman_redolog_le_ext | GRANT SELECT ON v$appman_redolog_le_ext TO C##MinPer ; |
appman_redolog_cp_view | GRANT SELECT ON appman_redolog_cp_view TO C##MinPer ; |
appman_redolog_le_view | GRANT SELECT ON appman_redolog_le_view TO C##MinPer ; |
dba_hist_sqlstat | GRANT SELECT ON dba_hist_sqlstat TO C##MinPer ; |
dba_data_files | GRANT SELECT ON dba_data_files TO C##MinPer ; |
dba_tablespaces | GRANT SELECT ON dba_tablespaces TO C##MinPer ; |
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) ...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 ...