想要搭建DG,设置好监听、tns service 后,测试tnsping,ping不通,报如下错。
[grid@rac1 ~]$ tnsping sharon_st
TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 30-JUL-2013 22:18:29
Copyright (c) 1997, 2011, 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.56.8)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = sharon_st)))
TNS-12543: TNS:destination host unreachable
[oracle@rac1 ~]$ oerr tns 12543
12543, 00000, "TNS:destination host unreachable"
// *Cause: Contact can not be made with remote party.
// *Action: Make sure the network driver is functioning and the network is up.
经过搜索,发现是防火墙的问题,防火墙开启了,导致其他服务器不能tnsping该服务器。
关闭防火墙就可以正常tnsping了。
[grid@rac1 ~]$ tnsping sharon_st
TNS Ping Utility for Linux: Version 11.2.0.3.0 - Production on 30-JUL-2013 22:19:26
Copyright (c) 1997, 2011, 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.56.8)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = sharon_st)))
OK (10 msec)