> ## Documentation Index
> Fetch the complete documentation index at: https://docs.summation.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Oracle

> Connect Summation to an Oracle Database, including Oracle Autonomous Database.

The Oracle connector supports standard Oracle databases and **Oracle Autonomous Database** (which requires TLS / TCPS and a wallet certificate). The form is split into three sections — *Connection*, *Credentials*, and *Wallet SSO Certificate*.

## What you'll need

* A reachable Oracle host and port (default `1521`).
* A **service name** (not SID).
* A user with `SELECT` on the schemas/tables you want exposed.
* For Autonomous Database, the **client credentials wallet** (`Wallet_<dbname>.zip`) downloaded from the OCI console. See [Download client credentials](https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/connect-download-wallet.html).

## Connection

The Connection section has a toggle at the top — describe the connection either as host/port/service, or as a single EZConnect-style string. The two views stay in sync: filling host/port/service builds the equivalent string, and pasting a string parses it back into the discrete fields when possible.

EZConnect syntax is documented under [Easy Connect Naming Method](https://docs.oracle.com/en/database/oracle/oracle-database/19/netag/configuring-naming-methods.html#GUID-8C85D289-6AF3-41BC-848B-BF39D32648BA) in the Oracle Net Services Administrator's Guide.

### Host & service name (default)

| Field            | Required | Stored as | Notes                                                                                                                                                                                                               |
| ---------------- | -------- | --------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| **Protocol**     | Yes      | Config    | `TCP` or `TCPS (TLS)`. **Autonomous DB requires TCPS.**                                                                                                                                                             |
| **Host**         | Yes      | Config    | DNS name, e.g. `db.example.com`.                                                                                                                                                                                    |
| **Port**         | Yes      | Config    | Default `1521`.                                                                                                                                                                                                     |
| **Service Name** | Yes      | Config    | Oracle service name, e.g. `XEPDB1`. See [Specifying a Service Name](https://docs.oracle.com/en/database/oracle/oracle-database/19/netag/configuring-naming-methods.html#GUID-DBD81DF5-1E4A-4C6E-A5D3-BE1ECC34B81A). |

### Connection string

| Field                 | Required | Stored as | Notes                                                      |
| --------------------- | -------- | --------- | ---------------------------------------------------------- |
| **Connection String** | Yes      | Config    | EZConnect-style DSN, e.g. `tcps://host:1522/service_name`. |

## Credentials

| Field        | Required | Stored as | Notes        |
| ------------ | -------- | --------- | ------------ |
| **Username** | Yes      | Config    | Oracle user. |
| **Password** | Yes      | Secret    |              |

## Wallet SSO Certificate (optional)

Required for Oracle Autonomous Database and any deployment that uses a wallet for TLS. You can either upload the wallet file or paste its contents. To find the wallet, see [Download client credentials](https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/connect-download-wallet.html) — the file you want is `cwallet.sso` from the unzipped wallet bundle.

| Input mode         | Notes                                                                                                  |
| ------------------ | ------------------------------------------------------------------------------------------------------ |
| **Upload file**    | Click **Upload cwallet.sso** and select the wallet file from the unzipped Autonomous DB wallet bundle. |
| **Paste contents** | Paste the raw certificate. Useful when uploading from your machine isn't possible.                     |

The certificate is stored as a secret. Summation base64-encodes it for you — you don't need to encode it by hand.

## Adding datasets

Source references quote the schema and table names:

```
oracle:"MY_SCHEMA"."MY_TABLE"
```

## Common problems

| Error or symptom                       | Likely cause                                                                                    |
| -------------------------------------- | ----------------------------------------------------------------------------------------------- |
| `ORA-12506` or other wallet errors     | Autonomous DB requires `cwallet.sso`. Upload the wallet and set **Protocol** to `TCPS`.         |
| `ORA-12541: TNS:no listener`           | Wrong host or port, or a firewall is blocking the connection.                                   |
| `ORA-01017: invalid username/password` | Wrong credentials. Oracle locks accounts after repeated failures — an admin may need to unlock. |