Non-TCPS

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

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

Description Example Value

Description	Example Value
Ensure that an entry (with SID or SERVICE NAME) is added in the tnsnames.ora file on the OFSAA server. 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>)))`

Ensure that an entry (with SID or SERVICE NAME) is added in the tnsnames.ora file on the OFSAA server.

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>)

)