azure 云上 oracle11 2 0 4里dataguard归档日志传输 1034 问题详细解决过程

分享一下我老师大神的人工智能教程！零基础，通俗易懂！http://blog.csdn.net/jiangjunshow

也欢迎大家转载本篇文章。分享知识，造福人民，实现我们中华民族伟大复兴！

               

 

1，dataguard搭建好后，归档日志传输不过去

去查看master库上面的日志

tail –f /data/oracle/diag/rdbms/test_m1/powerdes/trace/alert_powerdes.log，显示信息如下：

Sun May 08 00:34:17 2016

Error 1034 received logging on to the standby

PING[ARC2]: Heartbeat failed to connect to standby 'test_m2'. Error is1034.

 

 

2，tnsping earch_m2是通的

[oracle@azure_test_dbm1_3_111 admin]$  tnsping test_m3       TNS Ping Utility for Linux: Version  11.2.0.4.0 - Production on 08-MAY-2016 09:13:42       Copyright (c) 1997, 2013, Oracle.  All rights reserved.       Used parameter files:           Used TNSNAMES adapter to resolve the  alias   Attempting to contact (DESCRIPTION =  (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.3.112)(PORT =  1521))) (CONNECT_DATA = (SERVICE_NAME = test_m2)))   OK (0 msec)   [oracle@azure_test_dbm1_3_111 admin]$

 

3，去standby备库上，Check检查下service_name，看到service_names确实是test_m2

看起来service_name也没用错，如下所示：

[oracle@azure_test_dbm1_3_112 admin]$  rlwrap sqlplus / as sysdba       SQL*Plus: Release 11.2.0.4.0 Production  on Sun May 8 09:15:27 2016       Copyright (c) 1982, 2013, Oracle.  All rights reserved.           Connected