Configuring the tnsnames.ora and listener.ora Files

Update the <wallet location> in the listener.ora file of the Oracle Database client as shown below:

        WALLET_LOCATION =
           (SOURCE =
             (METHOD = FILE)
             (METHOD_DATA =
               (DIRECTORY = <wallet_location>
             )
           )
SQLNET.AUTHENTICATION_SERVICES = (TCPS,NTS)
        SSL_CLIENT_AUTHENTICATION = FALSE
        SSL_CIPHER_SUITES = (SSL_RSA_WITH_AES_256_CBC_SHA, SSL_RSA_WITH_3DES_EDE_CBC_SHA)

Update the Protocol and Port value in the tnsnames.ora file of the Oracle Database client.

JDEORCL=
      (DESCRIPTION=
        (ADDRESS=
           (PROTOCOL=TCPS)
           (HOST=<DB_server_host_name>)
          (PORT=1522)
         )
        (CONNECT_DATA=
           (SERVER=dedicated)
           (SERVICE_NAME=JDEORCL)
         )
       )