HANA replication

[#1]

Hi

I am getting connection refused error when I try to register secondary system in system replication

[29438]{-1}[-1/-1] 2017-04-21 23:29:43.299670 e sr_nameserver TopologyUtil.cpp(02172) : unable to contact primary site; to linux-eadz:30201; original error: connection refused,location=linux-eadz:30201; [29550]{-1}[-1/-1] 2017-04-21 23:30:09.641171 e TNS TNSInfo.cpp(00465) : sendRequest getvalue to linux-eadz:30201 failed with NetException. data=(S)path=/datacenters/isSource/0| [29550]{-1}[-1/-1] 2017-04-21 23:30:09.646775 e TNS TNSInfo.cpp(00465) : sendRequest querytree to linux-eadz:30201 failed with NetException. data=(I)mode=0|(N)query=/datacenters/mappings/0/*| [29943]{-1}[-1/-1] 2017-04-21 23:32:38.310085 e sr_nameserver TNSClient.cpp(08937) : remoteHost does not match with any host of the source site. all hosts of source and target site must be able to resolve all hostnames of both sites correctly [29943]{-1}[-1/-1] 2017-04-21 23:32:38.310140 e sr_nameserver TopologyUtil.cpp(02172) : remoteHost does not match with any host of the source site. all hosts of source and target site must be able to resolve all hostnames of both sites correctly; [30237]{-1}[-1/-1] 2017-04-21 23:34:58.645454 e TNS TNSInfo.cpp(00465) : sendRequest dr_gethdbversion to linux-eadz:30302 failed with NetException. data= [30237]{-1}[-1/-1] 2017-04-21 23:34:58.645826 e TNS TNSInfo.cpp(00465) : sendRequest dr_registerdatacenter to linux-eadz:30302 failed with NetException. data=(S)hdbversion=1.00.121.00.1466466057|instance=02|instancename=DS4|mode=syncmem|name=secondry|opmode=logreplay...|...|(B)...|(N)...|(SV)...| [30237]{-1}[-1/-1] 2017-04-21 23:34:58.646195 e TNS TNSInfo.cpp(00465) : sendRequest dr_registerdatacenter to linux-eadz:30201 failed with NetException. data=(S)hdbversion=1.00.121.00.1466466057|instance=02|instancename=DS4|mode=syncmem|name=secondry|opmode=logreplay...|...|(B)...|(N)...|(SV)...| [30237]{-1}[-1/-1] 2017-04-21 23:34:58.646226 e sr_nameserver TNSClient.cpp(08913) : unable to contact primary site; to linux-eadz:30201; original error: connection refused,location=linux-eadz:30201 [30237]{-1}[-1/-1] 2017-04-21 23:34:58.646257 e sr_nameserver TopologyUtil.cpp(02172) : unable to contact primary site; to linux-eadz:30201; original error: connection refused,location=linux-eadz:30201; [31003]{-1}[-1/-1] 2017-04-21 23:42:21.918772 e TNS TNSInfo.cpp(00465) : sendRequest getvalue to linux-eadz:30201 failed with NetException. data=(S)path=/datacenters/isSource/0| [31003]{-1}[-1/-1] 2017-04-21 23:42:21.924290 e TNS TNSInfo.cpp(00465) : sendRequest querytree to linux-eadz:30201 failed with NetException. data=(I)mode=0|(N)query=/datacenters/mappings/0/*| [31451]{-1}[-1/-1] 2017-04-21 23:45:39.764799 e TNS TNSInfo.cpp(00465) : sendRequest getvalue to linux-eadz:30201 failed with NetException. data=(S)path=/datacenters/isSource/0| [31451]{-1}[-1/-1] 2017-04-21 23:45:39.770459 e TNS TNSInfo.cpp(00465) : sendRequest querytree to linux-eadz:30201 failed with NetException. data=(I)mode=0|(N)query=/datacenters/mappings/0/*| [31677]{-1}[-1/-1] 2017-04-21 23:46:28.379270 e TNS TNSInfo.cpp(00465) : sendRequest dr_gethdbversion to linux-eadz:30302 failed with NetException. data= [31677]{-1}[-1/-1] 2017-04-21 23:46:28.379654 e TNS TNSInfo.cpp(00465) : sendRequest dr_registerdatacenter to linux-eadz:30302 failed with NetException. data=(S)hdbversion=1.00.121.00.1466466057|instance=02|instancename=DS4|mode=syncmem|name=Secondry|opmode=logreplay...|...|(B)...|(N)...|(SV)...| [31677]{-1}[-1/-1] 2017-04-21 23:46:28.379965 e TNS TNSInfo.cpp(00465) : sendRequest dr_registerdatacenter to linux-eadz:30201 failed with NetException. data=(S)hdbversion=1.00.121.00.1466466057|instance=02|instancename=DS4|mode=syncmem|name=Secondry|opmode=logreplay...|...|(B)...|(N)...|(SV)...| [31677]{-1}[-1/-1] 2017-04-21 23:46:28.379997 e sr_nameserver TNSClient.cpp(08913) : unable to contact primary site; to linux-eadz:30201; original error: connection refused,location=linux-eadz:30201 [31677]{-1}[-1/-1] 2017-04-21 23:46:28.380030 e sr_nameserver TopologyUtil.cpp(02172) : unable to contact primary site; to linux-eadz:30201; original error: connection refused,location=linux-eadz:30201; [31760]{-1}[-1/-1] 2017-04-21 23:46:59.759344 e TNS TNSInfo.cpp(00465) : sendRequest dr_gethdbversion to linux-eadz:30302 failed with NetException. data= [31760]{-1}[-1/-1] 2017-04-21 23:46:59.759705 e TNS TNSInfo.cpp(00465) : sendRequest dr_registerdatacenter to linux-eadz:30302 failed with NetException. data=(S)hdbversion=1.00.121.00.1466466057|instance=02|instancename=DS4|mode=syncmem|name=Secondry|opmode=logreplay...|...|(B)...|(N)...|(SV)...| [31760]{-1}[-1/-1] 2017-04-21 23:46:59.760017 e TNS TNSInfo.cpp(00465) : sendRequest dr_registerdatacenter to linux-eadz:30201 failed with NetException. data=(S)hdbversion=1.00.121.00.1466466057|instance=02|instancename=DS4|mode=syncmem|name=Secondry|opmode=logreplay...|...|(B)...|(N)...|(SV)...| [31760]{-1}[-1/-1] 2017-04-21 23:46:59.760049 e sr_nameserver TNSClient.cpp(08913) : unable to contact primary site; to linux-eadz:30201; original error: connection refused,location=linux-eadz:30201 [31760]{-1}[-1/-1] 2017-04-21 23:46:59.760081 e sr_nameserver TopologyUtil.cpp(02172) : unable to contact primary site; to linux-eadz:30201; original error: connection refused,location=linux-eadz:30201; [9513]{-1}[-1/-1] 2017-04-22 11:19:13.784214 e TNS TNSInfo.cpp(00465) : sendRequest getvalue to linux-eadz:30201 failed with NetException. data=(S)path=/datacenters/isSource/0| [9513]{-1}[-1/-1] 2017-04-22 11:19:13.789710 e TNS TNSInfo.cpp(00465) : sendRequest querytree to linux-eadz:30201 failed with NetException. data=(I)mode=0|(N)query=/datacenters/mappings/0/*| [9732]{-1}[-1/-1] 2017-04-22 11:19:46.590138 e TNS TNSInfo.cpp(00465) : sendRequest dr_gethdbversion to linux-eadz:30302 failed with NetException. data= [9732]{-1}[-1/-1] 2017-04-22 11:19:46.590552 e TNS TNSInfo.cpp(00465) : sendRequest dr_registerdatacenter to linux-eadz:30302 failed with NetException. data=(S)hdbversion=1.00.121.00.1466466057|instance=02|instancename=DS4|mode=syncmem|name=Secondry|opmode=logreplay...|...|(B)...|(N)...|(SV)...| [9732]{-1}[-1/-1] 2017-04-22 11:19:46.590884 e TNS TNSInfo.cpp(00465) : sendRequest dr_registerdatacenter to linux-eadz:30201 failed with NetException. data=(S)hdbversion=1.00.121.00.1466466057|instance=02|instancename=DS4|mode=syncmem|name=Secondry|opmode=logreplay...|...|(B)...|(N)...|(SV)...| [9732]{-1}[-1/-1] 2017-04-22 11:19:46.590917 e sr_nameserver TNSClient.cpp(08913) : unable to contact primary site; to linux-eadz:30201; original error: connection refused,location=linux-eadz:30201 [9732]{-1}[-1/-1] 2017-04-22 11:19:46.590951 e sr_nameserver TopologyUtil.cpp(02172) : unable to contact primary site; to linux-eadz:30201; original error: connection refused,location=linux-eadz:30201; [9811]{-1}[-1/-1] 2017-04-22 11:19:55.426898 e TNS TNSInfo.cpp(00465) : sendRequest dr_gethdbversion to linux-eadz:30302 failed with NetException. data= [9811]{-1}[-1/-1] 2017-04-22 11:19:55.427305 e TNS TNSInfo.cpp(00465) : sendRequest dr_registerdatacenter to linux-eadz:30302 failed with NetException. data=(S)hdbversion=1.00.121.00.1466466057|instance=02|instancename=DS4|mode=syncmem|name=Secondry|opmode=logreplay...|...|(B)...|(N)...|(SV)...| [9811]{-1}[-1/-1] 2017-04-22 11:19:55.427624 e TNS TNSInfo.cpp(00465) : sendRequest dr_registerdatacenter to linux-eadz:30201 failed with NetException. data=(S)hdbversion=1.00.121.00.1466466057|instance=02|instancename=DS4|mode=syncmem|name=Secondry|opmode=logreplay...|...|(B)...|(N)...|(SV)...| [9811]{-1}[-1/-1] 2017-04-22 11:19:55.427657 e sr_nameserver TNSClient.cpp(08913) : unable to contact primary site; to linux-eadz:30201; original error: connection refused,location=linux-eadz:30201 [9811]{-1}[-1/-1] 2017-04-22 11:19:55.427717 e sr_nameserver TopologyUtil.cpp(02172) : unable to contact primary site; to linux-eadz:30201; original error: connection refused,location=linux-eadz:30201;

[former_member240094]

Hello,

The error is due to the fact that hostname is not properly maintained. You will need to Maintain the primary site hostname in HANA Studio exactly in the way it is returned by the select statement against m_topology_tree. The steps to resolve the issue is documented in SAP note 2050830 - Registering a secondary system via HANA Studio fails with error 'remoteHost does not match...

Cheers,

Arun Marria