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

  • 1 minute(s) read
Prev Next

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.

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 version 21.8 of Instant Client{target=_blank}
  • Download the latest version of Oracle sqlcl{target=_blank}
  • Download the latest version of SQL Developer{target=_blank}
  • 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:

String Value
chcp 65001 Page encoding to UTF-8.
PATH=<instantclient_path> Windows environment variable where you need to include the instantclient path.
SET TNS_ADMIN=<.ora_files_path> Environment variable to indicate the file tnsnames.ora and sqlnet.ora path.
sqldeveloper IDE startup shell.

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 Segura Database Proxy.

Do you still have questions? Reach out to the Segura Community{target=_blank}.