ABOUT

Oracle Monitors collect oracle specific metrics from Oracle DB servers in real time for observability of Oracle DB. This is supported in both Linux/Unix and Windows OS. In Linux/Unix, Java based agent is used. In windows, you can use C# based agent (preferred) or java based agent. Agent runs DB queries periodically to collect metrics/detailed information. There are two types of monitoring:

Time Series Metric Monitoring (TSMM)
Detailed DB monitoring (DDBM)

PREREQUISITES

For Java based agent, compatible oracle JDBC driver should be available on the server where agent is running. You can download it from ’Download Oracle JDDB Driver Jar’ (https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html
a. This jar file is to be specified in the Class Path
Read-only user with required access to Oracle DB Server.
You can use any existing user or create a new user ‘cavisson’ using following steps:

            
                -- Enable Oracle Script (needed for oracle version lower than 11g)

                ALTER SESSION SET "_ORACLE_SCRIPT"=true;

                -- Create the cavisson user. Use a strong and secure password.

                CREATE USER cavisson IDENTIFIED BY ;

                -- Grant access to the cavisson user.

                GRANT CONNECT TO cavisson;

                GRANT SELECT ON GV_$PROCESS TO cavisson;

                GRANT SELECT ON gv_$sysmetric TO cavisson;

                GRANT SELECT ON sys.dba_data_files TO cavisson;

                GRANT SELECT ON sys.dba_tablespaces TO cavisson;

                GRANT SELECT ON sys.dba_tablespace_usage_metrics TO cavisson;

Host Containerized

{"server": "%%host%%:1521", "service_name":"", "username":"cavisson", "password":""}

Troubleshooting JDBC Driver Related Issues (For Java Based Agent Only)