Skip to content

Oracle Database

There are a number of ways you can connect to an Oracle database using Beekeeper Studio.

  1. PSA connection string
  2. SID or Service Name connection string
  3. TSA alias
  4. Host and port

Prerequisites

Linux: Install libaio

sudo apt-get install libaio1 libaio-dev #debian/ubuntu
sudo yum install libaio #redhat/fedora

Download Oracle Instant Client

Before you can connect to Oracle at all you need to tell Beekeeper where on your computer the Oracle Instant Client libraries are stored. This is a downloadable set of files provided by Oracle.

This is an Oracle requirement and not something Beekeeper Studio controls unfortunately

Info

Download the Instant Client from the Oracle website

In Beekeeper Studio you can choose the location of the instant client in the Global Configuration section before making your first connection:

Set oracle instant client

Connection string examples

If you are using a connection string to connect to your database, Beekeeper supports all common forms of Oracle connection strings. See the examples below, or more on the Oracle website

# PDB connection string
<host>:<port>/<PDB>

# simple example with SID or service name
<host>:<port>/<SID or servicename>

# Long service name
(DESCRIPTION=(ADDRESS=(host=host_name)(protocol=protocol_name)(port=port_number))
      (CONNECT_DATA=(SERVICE_NAME=service_name)))

 # Long version with SID
 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=host_name)(Port=port))(CONNECT_DATA=(SID=sid_here)))