Configure the TNSNAMES.ora File - Configure the TNSNAMES.ora File - Perceptive Content - SSL Security with an Oracle Database - Perceptive-Content/SSL-Security-with-an-Oracle-Database/Foundation-24.1/SSL-Security-with-an-Oracle-Database/Set-Up-SSL-Encryption/Configure-Database-Server-ORA-Files-for-SSL/Configure-the-TNSNAMES.ora-File - Foundation 24.1 - Foundation 24.1

SSL Security with an Oracle Database
Platform
Perceptive Content
Product
SSL Security with an Oracle Database
Release
Foundation 24.1
License
ft:lastPublication
2024-04-02T13:38:57.399000
ft:locale
en-US

To configure the TNSNAMES.ora file, complete the following steps.

  1. In the TNSNAMES.ora file, change the protocol from TCP to TCPS and the port number from 1521 to 2484. Also, add the SECURITY parameter SSL_SERVER_CERT_DN and ensure that it matches the entire DN of the database server certificate. The DN can be found in the user certificate of the Oracle database server wallet. 
    INOW6 =   
  (DESCRIPTION =     
    (ADDRESS = (PROTOCOL = TCPS)(HOST = OracleDBServer)(PORT = 2484))     
    (CONNECT_DATA =       
      (SERVER = DEDICATED)       
      (SERVICE_NAME = INOW6)     
    )     
    (SECURITY=       
      (SSL_SERVER_CERT_DN = "CN=<identifier>"))   
)
  2. In a command prompt, enter the following commands to test the SQLNET configuration and make sure you can connect to the INOW6 database.tnsping INOW6 sqlplus inuser/imagenow@INOW6