TNS entries in the TNSNAMES.ORA file for Non-TCPS and TCPS

Configure the TNS entries in the TNSNAMES.ORA file for Non-TCPS and TCPS.

TNS entries in the TNSNAMES.ORA file for Non-TCPS mode

• Add an entry (with SID/ SERVICE NAME) is added in the tnsnames.ora file on the OFSAA server.

  <SID NAME> = 
  (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = <HOST_NAME/IP ADDRESS>)(PORT = <PORT_NUMBER>))
  )
  (CONNECT_DATA =
    (SERVICE_NAME = <SID_NAME>))
  )
  <ATOMICSCHEMANAME> =
  (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = <HOST_NAME/IP ADDRESS>)(PORT = <PORT_NUMBER>))
  )
  (CONNECT_DATA = 
    (SERVICE_NAME = <SID NAME>)
  )) 
       

  Example

  <SID_NAME> =
  (DESCRIPTION = 
    (ADDRESS_LIST =
    (ADDRESS =
    (PROTOCOL = TCP)(HOST = <HOST_NAME/IP ADDRESS>.in.oracle.com)(PORT = 1521))
  )
  (CONNECT_DATA = 
    (SERVICE_NAME = <SID_NAME>))
  )
  <ATOMIC_SCHEMA_NAME> = 
  (DESCRIPTION =
    (ADDRESS_LIST = 
    (ADDRESS = (PROTOCOL = TCP)(HOST = <HOST_NAME/IP ADDRESS>.in.oracle.com)(PORT = 1521))
  )
  (CONNECT_DATA = 
    (SERVICE_NAME = <SID_NAME>)
  ))

  Note:

  The ATOMIC SCHEMA NAME must be the same as defined in the OFS_<App Pack>_SCHEMA_IN.xml file, which also includes prefix without underscore. For example, DEVOFSAAATM.

TNS entries in the TNSNAMES.ORA file for TCPS mode

• Add an entry (with SID/ SERVICE NAME) is added in the tnsnames.ora file on the OFSAA server.

   <SID_NAME> =
  (DESCRIPTION = 
    (ADDRESS_LIST = 
    (ADDRESS = (PROTOCOL = TCPS)(HOST = <HOST_NAME/IP ADDRESS>)(PORT = <PORT_NUMBER>))
  )
  (CONNECT_DATA =
    (SERVICE_NAME = <SID NAME>)
  (security=(ssl_server_cert_dn=CN=<HOST_NAME>))
  )) 
  <ATOMICSCHEMANAME> =
  (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCPS)(HOST = <HOST NAME/IP ADDRESS>)(PORT = <PORT_NUMBER>))
  )
  (CONNECT_DATA = 
    (SERVICE_NAME = <SID NAME>)
    (security=(ssl_server_cert_dn=CN=<HOST_NAME>))
  )) 
  

  Example

   <SID_NAME> =
  (DESCRIPTION =
  (ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCPS)(HOST = .in.oracle.com)(PORT = 1521))
  )
  (CONNECT_DATA =
  (SERVICE_NAME = <SID NAME>)
  (security=(ssl_server_cert_dn=CN=<HOST_NAME>))  )  ) 
  <ATOMICSCHEMANAME> =
  (DESCRIPTION =
  (ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCPS)(HOST = <HOST_NAME/IP ADDRESS>.in.oracle.com)(PORT = 1521))
  )
  (CONNECT_DATA = 
  (SERVICE_NAME = <SID NAME>)
  (security=(ssl_server_cert_dn=CN=<HOST_NAME>)) )  ) 
  

  Note:

  The ATOMIC SCHEMA NAME must be the same as defined in the OFS_<App Pack>_SCHEMA_IN.xml file, which also includes prefix without underscore. For example, DEVOFSAAATM.
• Add an entry (with WALLET_HOME and wallet parameters) in the sqlnet.ora file on the OFSAA server must be same as Oracle database server running with TCPS.

  <SID NAME> =
   (DESCRIPTION =
   (ADDRESS_LIST =
   (ADDRESS = (PROTOCOL = TCPS)(HOST = <HOST NAME/IP ADDRESS>)(PORT = <PORT
  NUMBER>))
   )
   (CONNECT_DATA =
   (SERVICE_NAME = <SID NAME>)
  (security=(ssl_server_cert_dn=CN=<HOST NAME>))
   )
   )
  <ATOMICSCHEMANAME> =
   (DESCRIPTION =
   (ADDRESS_LIST =
   (ADDRESS = (PROTOCOL = TCPS)(HOST = <HOST NAME>)(PORT = <PORT
  NUMBER>))
   )
   (CONNECT_DATA =
   (SERVICE_NAME = <SID NAME>)
  (security=(ssl_server_cert_dn=CN=<HOST NAME>)) )
   )

  Example

  NAMES.DIRECTORY_PATH=(TNSNAMES, EZCONNECT)
  WALLET_LOCATION = 
  (SOURCE = (METHOD = FILE) (METHOD_DATA = (DIRECTORY = )))
  SQLNET.WALLET_OVERRIDE = TRUE 
  SSL_CLIENT_AUTHENTICATION = FALSE
  SQLNET.AUTHENTICATION_SERVICES = (TCPS,NTS,BEQ) 
  SSL_CIPHER_SUITES = (SSL_RSA_WITH_AES_256_CBC_SHA, SSL_RSA_WITH_3DES_EDE_CBC_SHA)

Note:

The ATOMIC SCHEMA NAME must be the same as defined in the OFS_<App Pack>_SCHEMA_IN.xml file, which also includes prefix without underscore. For example, DEVOFSAAATM.