SelectStar

Prerequisites

Before attempting to monitor your Oracle database with SelectStar, ensure you are running Oracle 11.2 or greater.

Connection Information

The following information is required by SelectStar in order to monitor to your Oracle instances:

Field
API Field
Description

Host

host

Hostname or IP address of the system on which your database is running

Port

port

Port on which your database is listening [default: 1521]

SID

sid

Oracle System Identifier of your database instance

Service Name

service_name

Global database name

Credentials

Field
API Field
Description

Username

username

Oracle database user

Role

role

User role. One of: normal, SYSDBA, SYSOPER

Password

password

User's password

Access Rights

The following list contains the minimum Oracle Database user privileges required for monitoring with SelectStar. Ensure the Oracle Database user has these permissions granted:

  • create session
  • connect
  • select on dba_data_files
  • select on dba_free_space
  • select on dba_outstanding_alerts
  • select on dba_tablespaces
  • select on dba_temp_files
  • select on dba_temp_free_space
  • select on dba_undo_extents
  • select on global_name
  • select on gv_$archive_dest
  • select on gv_$filestat
  • select on gv_$instance
  • select on gv_$parameter
  • select on gv_$resource_limit
  • select on gv_$session
  • select on gv_$sgainfo
  • select on gv_$sql
  • select on gv_$sysmetric
  • select on gv_$system_event
  • select on gv_$system_wait_class
  • select on gv_$tempstat
  • select on v_$archive_dest
  • select on v_$controlfile
  • select on v_$database
  • select on v_$datafile
  • select on v_$filestat
  • select on v_$instance
  • select on v_$log
  • select on v_$logfile
  • select on v_$parameter
  • select on v_$recovery_area_usage
  • select on v_$resource_limit
  • select on v_$rman_backup_job_details
  • select on v_$tempfile
  • select on v_$version

Creating user for RDS

Run the following command for the monitoring user:

CREATE USER SELECTSTAR_USER IDENTIFIED BY yourmonitoringpassword;

GRANT CONNECT TO SELECTSTAR_USER;
GRANT SELECT on gv$instance to SELECTSTAR_USER
GRANT SELECT on dba_data_files TO SELECTSTAR_USER;
GRANT SELECT on dba_free_space TO SELECTSTAR_USER;
GRANT SELECT on dba_tablespaces TO SELECTSTAR_USER;
GRANT SELECT on dba_temp_files TO SELECTSTAR_USER;
GRANT SELECT on global_name TO SELECTSTAR_USER;

CALL rdsadmin.rdsadmin_util.grant_sys_object('GV_$ARCHIVE_DEST','SELECTSTAR_USER','SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('GV_$FILESTAT', 'SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('GV_$INSTANCE','SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('GV_$PARAMETER','SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('GV_$RESOURCE_LIMIT','SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('GV_$SESSION','SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('GV_$SGAINFO','SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('GV_$SQL','SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('GV_$SYSMETRIC','SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('GV_$SYSTEM_EVENT','SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('GV_$SYSTEM_WAIT_CLASS','SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('GV_$TEMPSTAT','SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('V_$ARCHIVE_DEST','SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('V_$CONTROLFILE','SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('V_$DATABASE','SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('V_$DATAFILE','SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('V_$FILESTAT','SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('V_$INSTANCE','SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('V_$LOG','SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('V_$LOGFILE','SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('V_$PARAMETER','SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('V_$RECOVERY_AREA_USAGE','SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('V_$RESOURCE_LIMIT','SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('V_$RMAN_BACKUP_JOB_DETAILS','SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('V_$TEMPFILE','SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('V_$VERSION','SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('DBA_UNDO_EXTENTS', 'SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('DBA_UNDO_EXTENTS', 'SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('DBA_TEMP_FREE_SPACE', 'SELECTSTAR_USER', 'SELECT');
CALL rdsadmin.rdsadmin_util.grant_sys_object('DBA_OUTSTANDING_ALERTS', 'SELECTSTAR_USER', 'SELECT');

Oracle