Shulou(Shulou.com)06/01 Report--

After the dataguard is built, the main database reports an error:

Tue Jul 31 15:57:11 2018Error 12154 received logging on to the standbyPING [ARC5]: Heartbeat failed to connect to standby 'dghq'. Error is 12154.

Tnsping dghq belongs to ok.

Check that the lns process does not exist

SQL > select process, status, thread#,sequence#, block#, blocks from v$managed_standby PROCESS STATUS THREAD#SEQUENCE# BLOCK# BLOCKS--ARCH CONNECTED 00 0ARCH CLOSING 1 154096 666ARCH CONNECTED 00 00ARCH CLOSING 1 17 1 400ARCH CLOSING 1 17 1 400ARCH CLOSING 1 14 1 24896ARCH CONNECTED 00 00ARCH CONNECTED 00 finally I modified / etc/hosts and solved the problem-- comment out the first two lines Finally, write the ip and alias of the repository into the file, and restart os. [oracle@oraclerac1 ~] $more / etc/hosts#127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4#::1 localhost localhost.localdomain localhost6 localhost6.localdomain6192.168.10.180 oraclerac1192.168.10.181 oraclerac2

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.