DB2设置HADR启动主库时报错SQL1768N Unable to start HADR. Reason code = “7“.问题解决实例

SQL1768N  Unable to start HADR. Reason code = "7".

使用tail -f命令跟db2diag.log查看

tail -f /db2home/imestest/sqllib/db2dump/db2diag.log

The HADR primary was not able to form a TCP connection with the standby: 10.6.0.162:65532.

主库无法连接备库的端口

查询备库端口是否正常打开

 netstat -tuln

查询没有发现我配置的65532端口

查询资料

LINUX的端口和服务_alpine linux 3.12开启25端口-CSDN博客

端口和服务绑定的

对备库的hadr进行重启

检查端口

重试还是失败

2024-05-30-13.41.47.931516+480 I574156453E1029       LEVEL: Error
PID     : 1172                 TID : 140385401693952 PROC : db2sysc 0
INSTANCE: imestest             NODE : 000            DB   : TESTDB
HOSTNAME: h2testdb02
EDUID   : 200                  EDUNAME: db2hadrs.0.0 (TESTDB) 0
FUNCTION: DB2 UDB, High Availability Disaster Recovery, hdrVerifyDBCompatibility, probe:15511
MESSAGE : ZRC=0x87800140=-2021654208=HDR_ZRC_CONFIGURATION_ERROR
          "One or both databases of the HADR pair is configured incorrectly"
 

ADM12502E  Unable to establish HADR primary-standby connection
          because the DB2 versions do not match the primary and standby
          databases. Upgrade the DB2 software to the same release and FixPak on
          either the HADR primary or HADR standby database to match the other.
查询日志显示数据库的HADR配置不一致，另一个报错是主备版本不一致

主库：

备库：

备库版本升级至DB2 v11.1.4.4后再次起备库和主库HADR

启动成功