Oracle

This procedure explains how to configure an Oracle database connection, including both database types (Oracle and Oracle for 9.X, 10.X, 11.1).

Before you begin: Make sure your database instance is configured to accept incoming connections from the following IP address:
63.33.83.29
If you are using Datalore On-Premises, its IP address is different. Contact your Datalore administrator for details.

Configure an Oracle database connection

Open the New Oracle connection dialog.
1. Open the Attached data tool from the left-hand sidebar.
2. Switch to the Databases tab. You will see the list of all database connections available from the respective workspace.
3. Click New database.
4. In the New database connection dialog, select Oracle.
1. In the sidebar on the Home page, select the workspace where you want to create an Oracle connection.
2. In the workspace resources, select Data and switch to the Databases tab.
3. Click New database connection at the top right.
4. In the dialog, select Oracle or Oracle for 9.X, 10.X, 11.1 depending on your database type.
On the General tab, select the connection type.
- SID: to connect by using a unique name of an Oracle instance (a process that runs on the workstation).
- Service name: to connect by using an alias to an Oracle instance (or many instances).
- URL only: to connect by providing the URL of a pre-built connection.
  Use this method to pass additional parameters. For example, add &SSL=true to the URL string to enable SSL.
Proceed based on the selected connection type:
1. In the Host field, type your server address.
2. In the Port field, type the port. The default port is 1521.
  Real port numbers might be different on your system. Verify that you use a correct port number with your database administrator, server settings, or hosting provider.
3. In the SID field, specify a unique name of an Oracle instance (a process that runs on the workstation).
  For the correct value, check the environment variable ORACLE_SID on the server host, or contact your database administrator. Commonly-used values are XE or ORCL.
4. From the Driver list, select the Oracle JDBC driver mode to use with your connection:
  - Thin: the driver connects to the server directly.
  - OCI and OCI8: the driver uses native libraries to connect to the server.
5. Under Authentication, select an authentication method:
  - User & Password: to use your login and password
  - No auth: to connect without authentication required
6. In the User and Password fields, specify your credentials if required by the selected authentication method.
1. In the Host field, type your server address.
2. In the Port field, type the port. The default port is 1521.
  Real port numbers might be different on your system. Verify that you use a correct port number with your database administrator, server settings, or hosting provider.
3. In the Service field, provide the alias to an Oracle instance that you want to use.
4. From the Driver list, select the Oracle JDBC driver mode to use with your connection:
  - Thin: the driver connects to the server directly.
  - OCI and OCI8: the driver uses native libraries to connect to the server.
5. Under Authentication, select an authentication method:
  - User & Password: to use your login and password
  - No auth: to connect without authentication required
6. In the User and Password fields, specify your credentials if required by the selected authentication method.
1. Under Authentication, select an authentication method:
  - User & Password: to use your login and password
  - No auth: to connect without authentication required
2. In the User and Password fields, specify your credentials if required by the selected authentication method.
3. In the URL field, provide the URL of the pre-built connection you want to establish.
(Optional) For other options (SSH tunneling, scope inspection, or additional connection parameters), switch to the respective tab of the dialog and follow one of these procedures.
Click the Test connection button at the bottom of the dialog.
Once the connection is successfully tested, click the Create and close button.

Attach the connection to a notebook

If the notebook is not running, start it by clicking Run | Start machine.
In the sidebar, select Attached data and switch to the Databases tab.
Enable the toggle in your Oracle connection.

Open the notebook you want to attach the connection to.
If the notebook is not running, start it by clicking Run | Start machine.
In the sidebar, select Attached data and switch to the Databases tab.
Enable the toggle in your Oracle connection.

Next steps

To retrieve and process data from the connected database, use Query data with SQL cells.
Learn how to manage and delete database connections in a workspace and in a notebook.

17 November 2025