Error in connection from Agent to replication server

[Former Member]

Hi!

I'm setting up my first SAP Replication Server scenario, with the following landscape:

Server 1 (source): Windows Server running an 32 bit Oracle Database 11g R2. Here I installed Rep. Agent (win32) version 15.7.1 SP209.

Server 2: Windows Server running Replication Server version 15.7.1 SP301 (64bit). I choose to install the Sample Server, SAMPLE_RS as part of the installation. The server seems to be running well and is accessible with the users created (e.g. SAMPLE_RS_ra & sa) using isql. The ports for both ERSSD and server are open in FW and netstat -an shows them listening.

Server 3 (target): HANA version 97. Connection has been made and looks fine.

Currently I'm configuring my Agent instance, and my problem shows when I validate this configuration using ra_admin.bat tool (parameter: -vr):

nov 13, 2015 10:57:34 AM com.sybase.ra.RepAgentAdmin initLogging

TRACE: SAP Replication Agent for Unix & Windows/15.7.1 SP209/P/generic/JDK 7.0/rax1571sp209/62090.209/VM: SAP AG 1.7.0_25/OPT/Mon Aug 31 21:10:49 MDT 2015

nov 13, 2015 10:57:34 AM com.sybase.ra.RepAgentAdmin initLogging

TRACE: ra_admin -vr ora1.rs

nov 13, 2015 10:57:37 AM com.sybase.ra.admin.oracle.RAOResponseFileProperties verifyProperties

INFORMATION: Completed first pass of verification for resource file <ora1.rs>.

nov 13, 2015 10:57:39 AM com.sybase.ra.admin.RsRssdVerification verifyRS

TRACE: Testing connection to RepServer...

nov 13, 2015 10:57:39 AM com.sybase.ra.admin.JDBCConnectionFactory testConnection

ERROR: Failed to connect to <jdbc:sybase:Tds:10.151.20.54:11751> as <SAMPLE_RS_ra> because: JZ00L: Login failed.  Examine the SQLWarnings chained to this exception for the reason(s).

I hope somebode know what this is caused by?? (The SAMPLE_RS seem to use charset cd850, and I have tried to put both iso_1, cp850 and utf8 into the rs_charset parameter in the Rep Agent conf file - with the same error as shown above).

Thanks, br Mads

[Former Member · Accepted solution]

I found the solution myself:

The interfaces file entry for Replication Server & RSSD uses “localhost” as the name of the machine where they reside. If the primary DB isn't on the same machine as the Rep. Server, the interfaces file entry must be changed to use either the machine name or the IP address of the machine.