Skip to main content

Oracle

Pre-requisites​

Check the supported versions​

DBmarlin supports most versions of Oracle from 11g and above. Please check the list of supported platforms before continuing and contact us if you are not sure.

info

Note that running DBmarlin does not trigger the use of any Oracle features such as Diagnositic or Tuning Packs that would lead to increased Oracle license costs.

Create a monitoring user with the correct permissions​

Before adding a target Oracle instance in the UI you should first create a dbmarlin user in the target database instance (you can choose to use a name other than dbmarlin if you prefer).

CREATE USER dbmarlin IDENTIFIED BY securepassword
default tablespace users
temporary tablespace temp;
  
GRANT CREATE SESSION, SELECT_CATALOG_ROLE TO dbmarlin;

For Oracle CDB with PDBs​

Create a user in the CDB using the special prefix C##. Connecting to the CDB will allow activity to be monitored across all PDBs.


CREATE USER C##dbmarlin IDENTIFIED BY securepassword
default tablespace SYSTEM 
temporary tablespace TEMP;

GRANT CREATE SESSION to c##dbmarlin CONTAINER=ALL;
GRANT SELECT_CATALOG_ROLE to c##dbmarlin CONTAINER=ALL;
ALTER USER c##dbmarlin SET CONTAINER_DATA=ALL CONTAINER=CURRENT;

Adding the Database Target​

This is done through the User Interface using the Add Database screen