How to start a Database Proxy Oracle session with SQL Developer on Windows

In this document, you’ll find a step-by-step guide on how to use the SQL Developer manager on the Windows operating system in a Database Proxy session.

Requirements

• Download version 21.8 of Instant Client
• Download the latest version of Oracle sqlcl
• Download the latest version of SQL Developer
• Install on the client the package: instantclient-basic

Start a session with SQL Developer application

After downloading the packages, extract them both to the same folder.

The table shows the strings presented on the file and their definitions:

Create the following .bat file in the SQL Developer installation root folder to initialize:

chcp 65001
PATH=<instantclient_path>
SET TNS_ADMIN=<.ora_files_path>
sqldeveloper

After running the .bat it’s necessary to configure the connection:

1. Open the application SQLDeveloper.
2. On the home screen, in the upper-left corner, click the plus sign, New connection.
3. In the pop-up window that opens, Select Database Connection, fill in the information:
   1. Name: Add a name for the connection.
   2. Database Type: Oracle.
   3. On the User Information tab, on the Authentication Type field select the SO option.
   4. On the Connection Type field, select the Custom JDBC option.
4. On the Details tab, fill in the Customize JDBC URL field with the following information.
   1. jdbc:oracle:oci:/@<identifier>
      Info

      Replace with the identifier entered in the tnsnames.ora file.

5. Click Test.
6. After the test, the message will appear in the bottom left corner Status: Successful.
7. Click Connect.

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

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