How to start a Database Proxy Oracle session with DBeaver on Windows

This document will guide you through a step-by-step process on how to use the DBeaver manager in a Database Proxy session on Windows.

Requirements

• Download the latest version of Instant Client - Instant Client
• Download the latest version of DBeaver - Dbeaver

Star session at the DBeaver app

1. Open the DBeaver app.
2. On the main screen, in the left top corner, click on the icon represented by the plug and the plus sign.
3. On the pop-up window that opens, Connect to a database, select Oracle.
4. Click Next.
5. Click Driver Settings.
6. At Libraries tab.
   1. replace the default library for the ones acquired at Instant Client.
7. Click OK.
8. At DBeaver folder, create a file named start-dbeaver.bat to declare the variables and open the DBeaver.
9. On the created file, type:

@echo off
chcp 65001

:: Add the Oracle Instant Client to the PATH (while keeping the existing PATH)
set PATH=C:\Users\user1\Documents\instantclient_21_10;%PATH%

:: Point TNS_ADMIN to the folder containing tnsnames.ora and sqlnet.ora
set TNS_ADMIN=C:\Users\user1\Documents\dbproxy\ora-files

:: Launch DBeaver
start dbeaver

10. Save this file as start-dbeaver.bat

11. With this file, execute a custom connection at the DBeaver app.

12. On Connection settings > Principal > Custom, fill in the information on the fields:

    1. JDBC URL Template: jdbc:oracle:oci:@<ORACLEDB_HOSTNAME>
    2. Authentication: choose the desired option.
       Attention

       If the Oracle Database Native option is selected, the username and password fields must remain empty. Filling in these fields will cause a connection error.

13. Click Ok.

Once this is done, the user can connect to the Oracle database through the Segura® Database Proxy.