Oracle

Steps to prepare and connect to Oracle

Lightup account setup

Lightup needs an account that can query data and metadata for all tables you want to monitor. You might already have an account set up that will work, or you might need to create one. Give the account sufficient permissions, preferably using a security role.

Logged into your Oracle database as a DBA, you can run the following DDL to create the Lightup user and a role with sufficient read access, and grant that role to the Lightup user, with the following adjustments:

  • The script creates a user named lightup, but you can use an existing account or a different name.
  • The role name is up to you (read_access might already be in use in your system).
  • Substitute in a password of your own.
CREATE USER lightup IDENTIFIED BY <password>;
GRANT ROLE CONNECT TO lightup;
CREATE ROLE read_access;
GRANT READ ANY TABLE TO read_access;
GRANT ROLE read_access TO lightup;

Connector setting

  • Host - The URL or IP address of the host that processes connection requests (the string between https:// and /). Example: https://host.na.me/
  • Database Name - The name of the database instance that contains your data.
  • Username - The username of the account used for connecting to the database and querying data.
  • Password - The username account's password.

Schema scan frequency

You can adjust how often scans run for a datasource.

  • In section 3 - Advanced, select a value for Schema scan frequency: Hourly, Daily, or Weekly.

Query governance

Oracle datasources support the Query history, Scheduling, Enable data storage, and Maximum backfill duration settings. For steps, see Set query governance settings for a datasource.