PING[ARC5]: Heartbeat failed to connect to standby 'dghq'. Error is 12
在dataguard搭建之后,主库报错:
TueJul3115:57:112018Error12154receivedloggingontothestandbyPING[ARC5]:Heartbeatfailedtoconnecttostandby'dghq'.Erroris12154.
tnsping dghq是ok的。
检查lns进程不存在
SQL>selectprocess,status,thread#,sequence#,block#,blocksfromv$managed_standby;PROCESSSTATUSTHREAD#SEQUENCE#BLOCK#BLOCKS----------------------------------------------------------------------------------ARCHCONNECTED0000ARCHCLOSING1154096666ARCHCONNECTED0000ARCHCLOSING1171400ARCHCLOSING1171400ARCHCLOSING114124896ARCHCONNECTED0000ARCHCONNECTED0000ARCHCONNECTED0000ARCHCONNECTED0000最后我修改了/etc/hosts后问题解决了--前两行内容注释掉,最后把备库的ip和别名也写到文件里,重启os。[oracle@oraclerac1~]$more/etc/hosts#127.0.0.1localhostlocalhost.localdomainlocalhost4localhost4.localdomain4#::1localhostlocalhost.localdomainlocalhost6localhost6.localdomain6192.168.10.180oraclerac1192.168.10.181oraclerac2
声明:本站所有文章资源内容,如无特殊说明或标注,均为采集网络资源。如若本站内容侵犯了原著者的合法权益,可联系本站删除。