4.6.2.3.1 Non-TCPS

To configure the TNS entries in the tnsnames.ora file for Non-TCPS, refer to the following table:

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

Description	Example Value
Ensure that an entry (with SID or SERVICE NAME) is added in the tnsnames.ora file on the STSA server.	<SID_NAME> = DESCRIPTION =(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = <HOST_NAME>.in.oracle.com)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = <SID_NAME>)))<ATOMIC_SCHEMA_NAME> = (DESCRIPTION =(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = <HOST_NAME>.in.oracle.com)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = <SID_NAME>)))

<SID NAME> =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = <HOST NAME>)(PORT = <PORT NUMBER>))

) (CONNECT_DATA =

(SERVICE_NAME = <SID NAME>)

)

)

<ATOMICSCHEMANAME> =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = <HOST NAME>)(PORT = <PORT NUMBER>))

)

(CONNECT_DATA =

(SERVICE_NAME = <SID NAME>)

)

)