Create an SAP Replication Server connection to Oracle using
ExpressConnect for Oracle (ECO).
ECO requires only the tnsnames.ora file to establish location transparency, unlike ECDA for
Oracle, which also requires an interfaces file to set up connections between Oracle and
SAP Replication Server.
- Copy the tnsnames.ora file used by ECDA for Oracle to the
RS_installation_directory\REP-15_5\connector\oraoci\network\admin
directory.
- Use the value previously given to the connect_string configuration parameter of ECDA for Oracle as the
data_server in the SAP Replication
Server create connection command. See
create connection in the SAP Replication Server Reference Manual.
Note: The connect_string
configuration parameter is same as <tnsnames_alias> in the tnsnames.ora file obtained from the ECDA for Oracle
installation.