5.10.2.3.1 Non-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 = 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 =
     

Note:

The ATOMIC SCHEMA NAME must be the same as defined in the OFS_<App Pack>_SCHEMA_IN.xml file.