This page explains how to add Oracle instances. 

Setting up an Oracle User in Single Instance Database 

Setting up an Oracle User with sys user as sysdba 

In the following commands replace: 

• <password> with the redgatemonitor password 
  
  

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 in Multi-Tenant Database

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

In the following commands replace: 

• <password> with the C##redgatemonitor password 

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;