CNDBA社区
新搭建的DM DW 数据守护环境，启动监视器后，只能看到备库节点，看不到主库节点信息：
[dave@www.cndba.cn_dwmonitor data]$ dmmonitor /dm7/dmdbms/data/dmmonitor.ini
[monitor] 2019-12-17 12:59:35: DMMONITOR[2.1] V7.6.0.95-Build(2018.09.13-97108)ENT
[monitor] 2019-12-17 12:59:35: get local ip address failed
[monitor] 2019-12-17 12:59:35: DMMONITOR[2.1] IS READY.
[monitor] 2019-12-17 12:59:35: 收到守护进程(DW02)消息
WTIME WSTATUS INST_OK INAME ISTATUS IMODE RSTAT N_OPEN FLSN CLSN SSLSN SLSN
2019-12-17 12:59:36 OPEN OK DW02 OPEN STANDBY NULL 3 53870 53870 53870 53870
show
2019-12-17 13:00:10
#================================================================================#
GROUP OGUID MON_CONFIRM MODE MPP_FLAG
GRP1 453331 TRUE MANUAL FALSE
IP INST_PORT MAL_DW_PORT WTIME WTYPE WCTLSTAT WSTATUS INST_OK INAME ISTATUS IMODE RTYPE RSTAT N_OPEN N_TASK TASK_MEM_USED FLSN CLSN SSLSN SLSN
192.168.222.3 5236 5239 2019-12-17 13:00:10 GLOBAL VALID OPEN OK DW02 OPEN STANDBY REALTIME UNKNOWN 3 0 0 53870 53870 53870 53870
#================================================================================#
此时主库备库的实例和守护进程都启动正常：
[dave@www.cndba.cn_dw1 dw]$ disql SYSDBA/SYSDBA
服务器[LOCALHOST:5236]:处于主库打开状态
登录使用时间: 60.728(毫秒)
disql V7.6.0.95-Build(2018.09.13-97108)ENT
Connected to: DM 7.1.6.95
SQL>
SQL> select mode$ from v$instance;
行号 MODE$
---------- -------
1 PRIMARY
已用时间: 7.988(毫秒). 执行号:5.
SQL>
只是监视器无法识别到主节点：
show monitor GRP1.DW01
[monitor] 2019-12-17 13:22:55: 实例名(dw01)无效或尚未收到实例消息!
show monitor GRP1.DW02
2019-12-17 13:23:01
#--------------------------------------------------------------------------------#
GET MONITOR CONNECT INFO FROM DMWATCHER(dw02), THE FIRST LINE IS SELF INFO.
DW_CONN_TIME MON_CONFIRM MID MON_IP MON_VERSION
2019-12-17 13:19:18 TRUE 1576559958 ::ffff:192.168.222.4 DMMONITOR[2.1] V7.6.0.95-Build(2018.09.13-97108)ENT
#--------------------------------------------------------------------------------#
尝试重启了主库和备库的守护进程和实例，依旧无效。
[dave@www.cndba.cn_dw2 dw]$ service DmWatcherServicedw restart
Stopping DmWatcherServicedw: [ OK ]
Starting DmWatcherServicedw: [ OK ]
[dave@www.cndba.cn_dw2 dw]$ service DmServicedw restart
Stopping DmServicedw: [ OK ]
Starting DmServicedw: [ OK ]
[dave@www.cndba.cn_dw2 dw]$
在监视器节点ping 主备库IP，没有异常：
[dave@www.cndba.cn_dwmonitor data]$ cat dmmonitor.ini
……
[GRP1]
MON_INST_OGUID = 453331 #组 GRP1 的唯一 OGUID 值
MON_DW_IP=192.168.222.3:5239
MON_DW_IP=192.168.222.2:5239
[dave@www.cndba.cn_dwmonitor data]$
[dave@www.cndba.cn_dwmonitor data]$ ping 192.168.222.3
PING 192.168.222.3 (192.168.222.3) 56(84) bytes of data.
64 bytes from 192.168.222.3: icmp_seq=1 ttl=64 time=3.67 ms
64 bytes from 192.168.222.3: icmp_seq=2 ttl=64 time=2.62 ms
^C
--- 192.168.222.3 ping statistics ---
2 packets transmitted, 2 received, 0% packet loss, time 1786ms
rtt min/avg/max/mdev = 2.621/3.149/3.678/0.531 ms
[dave@www.cndba.cn_dwmonitor data]$ ping 192.168.222.2
PING 192.168.222.2 (192.168.222.2) 56(84) bytes of data.
64 bytes from 192.168.222.2: icmp_seq=1 ttl=64 time=2.88 ms
64 bytes from 192.168.222.2: icmp_seq=2 ttl=64 time=1.30 ms
^C
--- 192.168.222.2 ping statistics ---
2 packets transmitted, 2 received, 0% packet loss, time 1725ms
rtt min/avg/max/mdev = 1.307/2.098/2.889/0.791 ms
[dave@www.cndba.cn_dwmonitor data]$
最后，尝试在主库ping 监视器的IP 地址，ping 后监视器立马识别到主库的信息：
[dave@www.cndba.cn_dw1 dw]$ ping 192.168.222.4
PING 192.168.222.4 (192.168.222.4) 56(84) bytes of data.
64 bytes from 192.168.222.4: icmp_seq=1 ttl=64 time=13.0 ms
^C
--- 192.168.222.4 ping statistics ---
1 packets transmitted, 1 received, 0% packet loss, time 840ms
rtt min/avg/max/mdev = 13.065/13.065/13.065/0.000 ms
[dave@www.cndba.cn_dw1 dw]$
监视器日志：
[monitor] 2019-12-17 13:25:46: dmmonitor create link to dmwatcher success, mid:1576559958, dmwatcher ip:192.168.222.2, dmwatcher port:5239, vio:4, inst_name:
[monitor] 2019-12-17 13:25:46: <RECEIVE DW01>
[monitor] 2019-12-17 13:25:46: 收到守护进程(DW01)消息
WTIME WSTATUS INST_OK INAME ISTATUS IMODE RSTAT N_OPEN FLSN CLSN SSLSN SLSN
2019-12-17 13:25:46 OPEN OK DW01 OPEN PRIMARY VALID 5 63809 63809 63809 63809
[monitor] 2019-12-17 13:25:46: </RECEIVE DW01>
监视器中show：
show
2019-12-17 13:27:03
#================================================================================#
GROUP OGUID MON_CONFIRM MODE MPP_FLAG
GRP1 453331 TRUE MANUAL FALSE
IP INST_PORT MAL_DW_PORT WTIME WTYPE WCTLSTAT WSTATUS INST_OK INAME ISTATUS IMODE RTYPE RSTAT N_OPEN N_TASK TASK_MEM_USED FLSN CLSN SSLSN SLSN
192.168.222.2 5236 5239 2019-12-17 13:27:02 GLOBAL VALID OPEN OK DW01 OPEN PRIMARY REALTIME VALID 5 0 0 63809 63809 63809 63809
192.168.222.3 5236 5239 2019-12-17 13:27:03 GLOBAL VALID OPEN OK DW02 OPEN STANDBY REALTIME VALID 5 0 0 63809 63809 63809 63809
#================================================================================#
第二次遇到这种情况，随笔记之。
版权声明：本文为博主原创文章，未经博主允许不得转载。
