Oracle

Last modified on August 23, 2022

Overview

This guide describes how to connect to an Oracle database using strongDM and DBeaver as the recommended SQL client. While we suggest DBeaver for use with strongDM, SQL*Plus 12.2 and 19.3 also work with Oracle Database versions 11g, 12c, and 19c on macOS.

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, Windows, and Linux installation guides.
  • Make sure you know the credentials for your strongDM account.
  • The Oracle database must be added and configured 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 DBeaver SQL client.

Connect a Resource in strongDM Desktop

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. A green lightning bolt icon indicates a successful connection. If not connected, click the resource to connect and see the lightning bolt icon.

    strongDM Desktop Resources
    strongDM Desktop Resources
  4. Note the port and name listed next to your connected resource.

  5. Continue with the Add a Database Connection in DBeaver section.

Connect a Resource in the strongDM 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 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.

    sdm connect <RESOURCE_NAME>
    
  5. Continue with the Add a Database Connection in DBeaver section.

Add a Database Connection in DBeaver

  1. Launch the DBeaver SQL client.

  2. In DBeaver, click to establish a connection to the Oracle database. Select Oracle.

    DBeaver Connect Oracle Database
    DBeaver Connect Oracle Database
  3. Complete the Oracle Connections Settings. Use these settings:

    FieldValue
    HostThe string localhost
    DatabaseExisting database Service Name; check with your administrator if you do not know this value
    PortPort value listed in the strongDM Desktop application
    UsernameAny string
    PasswordThe string password
    DBeaver Oracle Connection Settings
    DBeaver Oracle Connection Settings
  4. Click to test the connection and see if it is successful.

    DBeaver Test Connection
    DBeaver Test Connection
  5. Click OK then Finish. The new Oracle database is connected and you can now run queries.

Top