Additional permissions/modifications for oracle probe and database user

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

The oracle probe requires additional permissions for some of the following metrics to be collected.  

buf_cachehit_ratio
check_dbalive
index_status
invalid_objects
log_queries
memory_usage
no_next_extents
redo_logs
rollback_segments
sga_memory_free
sort_ratio
user_locks

Environment

Release: UIM 20.x
Component: Oracle probe (any versions) 

Cause

Guidance

Resolution

Create the owner and assign the required privileges as shown below. Execute the following statement, where DB_USER is the name of the user to create, and ts_name is the tablespace for UIM: 

 

create user db_owner IDENTIFIED BY owner_password DEFAULT TABLESPACE ts_name;

 

GRANT SELECT ON SYS.DBA_DATA_FILES TO DBA_USER;

GRANT SELECT ON SYS.DBA_FREE_SPACE TO DBA_USER;

GRANT SELECT ON SYS.DBA_TEMP_FILES TO DBA_USER;

GRANT SELECT ON SYS.V_$ARCHIVE_DEST TO DBA_USER;

GRANT SELECT ON SYS.V_$ARCHIVE_DEST_STATUS TO DBA_USER;

GRANT SELECT ON SYS.V_$DATAFILE TO DBA_USER;

GRANT SELECT ON SYS.V_$DATAFILE_HEADER TO DBA_USER;

GRANT SELECT ON SYS.V_$FILESTAT TO DBA_USER;

GRANT SELECT ON SYS.V_$INSTANCE TO DBA_USER;

GRANT SELECT ON SYS.V_$LATCH TO DBA_USER;

GRANT SELECT ON SYS.V_$LIBRARYCACHE TO DBA_USER;

GRANT SELECT ON SYS.V_$LOG TO DBA_USER;

GRANT SELECT ON SYS.V_$PARAMETER TO DBA_USER;

GRANT SELECT ON SYS.V_$QUEUE TO DBA_USER;

GRANT SELECT ON SYS.V_$RECOVERY_FILE_DEST TO DBA_USER;

GRANT SELECT ON SYS.V_$RESOURCE_LIMIT TO DBA_USER;

GRANT SELECT ON SYS.V_$ROLLSTAT TO DBA_USER;

GRANT SELECT ON SYS.V_$ROWCACHE TO DBA_USER;

GRANT SELECT ON SYS.V_$SESSION TO DBA_USER;

GRANT SELECT ON SYS.V_$SESSION_EVENT TO DBA_USER;

GRANT SELECT ON SYS.V_$SESSTAT TO DBA_USER;

GRANT SELECT ON SYS.V_$SGASTAT TO DBA_USER;

GRANT SELECT ON SYS.V_$SORT_SEGMENT TO DBA_USER;

GRANT SELECT ON SYS.V_$SQLAREA TO DBA_USER;

GRANT SELECT ON SYS.V_$SYSSTAT TO DBA_USER;

GRANT SELECT ON SYS.V_$SYSTEM_EVENT TO DBA_USER;

GRANT SELECT ON SYS.V_$TABLESPACE TO DBA_USER;

GRANT SELECT ON SYS.V_$TEMP_SPACE_HEADER TO DBA_USER;

GRANT SELECT ON SYS.V_$WAITSTAT TO DBA_USER;

GRANT CONNECT TO DBA_USER;

Additional Information

oracle (Oracle Database Monitoring) Release Notes (broadcom.com)