- 1 minute to read
- Print
- DarkLight
- PDF
How to start a Database Proxy Oracle session with SQL Developer on Linux
- 1 minute to read
- Print
- DarkLight
- PDF
In this document, you’ll find a step-by-step guide on how to use the SQL Developer manager on the Linux operating system in a Database Proxy session.
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
- 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.
For access via the Linux operating system, in addition to the steps below, this step must be followed where the path of the Instant Client must be pointed to the PATH
variable, and an environment variable TNS_ADMIN
must be created that points to the .ora
files folder.
- Open the application SQLDeveloper.
- On the home screen, in the upper-left corner, click the plus sign, New connection.
- In the pop-up window that opens, Select Database Connection, fill in the information:
- Name: add a name for the connection.
- Database Type: Oracle.
- On the User Information tab, on the Authentication Type field select the SO option.
- On the Connection Type field, select the Custom JDBC option.
- On the Details tab, fill in the Customize JDBC URL field with the following information.
jdbc:oracle:oci:/@<identifier>
InfoReplace with the identifier entered in the
tnsnames.ora
file.
- Click Test.
- After the test, the message will appear in the bottom left corner Status: Successful.
- 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.