5.10.2.3.2 TCPS
Table 13: TNS entries in the TNSNAMES.ORA file for TCPS
Description | Example Value |
---|---|
Ensure that 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>.in.oracle.com)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = <SID_NAME>)))<ATOMIC_SCHEMA_NAME> = (DESCRIPTION =(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCPS)(HOST = <HOST_NAME>.in.oracle.com)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = <SID_NAME>)))(security=(ssl_server_cert_dn=CN=<HOST_NAME>)))) |
Ensure that an entry (with WALLET_HOME and wallet parameters) is added in the sqlnet.ora file on the OFSAA server must be same as Oracle database server running with TCPS. |
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)WALLET_LOCATION = (SOURCE = (METHOD = FILE) (METHOD_DATA = (DIRECTORY = <PATH TO WALLET 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) |
<SID NAME> =
(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>))
)
)<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>)) )
)
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.