Monitoring categories and user permissions
The PATROL for Oracle Enterprise Database KM provides the following monitoring categories for the Oracle standalone and RAC database instances.
For initial connection and availability monitoring, you must use the GRANT CREATE SESSION TO <username> permission. This permission allows the user entered in the environment configuration's Oracle credentials to monitor the database.
Depending on the monitoring category, you must grant certain permissions so each user can access the Oracle objects that are required for each of the monitoring categories.
The following table lists the monitoring category and the required Oracle objects used to perform the monitoring functions.
Monitoring category | Monitor types | Grant types | Variables and authorizations |
|---|---|---|---|
ASM | GRANT SELECT | V$ASM_DISK_IOSTAT V$ASM_DISKGROUP_STAT V$ASM_DISK_STAT GV$ASM_DISK_IOSTAT GV$ASM_DISKGROUP_STAT GV$ASM_DISK_STAT | |
Availability and Connection | GRANT CREATE GRANT SELECT | SESSION V$PARAMETER V$DATABASE | |
Fast Recovery Area | GRANT SELECT | V$RECOVERY_FILE_DEST V$FLASH_RECOVERY_AREA_USAGE | |
Listeners | GRANT SELECT | V$INSTANCE | |
Operating System usage | GRANT SELECT | V$RESOURCE_LIMIT V$OSSTAT GV$RESOURCE_LIMIT GV$OSSTAT | |
Pluggable database | GRANT SELECT | DBA_PDBS V$PDBS V$DATABASE V$SESSION CDB_TABLESPACES CDB_TABLESPACE_USAGE_METRICS GV$PDBS GV$SESSION | |
ALTER USER | <MONITOR USER NAME> SET CONTAINER_DATA=ALL CONTAINER=CURRENT | ||
RAC | GRANT SELECT | V$DATABASE V$INSTANCE GV$DATABASE GV$INSTANCE | |
Services | GRANT SELECT | V$SERVICEMETRIC GV$SERVICEMETRIC | |
Sessions | GRANT SELECT | V$SESSION V$LOCK GV$SESSION GV$LOCK | |
Standby Health | GRANT SELECT | V$DATAGUARD_STATS V$RECOVERY_PROGRESS V$LOGSTDBY_STATS | |
System | GRANT SELECT | V$METRIC | |
UNDO usage | GRANT SELECT | V$PARAMETER V$UNDOSTAT | |
Users | GRANT SELECT | V$METRIC | |
Wait events | GRANT SELECT | V$WAITCLASSMETRIC_HISTORY GV$WAITCLASSMETRIC_HISTORY V$EVENT_NAME GV$ENVENT_NAME | |
Jobs | GRANT SELECT | DBA_SCHEDULER_JOB_RUN_DETAILS DBA_SCHEDULER_RUNNING_JOBS DBA_SCHEDULER_JOBS | |
Tablespaces | GRANT SELECT | DBA_TABLESPACE_USAGE_METRICS DBA_TABLESPACES |
Oracle Net Listeners
The following table lists the permissions that PATROL OS account (for local monitoring) and Oracle host user (for remote monitoring) require to monitor Oracle Net Listeners:
File/utility | Permission |
|---|---|
ORACLE_HOME\bin\lsnrctl $ORACLE_HOME/bin/lsnrctl | Execute |
ORACLE_HOME\bin\CRSCTL $ORACLE_HOME/bin/CRSCTL | Execute |
listener.ora | Read |
tnsnames.ora | Read |