on 10-01-2013 5:36 PM
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?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Ensure below pre-requisite are met:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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:
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.
Could you please paste error log file- nameserver_hananode02.00000.000.trc ?
Thanks,
Sunny
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.