# Oracle User Guide

### Overview

This guide describes how to connect to an Oracle database using StrongDM and any supported client. See the [Oracle](/admin/resources/datasources/oracle.md) resource administration guide for additional information on setting up an Oracle resource or for a list of supported client versions.

### Prerequisites

To establish a successful connection using this guide, note the following prerequisites:

* StrongDM Desktop or the CLI must be installed and set up on your machine. See our [macOS](/users/client/macos.md), [Windows](/users/client/windows.md), and [Linux](/users/client/linux.md) installation guides.
* Make sure you know the credentials for your StrongDM account.
* The Oracle database must be [Oracle](/admin/resources/datasources/oracle.md) by an administrator in the StrongDM Admin UI. It must be healthy and online.
* You must be granted access to the database resource in the StrongDM Admin UI.
* Download and install the correct client for your use case. This guide will use the example of the DBeaver SQL client.

### Connect to the Resource in StrongDM

You can use either the StrongDM Desktop application or the CLI to connect to your Oracle resource.

#### Use the Desktop App

Before you add the database connection in your SQL client, connect to the StrongDM resource first. After you establish this connection, all database access is proxied through StrongDM. To connect to your Oracle database using StrongDM Desktop, use the following steps.

1. Launch StrongDM Desktop on your computer.
2. Log in with the credentials used during StrongDM account setup.
3. After login, accessible resources display in the desktop app, and you can see that you are connected. If you are disconnected, click the lightning icon beside the resource to connect.
4. Note the port and name listed next to your connected resource.
5. Continue with the [Connect to Oracle](#connect-to-oracle) section.

#### Use the CLI

Before you add the database connection in your SQL client, connect to the StrongDM resource first. After you establish this connection, all database access is proxied through StrongDM. To connect to your Oracle database using the StrongDM CLI, use the following steps.

1. Open your command line or terminal.
2. Use [sdm login](/references/cli/login.md) to authenticate.
3. Run `sdm status` to view available resources and connection status. Note the port and name for your Oracle datasource.
4. Connect to the datasource using the StrongDM CLI. Make sure to update the placeholder text with the name of your actual resource.

   ```shell
   sdm connect <RESOURCE_NAME>
   ```
5. Continue with the [Add a Database Connection in DBeaver](#add-a-database-connection-in-dbeaver) section.

### Connect to Oracle

1. Launch your client (such as DBeaver SQL).
2. In your client, create a new connection/database for the **Oracle** type. In DBeaver, create a new connection and select **Oracle**.

   ![](/files/KinLGFw9G8MTy7Y2knu7)
3. Fill out the connection settings. Remember that the connection settings are not actual credentials. Credentials are injected by StrongDM at the time of connection to the resource and don't have to be input here. In DBeaver, the connection settings are under **Oracle Connections Settings**. Use the following table to assist:

| Client        | Hostname    | Username   | Password   |
| ------------- | ----------- | ---------- | ---------- |
| DBeaver       | `localhost` | any string | `password` |
| SQL Developer | `localhost` | any string | `password` |
| SQLPlus       | `localhost` | any string | `password` |
| Toad          | `127.0.0.1` | any string | any string |

* If asked for a value for **database**, enter your database's existing service name.
* If asked for a port, enter the port that was assigned by StrongDM, visible in the desktop app or CLI.

  ![](/files/Rm9ozI34dYZoGtyuvU7o)

4. Click to test the connection and see if it is successful.

   ![](/files/u5Hiom4COtAJondwHtNz)
5. Save your connection configuration (in DBeaver, click **OK** then **Finish**). You can now run queries against Oracle through StrongDM, as far as your permissions allow.

### Oracle NNE

For Oracle (NNE) resources, the following properties should be set to "ACCEPTED":

* `oracle.net.encryption_client`
* `oracle.net.crypto_checksum_client`

For DBeaver these properties are configurable under **Connection settings** > **Oracle properties**.

For SQL Developer, these properties may be configured in `sqldeveloper.conf` or `sqlnet.ora`, depending on the driver being used.


---

# Agent Instructions: 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:

```
GET https://docs.strongdm.com/users/connect/connect-oracle.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
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.