在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