How to start a Database Proxy Oracle session with DBeaver on Windows
  • 1 minute to read
  • Dark
    Light
  • PDF

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

  • Dark
    Light
  • PDF

Article summary

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.

Important

It’s extremely important to correctly follow the steps for configuring the Oracle database so that it functions correctly as a Database Proxy. Access documents from Database Proxy for Oracle - Setup guide to carry out the necessary steps.

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:
chcp 65001 

set Path=C:\Program Files\Common Files\Oracle\Java\javapath;C:\windows\system32;C:\windows;C:\windows\System32\Wbem;C:\windows\System32\WindowsPowerShell\v1.0\;C:\windows\System32\OpenSSH\;C:\Program Files\PuTTY\;C:\Program Files (x86)\Yarn\bin\;C:\Program Files\nodejs\;C:\Program Files\Amazon\AWSCLIV2\;C:\Program Files\Meld\;C:\Users\user1\AppData\Local\Microsoft\WindowsApps;C:\Users\user1\AppData\Local\Programs\Microsoft VS Code\bin;C:\Users\user1\AppData\Local\Programs\Git\cmd;C:\Users\user1\AppData\Local\Google\Cloud SDK\google-cloud-sdk\bin;C:\Users\user1\Documents\instantclient_21_10 set TNS_ADMIN=C:\Users\user1\Documents\dbproxy\ora-files 

dbeaver
  1. Save this file as start-dbeaver.bat

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

  3. 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.

  4. Click Ok.

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


Next:

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

Do you still have questions? Reach out to the senhasegura Community.


Was this article helpful?