How to configure IDEs for the end user to connect to Oracle DB

In this document, you’ll find a step-by-step guide on how to configure the IDEs.

It’ll take seven steps to configure the Oracle database so that it’s accessible via Database proxy in senhasegura, this document is the seventh and last step.

Requirements

• Oracle DB Server configured the minimum version is 19.0.0.0.0
• Server with ORAPKI installed to create Wallets.
• Connectivity of the user's workstation with senhasegura on ports 1521 and 2484.
• Certificate authority (CA) for signing Oracle DB certificates and the database credential.
• Database client installed.
  • Dbeaver, minimum version: 23.1.0
  • SQLPlus, minimum version: 21.0.0.0.0
  • SQL Developer, minimum version: 23.1.0.097
• Don’t have filters enabled for the certificate.
• Download the latest version of Instant Client

Configure the IDE

To access Oracle DB using the Database Proxy, it’s possible to use IDEs approved by senhasegura.

Some specific configurations are required on the user's workstation for this access to be possible.

1. Unzip the Instant Client files into a directory of the user's choice. For example: C:\Users\user1\Documents\instantclient_21_13.
2. Create a directory called oracle_files, in which the configuration files used for the connection via DB Proxy will be centralized. For example: C:\Users\user1\Documents\oracle_files.
3. Create within the directory oracle_files the tnsnames.orafile, with the content as shown below.

Replace the strings presented in this table with the corresponding values:

<IDENTIFIER>=
    (DESCRIPTION=
            (ADDRESS=
                (PROTOCOL=TCPS)
                (HOST=<IP_SENHASEGURA>)
                (PORT=2484)
     )
    (CONNECT_DATA=
            (SENHASEGURA=
                (USERNAME=<USERNAME>)
                (CREDENTIAL=<USERNAME_CREDENTIAL>)
                (DEVICE=<IP_ORACLE>)
                (PORT=2484)
                (TOTP=0000))
            (SERVER=DEDICATED)
            (SERVICE_NAME=<SERVICE_NAME>)
      )
)

Create within the directory oracle_files the sqlnet.ora file, with the following content:

WALLET_LOCATION = (SOURCE = (METHOD = FILE) (METHOD_DATA = (DIRECTORY = <USER_WALLET_DIR>)))
SQLNET.AUTHENTICATION_SERVICES = (TCPS)
SSL_CLIENT_AUTHENTICATION = TRUE

1. Configure the environment variables to point to the Instant Client and the tnsnames.ora and sqlnet.ora files.
   1. Add to $PATH variable the path to the Instant Client directory: For example: C:\Users\user1\Documents\instantclient_21_13
   2. Create a new$TNS_ADMIN variable, pointing to the directory where the tnsnames.ora is located. For example: C:\Users\user1\Documents\oracle_files

Finishing the seventh step of configuring Oracle to be used via Database Proxy, the configuration is ready and the end user can now access the sessions.

Access the documents below to learn how to start the sessions:
How to start an Oracle session with DBeaver on Linux
How to start an Oracle session with DBeaver on Windows

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