- 1 minute to read
- Print
- DarkLight
- PDF
How to start a Database Proxy Oracle session with DBeaver on Windows
- 1 minute to read
- Print
- DarkLight
- PDF
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.
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
- Open the DBeaver app.
- On the main screen, in the left top corner, click on the icon represented by the plug and the plus sign.
- On the pop-up window that opens, Connect to a database, select Oracle.
- Click Next.
- Click Driver Settings.
- At Libraries tab.
- replace the default library for the ones acquired at Instant Client.
- Click OK.
- At DBeaver folder, create a file named start-dbeaver.bat to declare the variables and open the DBeaver.
- 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
Save this file as start-dbeaver.bat
With this file, execute a custom connection at the DBeaver app.
On Connection settings > Principal > Custom, fill in the information on the fields:
- JDBC URL Template:
jdbc:oracle:oci/@<ORACLEDB_HOSTNAME>
- 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.
- JDBC URL Template:
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.