--- title: "How to start a Database Proxy Oracle session with SQL Developer on Windows" slug: "pam-session-how-to-start-a-database-proxy-oracle-session-with-sql-developer-on-windows" updated: 2026-11-03T14:48:21Z published: 2026-11-03T14:48:21Z canonical: "docs.senhasegura.io/pam-session-how-to-start-a-database-proxy-oracle-session-with-sql-developer-on-windows" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.senhasegura.io/llms.txt > Use this file to discover all available pages before exploring further. # 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. **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](/v4-2/docs/pam-session-oracle-database-configurations) to carry out the necessary steps. ## Requirements - Download version 21.8 of [Instant Client](https://www.oracle.com/br/database/technologies/instant-client/downloads.html) - Download the latest version of [Oracle sqlcl](https://www.oracle.com/br/database/sqldeveloper/technologies/sqlcl/) - Download the latest version of [SQL Developer](https://www.oracle.com/database/sqldeveloper/technologies/download/) - Install on the client the package: instantclient-basic [google](http://google.com) --- ## 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= 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.