I am not able to add Oracle monitor, it says "Permission denied".

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. 

Prerequisites for monitoring Oracle Pluggable Database (PDB) metrics:
  1. SYS or SYSTEM or Common user with CONNECT and SELECT_CATALOG_ROLE roles is required to monitor Oracle PDBs.
  2. 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) ...
                      • 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 ...
                      • Self monitor Applications Manager using APM Insight Java Agent

                        Applications Manager is built with Java, hence we can monitor it using APM Insight Java Agent to measure it's performance continuously, which can be very much useful. Setting up APM Insight Java Agent Follow the below steps to download and set up the ...