cancel
Showing results for 
Search instead for 
Did you mean: 

Problem Setting Up HANA System Replication

Former Member
0 Kudos

I am trying to set up HANA system replication and I have successfully configured the primary node, but am getting the following error when entering the command to enable replication on the secondary system. 

primary node = hananode01

secondary node = hananode02

Error is as follows:

hnode02:ha2adm> hdbnsutil -sr_register --name=secondary --remoteHost=hananode01 --remoteInstance=00 --mode=sync

adding site ...

checking for inactive nameserver ...

nameserver hananode02:30001 not responding.

collecting information ...

sending registration request to primary site host hananode01:30001

unable to contact primary site host hananode01:30001

failed. trace file nameserver_hananode02.00000.000.trc may contain more error details.

No ports are blocked between the servers and hostname resolution is fine.  Anyone have any thoughts?

Accepted Solutions (0)

Answers (6)

Answers (6)

0 Kudos

Hi,

I made it down and i tried to register using hdbnsutil -sr_register

vadbjaj:HDB:jajadm /usr/sap/***/HDB00 10> hdbnsutil -sr_register --remoteHost=*********--remoteInstance=** --mode=syncmem --name=*** --force_full_replica

adding site ...

checking for inactive nameserver ...

nameserver vadbjaj:30001 not responding.

collecting information ...

error: only system replication chains are allowed with an aditional async secondary site: [primary] <------- [secondary] <---async--- [additional secondary]

failed. trace file nameserver_vadbjaj.00000.000.trc may contain more error details.

still we are facing

[20343]{-1}[-1/-1] 2015-02-23 12:42:57.937261 i Basis TraceStream.cpp(00396) : ==== Starting hdbnsutil, version 1.00.82.00.394270 (NewDB100_REL), build linuxx86_64 not set 2014-08-17 18:34:26 ld7272.wdf.sap.corp gcc (SAP release 20140516, based on SUSE gcc47-4.7.2_20130108-0.15.45) 4.7.2 20130108 [gcc-4_7-branch revision 195014]

[20343]{-1}[-1/-1] 2015-02-23 12:42:57.937832 i Basis TraceStream.cpp(00401) : MaxOpenFiles: 1048576

[20343]{-1}[-1/-1] 2015-02-23 12:42:57.937868 i Memory MallocProxy.cpp(01181) : Installed malloc hooks

[20343]{-1}[-1/-1] 2015-02-23 12:42:57.937870 i Basis Timer.cpp(00629) : Using RDTSC for HR timer

[20343]{-1}[-1/-1] 2015-02-23 12:42:57.937872 i Memory AllocatorImpl.cpp(01219) : Allocators activated

[20343]{-1}[-1/-1] 2015-02-23 12:42:57.937873 i Memory AllocatorImpl.cpp(01235) : Using big block segment size 268435456

[20343]{-1}[-1/-1] 2015-02-23 12:42:57.937875 e Configuration    ConfigStoreManager.cpp(00693) : Configuration directory does not exist.

[20343]{-1}[-1/-1] 2015-02-23 12:42:57.937876 e Configuration    ConfigStoreManager.cpp(00693) : Configuration directory does not exist.

[20343]{-1}[-1/-1] 2015-02-23 12:42:57.937877 i Basis ProcessorInfo.cpp(00746) : Using GDT segment limit to determine current CPU ID

[20343]{-1}[-1/-1] 2015-02-23 12:42:57.937878 w Environment      Environment.cpp(00286) : Changing environment set IMSLERRPATH=/usr/sap/JAJ/HDB00/exe//

[20343]{-1}[-1/-1] 2015-02-23 12:42:57.937879 w Environment      Environment.cpp(00286) : Changing environment set IMSLSERRPATH=/usr/sap/JAJ/HDB00/exe//

[20343]{-1}[-1/-1] 2015-02-23 12:42:57.937881 w Environment      Environment.cpp(00286) : Changing environment set SSL_WITH_OPENSSL=0

0 Kudos

hi ,

i am getting below error while configuring the DR setup

vadbjaj:/usr/sap/JAJ/SYS/global/hdb/custom/config> hdbnsutil -sr_register --remoteHost=vsa323634.ash.od.sap.biz --remoteInstance=00 --mode=syncmem --name=vadbjaj

adding site ...

checking for inactive nameserver ...

error: system must be shut down before it can be registered as secondary site

failed. trace file nameserver_vadbjaj.00000.000.trc may contain more error details.

vadbjaj:/usr/sap/JAJ/SYS/global/hdb/custom/config>

y           AllocatorImpl.cpp(01235) : Using big block segment size 268435456

[6423]{-1}[-1/-1] 2015-02-21 23:39:45.880071 e Configuration    ConfigStoreManager.cpp(00693) : Configuration directory does not exist.

[6423]{-1}[-1/-1] 2015-02-21 23:39:45.880073 e Configuration    ConfigStoreManager.cpp(00693) : Configuration directory does not exist.

[6423]{-1}[-1/-1] 2015-02-21 23:39:45.880074 i Basis            ProcessorInfo.cpp(00746) : Using GDT segment limit to determine current CPU ID

[6423]{-1}[-1/-1] 2015-02-21 23:39:45.880075 w Environment      Environment.cpp(00286) : Changing environment set IMSLERRPATH=/usr/sap/JAJ/HDB00/exe//

[6423]{-1}[-1/-1] 2015-02-21 23:39:45.880076 w Environment      Environment.cpp(00286) : Changing environment set IMSLSERRPATH=/usr/sap/JAJ/HDB00/exe//

[6423]{-1}[-1/-1] 2015-02-21 23:39:45.880078 w Environment      Environment.cpp(00286) : Changing environment set SSL_WITH_OPENSSL=0

please help me to solve this issue.

Thanks

srini

Former Member
0 Kudos

Hi Srinivas,

Please shut down the seconday site and execute the hdnsutil -sr_register (your command) in seconday site

Regards,

Pavan Gunda

Former Member
0 Kudos

I figured out the issue.  So for anyone who is interested, by default in the global.ini file under the "communication" section the parameter "listeninterface" was set to .local.  According to the administration guide, this parameter setting does the following:

  

The .global keyword (default) lets the process bind to all interfaces. The .local keyword opens the communication ports for internal usage on the local interfaces (which are 127.0.0.1 in IPv4 notation). This configuration is only an option for single host installations as the server is not reachable from the outside. These two options do not require a valid internal_hostname_resolution section.

So, all I had to do was change this parameter value to .global and everything started working. 

Thanks a lot for everyone's input!

Former Member
0 Kudos

I am looking into the firewall now, but pretty sure nothing is being blocked. 

Does anyone know if it is normal for the hdb service ports to be listening on the localhost/loopback IP rather than * or hostname?  Not sure if this could be the reason that I can only connect to the port using localhost.

See output below for what I'm talking about:

nicholas_chang
Active Contributor
0 Kudos

Hi,

Ensure below pre-requisite are met:

  • Primary and secondary both installed, up and running.
  • Data link/connectivity established between primary and secondary
  • Different host name
  • Index server N:N
  • Same software version or Secondary newer
  • Same SID, system number
  • .ini file configuration must be identical to both systems. Any changes made on one system need to replicate to other host
  • Instance number + 1 need to free up
  • Log_mode set to normal for Primary and Secondary
  • Ensure Primary and Secondary has at least 1 full backup
Former Member
0 Kudos

Sunny,

I have performed test connect to port 30001 from secondary using netcat and get a connection refused. 

Nicholas,

I have performed most of those prerequisite checks.  I'm unsure of what you mean by the following:

  • Data link/connectivity established between primary and secondary
  • Index server N:N
  • Instance number + 1 need to free up  (I assume you're just talking about the 30001 port?)
sunny_pahuja2
Active Contributor
0 Kudos

It means you are not able to do telnet. Could you please check on your network side why you are not able to telnet ? It might be the problem that you are not able to register your secondary server to primary.

Thanks,

Sunny

Former Member
0 Kudos

Thanks, did some more testing with netcat.

For some reason I can only netcat to that port from the primary host and using "localhost" in the command.  If I use the actual hostname or IP address I get connection refused even when trying to connect to the port locally.  I assume this is not correct, but not sure what to do to fix it.

sunny_pahuja2
Active Contributor
0 Kudos

Are you able to ping the servers from each host ? You have written earlier that no ports are blocked and hostname resolution is fine. How did you check that earlier?

Thanks,

Sunny

Former Member
0 Kudos

Hostname resolution via ping is fine between all servers.

sunny_pahuja2
Active Contributor
0 Kudos

Could you please check firewall if that is blocking port?

Thanks,

Sunny

sunny_pahuja2
Active Contributor
0 Kudos

Could you please paste error log file- nameserver_hananode02.00000.000.trc ?

Thanks,

Sunny

Former Member
0 Kudos

The following log entries appear after running the register command above.  No obvious errors that I could see.

[34070]{-1}[-1/-1] 2013-10-01 17:49:49.505398 i Basis            TraceStream.cpp(00383) :
==== Starting hdbnsutil, version 1.00.60.379371 (NewDB100_REL), build linuxx86_64 not set
2013-06-27 17:39:32 ld7270.wdf.sap.corp cc (SAP release 20130125, based on SUSE
gcc43-4.3.4_20091019-0.22.17.5096.1.PTF.799300) 4.3.4 [gcc-4_3-branch revision 152973]

[34070]{-1}[-1/-1] 2013-10-01 17:49:49.505441 i Basis            TraceStream.cpp(00385) :
MaxOpenFiles: 1048576

[34070]{-1}[-1/-1] 2013-10-01 17:49:49.505451 i Memory           MallocProxy.cpp(01222) :
Installed malloc hooks

[34070]{-1}[-1/-1] 2013-10-01 17:49:49.505454 i Basis            ProcessorInfo.cpp(00392) :
Using GDT segment limit to determine current CPU ID

[34070]{-1}[-1/-1] 2013-10-01 17:49:49.505455 i Basis            Timer.cpp(00567) :
Using RDTSC for HR timer

[34070]{-1}[-1/-1] 2013-10-01 17:49:49.505456 i Memory           AllocatorImpl.cpp(00835) :
Allocators activated

[34070]{-1}[-1/-1] 2013-10-01 17:49:49.505457 i Memory           AllocatorImpl.cpp(00851) :
Using big block segment size 134217728

[34070]{-1}[-1/-1] 2013-10-01 17:49:49.505458 w Environment      Environment.cpp(00284) :
Changing environment set IMSLERRPATH=/usr/sap/HA2/HDB00/exe//

[34070]{-1}[-1/-1] 2013-10-01 17:49:49.505459 w Environment      Environment.cpp(00284) :
Changing environment set IMSLSERRPATH=/usr/sap/HA2/HDB00/exe//

[34070]{-1}[-1/-1] 2013-10-01 17:49:49.505460 w Environment      Environment.cpp(00284) :
Changing environment set NODNSSAPTRANSHOST=1

[34070]{-1}[-1/-1] 2013-10-01 17:49:49.505461 w Environment      Environment.cpp(00263) :
Changing environment set SAP_DIR_GLOBAL=/usr/sap/HA2/SYS/global

[34070]{-1}[-1/-1] 2013-10-01 17:49:49.505466 w Environment      Environment.cpp(00284) :
Changing environment set SSL_WITH_OPENSSL=0hnode02:HDB:ha2adm /usr/sap

sunny_pahuja2
Active Contributor
0 Kudos

Are you able to do telnet on port 30001 from secondary to primary?

Also, have you enabled system replication on primary prior to registering secondary instance?

Thanks,

Sunny

Thanks,

Sunny