增值通信服务商

hadr主库不能启动

SQL1768N  Unable to start HADR. Reason code = "7".  为启动时的错误提示
db2diag中报错：

2012-09-01-08.40.02.680289+480 I4322G294       LEVEL: Warning
PID    : 4523                TID  : 3086862016  PROC : db2hadrp (SAMPLE) 0
INSTANCE: db2inst1          NODE : 000
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrEduP, probe:20301
MESSAGE : Info: Primary Started.

2012-09-01-08.40.02.680870+480 I4617G342       LEVEL: Warning
PID    : 4523                TID  : 3086862016  PROC : db2hadrp (SAMPLE) 0
INSTANCE: db2inst1          NODE : 000
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrSetTcpWindowSize, probe:32201
MESSAGE : Info: HADR Socket send buffer size, SO_SNDBUF: 16384 bytes

2012-09-01-08.40.02.681016+480 I4960G345       LEVEL: Warning
PID    : 4523                TID  : 3086862016  PROC : db2hadrp (SAMPLE) 0
INSTANCE: db2inst1          NODE : 000
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrSetTcpWindowSize, probe:32251
MESSAGE : Info: HADR Socket receive buffer size, SO_RCVBUF: 87380 bytes

2012-09-01-08.45.03.637704+480 I5306G547       LEVEL: Error
PID    : 4523                TID  : 3086862016  PROC : db2hadrp (SAMPLE) 0
INSTANCE: db2inst1          NODE : 000
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrEduP, probe:20390
MESSAGE : HADR primary did not establish connection with standby within timeout
      and will shut down. BY FORCE option required to start primary without
      standby. Timeout seconds =
DATA #1 : Hexdump, 4 bytes
0x139BAD40 : 2C01 0000                               ,...

2012-09-01-08.45.03.638333+480 I5854G394       LEVEL: Error
PID    : 4523                TID  : 3086862016  PROC : db2hadrp (SAMPLE) 0
INSTANCE: db2inst1          NODE : 000
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrEduP, probe:20390
RETCODE : ZRC=0x8280001A=-2105540582=HDR_ZRC_NO_STANDBY
      "Comm time-out in unforced HADR primary start, to avoid split-brain"

2012-09-01-08.45.03.638929+480 I6249G295       LEVEL: Warning
PID    : 4523                TID  : 3086862016  PROC : db2hadrp (SAMPLE) 0
INSTANCE: db2inst1          NODE : 000
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrEduP, probe:20302
MESSAGE : Info: Primary Finished.

2012-09-01-08.45.03.639073+480 I6545G398       LEVEL: Error
PID    : 4523                TID  : 3086862016  PROC : db2hadrp (SAMPLE) 0
INSTANCE: db2inst1          NODE : 000
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrEduEntry, probe:21100
RETCODE : ZRC=0x8280001A=-2105540582=HDR_ZRC_NO_STANDBY
      "Comm time-out in unforced HADR primary start, to avoid split-brain"

2012-09-01-08.45.03.639419+480 E6944G314       LEVEL: Event
PID    : 4523                TID  : 3086862016  PROC : db2hadrp (SAMPLE) 0
INSTANCE: db2inst1          NODE : 000
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrSetDbRole, probe:10010
CHANGE  : HADR role set to Standard (was Primary)

2012-09-01-08.45.03.648011+480 I7259G496       LEVEL: Severe
PID    : 2753                TID  : 3086862016  PROC : db2agent (SAMPLE) 0
INSTANCE: db2inst1          NODE : 000
APPHDL  : 0-522             APPID: *LOCAL.db2inst1.120901004002
AUTHID  : DB2INST1
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrEduStartup, probe:21300
MESSAGE : Error: HADR EDU did not start up. HADR role:
DATA #1 : Hexdump, 4 bytes
0xBFDC046C : 0100 0000                               ....

2012-09-01-08.45.03.648348+480 I7756G464       LEVEL: Error
PID    : 2753                TID  : 3086862016  PROC : db2agent (SAMPLE) 0
INSTANCE: db2inst1          NODE : 000
APPHDL  : 0-522             APPID: *LOCAL.db2inst1.120901004002
AUTHID  : DB2INST1
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrEduStartup, probe:21300
MESSAGE : HADR EDU zrc:
DATA #1 : Hexdump, 4 bytes
0xBFDC043C : 1A00 8082                               ....

2012-09-01-08.45.03.648548+480 I8221G468       LEVEL: Error
PID    : 2753                TID  : 3086862016  PROC : db2agent (SAMPLE) 0
INSTANCE: db2inst1          NODE : 000
APPHDL  : 0-522             APPID: *LOCAL.db2inst1.120901004002
AUTHID  : DB2INST1
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrEduStartup, probe:21300
MESSAGE : HADR EDU sqlcode:
DATA #1 : Hexdump, 4 bytes
0xB7FD4A7C : 18F9 FFFF                               ....

2012-09-01-08.45.03.648697+480 I8690G415       LEVEL: Severe
PID    : 2753                TID  : 3086862016  PROC : db2agent (SAMPLE) 0
INSTANCE: db2inst1          NODE : 000
APPHDL  : 0-522             APPID: *LOCAL.db2inst1.120901004002
AUTHID  : DB2INST1
FUNCTION: DB2 UDB, base sys utilities, sqlesrsu, probe:17
DATA #1 : Hexdump, 4 bytes
0xB7FD4A7C : 18F9 FFFF                               ....

主库相关参数：

HADR local host name                (HADR_LOCAL_HOST) = 192.168.0.88
HADR local service name             (HADR_LOCAL_SVC) = DB2_HADR_1
HADR remote host name             (HADR_REMOTE_HOST) = 192.168.0.77
HADR remote service name             (HADR_REMOTE_SVC) = DB2_HADR_2
HADR instance name of remote server  (HADR_REMOTE_INST) = db2inst1
HADR timeout value                      (HADR_TIMEOUT) = 300
HADR log write synchronization mode    (HADR_SYNCMODE) = NEARSYNC

备库相关参数：

HADR local host name                (HADR_LOCAL_HOST) = 192.168.0.77
HADR local service name             (HADR_LOCAL_SVC) = DB2_HADR_2
HADR remote host name             (HADR_REMOTE_HOST) = 192.168.0.88
HADR remote service name             (HADR_REMOTE_SVC) = DB2_HADR_1
HADR instance name of remote server  (HADR_REMOTE_INST) = db2inst1
HADR timeout value                      (HADR_TIMEOUT) = 300
HADR log write synchronization mode    (HADR_SYNCMODE) = NEARSYNC

主库和备库的/etc/services文件相关的部分：

DB2_HADR_1    55001/tcp
DB2_HADR_2    55002/tcp

关注1

参与9

8同行回答
全部行业
全部行业 软件开发 增值通信服务商 互联网服务 政府机关
|
按赞同排序
按时间排序

freebsdjlu数据库管理员IBM

对，端口号不能是svcename and svcename+1,但为什么这个+1也不可以呢？收起

互联网服务 · 2012-09-06

Meral数据库管理员GUOJI

DB2_HADR_1 55001/tcp
DB2_HADR_2 55002/tcp
貌似端口号不行吧。改下端口号试试。
HADR_LOCAL_SVC ：Specifies the TCPIP service name or port number for which HADR process accepts connections on the local host. This port cannot be the same as the
SVCENAME or SVCENAME+1 of the HADR instance.

HADR_REMOTE_SVC ：Specifies the TCPIP service name or port number for which HADR process accepts connections on the remote node. This port cannot be the same as the
SVCENAME or SVCENAME+1 of the remote instance.
详细请看731最后一部分。收起

互联网服务 · 2012-09-06

陈辉研发工程师IBM

楼上几位说得对，你看一下主备之间的通信情况。你是第一次安装HADR吗？如果是，可以参考这篇文章，对比看你哪一步骤配置有问题。http://www.db2china.net/home/space.php?uid=26949&do=blog&id=14706 收起

软件开发 · 2012-09-03

shengfei0419软件开发工程师IBM

网络问题。
看看为什么主机和备机的不能建立网络连接。
可以用telnet 192.168.0.77 55002 看看什么状况。
同时检查一下防火墙。收起

互联网服务 · 2012-09-02

weiruan85数据库管理员ibm

貌似跟standby 的网络不通呀收起

政府机关 · 2012-09-02

freebsdjlu数据库管理员IBM

同时检查两面，看看standby那边有没有错误信息，并确保hadr在standby侧正常运行，并检查server之间的网络，至少确保可以ping通收起

互联网服务 · 2012-08-31

beijing_2011安全审计师北京华为

回复 2# daolin2005

备库我已经成功启动，现在启动primary老报错收起

增值通信服务商 · 2012-08-31

daolin2005数据库管理员某城商行

"Comm time-out in unforced HADR primary start, to avoid split-brain"
先启standby .收起

软件开发 · 2012-08-31

hadr主库不能启动

8同行回答
全部行业
全部行业 软件开发 增值通信服务商 互联网服务 政府机关
|
按赞同排序
按时间排序

提问者

问题状态

hadr主库不能启动

8同行回答全部行业全部行业软件开发增值通信服务商互联网服务政府机关|按赞同排序按时间排序

提问者

问题状态

8同行回答
全部行业
全部行业软件开发增值通信服务商互联网服务政府机关
|
按赞同排序
按时间排序