4.4.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 OFSAA 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>)
)
)