6.6.3 TNS Entries in the TNSNAMES.ORA File

The section includes information about the TNS entries in the TNSNAMES.ORA file.

Table 6-6 TNS entries in the TNSNAMES.ORA file

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>)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = <SID_NAME>)))<ATOMIC_SCHEMA_NAME> = (DESCRIPTION =(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = <HOST_NAME>)(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>)

) )

Note:

The ATOMIC SCHEMA NAME must be the same as defined in the OFS_LRS_SCHEMA_IN.xml file.