Redgate Monitor 14

This page explains how to add Oracle instances. Please choose the tab for the host type you are adding to Redgate Monitor.

In Redgate Monitor, supported versions of Oracle servers can be found here.

For Linux, supported versions can be found here.

Setting up an Oracle User

In the following commands replace:

<password> with the password for the user being created

Setting up an Oracle User with sys user as sysdba

CREATE USER redgatemonitor IDENTIFIED BY "<password>";
  
GRANT CONNECT TO redgatemonitor;
 
GRANT SELECT_CATALOG_ROLE TO redgatemonitor;

GRANT SELECT ON V$DIAG_ALERT_EXT TO redgatemonitor;
 
GRANT CREATE TABLE TO redgatemonitor;

Setting up an Oracle User from the Root Container Database with sys user as sysdba

CREATE USER C##redgatemonitor IDENTIFIED BY "<password>";
 
ALTER USER C##redgatemonitor SET CONTAINER_DATA=ALL CONTAINER=CURRENT;
 
GRANT CONNECT TO C##redgatemonitor CONTAINER=ALL;
 
GRANT SELECT_CATALOG_ROLE TO C##redgatemonitor CONTAINER=ALL;
 
GRANT SELECT ON V$DIAG_ALERT_EXT TO C##redgatemonitor CONTAINER=ALL;
 
GRANT CREATE TABLE TO C##redgatemonitor;

Setting up an Oracle User with the Amazon RDS "Master username" user (default admin)

CREATE USER redgatemonitor IDENTIFIED BY "<password>";
  
GRANT CONNECT TO redgatemonitor;
 
GRANT SELECT_CATALOG_ROLE TO redgatemonitor;

begin
rdsadmin.rdsadmin_util.grant_sys_object(
p_obj_name => 'V_$DIAG_ALERT_EXT',
p_grantee => 'REDGATEMONITOR',
p_privilege => 'SELECT',
p_grant_option => true);
END;
 
GRANT CREATE TABLE TO redgatemonitor;

Redgate Monitor 14

Preparing Oracle for monitoring

Setting up an Oracle User