2438849 - Can you add a 2nd address line to tnsnames.ora for ECO when replicating to Oracle - SRS

Symptom

Can you add a 2nd address line in the tnsnames.ora file for the Express Connect for Oracle (ECO) in SAP Replication Server (SRS)?

i.e:

Oracle_instance_name=
(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = hostname1)(PORT = 1521))
    (ADDRESS=(PROTOCOL=TCP)(HOST=hostname2)(PORT=1521))
    (CONNECT_DATA =
      (FAILOVER_MODE=(TYPE=select)(METHOD=basic)(RETRIES=20)(DELAY=5))
      (SERVER = DEDICATED)
      (SERVICE_NAME = RXP.PROD.NODE)
    )
)

Environment

SAP Replication Server (SRS) 15.7.1
SAP Replication Server Option (RSO) for Oracle 15.7.1

Product

SAP Replication Server 15.7 ; SAP Sybase Replication Server 15.7, option for Oracle

Keywords

RepServer, ECO, HA, tnsnames , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , BC-SYB-REP-RSO , Rep Server Options (RSO) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.