> For the complete documentation index, see [llms.txt](https://docs.lightbeam.ai/lxqobxw6ak7CTnsQjikH/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.lightbeam.ai/lxqobxw6ak7CTnsQjikH/core-features/spectra-ai/data-sources/databases-and-datalakes/oracle.md).

# Oracle

Connecting Redshift to LightBeam

***

## Overview

Oracle relational database is available at different platforms (Oracle cloud, onprem, dedicated infrastructure, AWS RDS etc). Oracle calls databases as schemas. A database user owns a database schema, which has the same name as the user name. Inside it there are tables and columns.

***

### Onboarding Oracle Data Source

1. Login to your LightBeam Instance.<br>
2. Click on **DATASOURCES** on the Top Navigation Bar.<br>
3. Click on **“Add a data source”.**

<figure><img src="https://682442409-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F0FnJiPbEPpkm5U4tiZUM%2Fuploads%2Fp2Mfhc1mzVKcuFg20NGT%2FScreenshot%202024-08-22%20at%204.23.21%20PM.png?alt=media&amp;token=35a1228f-8566-4a7a-b3c6-4de75dd2d15b" alt="" width="298"><figcaption><p>Figure 1. Add Data Source</p></figcaption></figure>

4. Search for **Oracle** and select it.

<figure><img src="https://682442409-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F0FnJiPbEPpkm5U4tiZUM%2Fuploads%2FYxyod5Orm6CXcmyZPkfl%2FScreenshot%202024-08-22%20at%204.23.32%20PM.png?alt=media&amp;token=e661d14c-ab3a-489a-a772-99cb9597f0fe" alt="" width="157"><figcaption><p>Figure 2. Search Oracle</p></figcaption></figure>

5\. **Configure Basic Details**

In the **Basic Details** section, enter the following information:

* **Instance Name**: Provide a unique name for the Oracle data source (e.g., `oracle-datasource`).
* **Primary Owner**: Enter the email address of the individual responsible for this data source (e.g., `demo@lightbeam.ai`).
* **Source of Truth (Optional)**: Toggle this option **on** if this database serves as a **single source of truth** for entity validation.
* **Description** (Optional): Add a brief description of the database (e.g., "Oracle Datasource Instance").<br>

  <figure><img src="https://682442409-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F0FnJiPbEPpkm5U4tiZUM%2Fuploads%2FGSEbjMEnyxcKc8Hv7CSG%2Fimage.png?alt=media&amp;token=2fa00909-38a7-4cb3-a464-140dc2d0e87f" alt=""><figcaption><p>Figure 3. Oracle  - Basic Configuration &#x26; Connection Details</p></figcaption></figure>

6. **Enter Connection Details**

Provide the following details in the **Connection** section:

* **Username**: The username for database authentication.
* **Password**: The corresponding password for the username.
* **Host**: The Oracle database server address (e.g., `oracle-db.mycompany.com`).
* **Port**: The port number used for Oracle connections (default **1521**).
* **Service Name**: The Oracle **Service Name** or **SID** to connect to.
* **Encryption Mode**: Select between:
  * **Encrypted** (Recommended for secure connections).
  * **Unencrypted** (For non-secure connections).
* **Wallet (Optional)**: If using an tcps **connection**, click **Upload Wallet** to provide the zipped wallet file.
* **Wallet Password(Optional)**:  If the TCPS connection requires a wallet, enter the wallet password.<br>

7. Click **Test Connection** to validate the credentials. If successful, you will see a **Test Connection Success** message.

<figure><img src="https://682442409-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F0FnJiPbEPpkm5U4tiZUM%2Fuploads%2FjCLBD6WXgMcEEko1RRXU%2FScreenshot%202025-09-22%20at%202.20.29%E2%80%AFPM.png?alt=media&amp;token=b814036a-a90f-4264-b931-e11461f0757a" alt=""><figcaption><p>Figure 4. Oracle  - Basic Configuration &#x26; Connection Details</p></figcaption></figure>

**8. Additional Details (Optional)**

In this section, you can specify metadata attributes related to the data source:

* **Location:** The location of the data source.
* **Purpose:** The purpose of the data being collected/processed.
* **Stage**: The stage of the data source. **Example**: Source, Processing, Archival, etc.

{% hint style="info" %}
Select Encrypted/Unencrypted option depending upon SSL enforcement from database server. For Oracle cloud Encrypted option needs to be set always.
{% endhint %}

9. Verify that you get the message **Connection Success!** on the screen. Click on **Next**. \ <br>
10. In the next step, you'll see a list of databases presented from your Oracle database server.<br>

<figure><img src="https://682442409-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F0FnJiPbEPpkm5U4tiZUM%2Fuploads%2FBv76Q3PFa0ROUVu93sao%2FScreenshot%202024-08-22%20at%204.26.03%20PM.png?alt=media&amp;token=1a6dcd6f-f98d-41e8-ae5e-92dbb9b5cf3f" alt="" width="375"><figcaption><p>Fig 5. Databases list</p></figcaption></figure>

**Displayed Databases:** By default, all databases to which you have access permissions will be shown.

**Custom Selection:** If you wish not to scan certain databases, simply deselect them from the list.

Please select the list of databases that you wish to scan.. Ensure you've made your desired selections before connecting the datasource.

***

## APPENDIX

### Minimal permissions setup&#x20;

A database user is needed with minimal read only permissions for connecting and scanning the datasource.

1. Create a new database user with a password

&#x20;            `CREATE USER <username> IDENTIFIED BY <password>`

2. Grant connect permission to the user.

&#x20;             `GRANT CONNECT TO <username>`

3. Grant following select permissions.

&#x20;                `GRANT SELECT ON sys.dba_segments TO <username>`

`BEGIN`

`FOR R IN (SELECT owner, table_name FROM all_tables WHERE owner in (‘ADMIN’, ‘TEST’))`             &#x20;

`LOOP`

`EXECUTE IMMEDIATE 'grant select on '||R.owner||'.'||R.table_name||' to <username>;`                      &#x20;

`END LOOP;`

(‘ADMIN’, ‘TEST’) <- Replace this list with names of database to be scanned.

\<username> <- Replace username.<br>

\
Use the user just created to register **Oracle** datasource.

### Validate permissions to the database

Next, the user needs to validate these permissions to the database. This ensures authorized access to the database by the credentials provided by the user. After validating the permissions to the database, the user can configure LightBeam Spectra on the system.

#### Steps

1. First, clone the repository [`https://github.com/lightbeamai/lb-installer`](https://github.com/lightbeamai/lb-installer)
2. Go into `sql_user_check_oracle` directory
3. Please refer to the **`README.md`** file in the directory for detailed instructions.

***

## About LightBeam

LightBeam automates Privacy, Security, and AI Governance, so businesses can accelerate their growth in new markets. Leveraging generative AI, LightBeam has rapidly gained customers’ trust by pioneering a unique *privacy-centric* and *automation-first* approach to security. Unlike siloed solutions, LightBeam ties together sensitive data cataloging, control, and compliance across structured and unstructured data applications providing 360-visibility, redaction, self-service DSRs, and automated ROPA reporting ensuring ultimate protection against ransomware and accidental exposures while meeting data privacy obligations efficiently. \
\
LightBeam is on a mission to create a secure privacy-first world helping customers automate compliance against a patchwork of existing and emerging regulations.

For any questions or suggestions, please get in touch with us at: <support@lightbeam.ai>.<br>


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.lightbeam.ai/lxqobxw6ak7CTnsQjikH/core-features/spectra-ai/data-sources/databases-and-datalakes/oracle.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.