总是有厂家反映新建的dblink有问题
source源地址:10.150.1.1(端口:1522)
destination目标地址:10.150.4.4(端口:1521)
####整体分析思路如下:
1、要求查看下创建dblink语句和tnsname.ora,确认创建语句无误
create database link ITPC
connect to ITSMUSE identified by "szitsm!1000"
using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)
(HOST = 10.150.x.x)(PORT = 1521)))
(CONNECT_DATA =(SERVICE_NAME = itsm2015)))';
2、在目标地址ping和telnet源地址,确认网络连通
ping 10.150.4.4
telnet 10.150.4.4 1521
3、根据dblink语句的信息,sqlplus远程连接目标地址命令,连接超时,应该是防火墙开通的问题
$ sqlplus ITSMUSE/'szitsm!1000'@10.150.4.4:1521/itsm2015
SQL*Plus: Release 11.2.0.4.0 Production on Tue Mar 6 14:50:21 2018
Copyright (c) 1982, 2013, Oracle. All rights reserved.
ERROR:
ORA-12170: TNS:Connect timeout occurred
4、跟厂家确认防火墙是否开通,发现目标地址是SCANIP,所以目标的数据库是一个集群,因此厂家很有可能是只申请开通SCANIP的防火墙
该目标集群地址
物理IP:10.150.2.2/10.150.2.3(端口:1529)
VIP:10.150.2.4/10.150.2.5(端口:1529)
SCANIP:10.150.4.4(端口:1521)
正确的方式应该是申请两个物理IP、两个VIP和SCANIP,缺一不可:
source源地址|destination目标地址|protocol协议|port range端口
-------- | —
10.150.1.1|10.150.2.2|TCP|1529
10.150.1.1|10.150.2.3|TCP|1529
10.150.1.1|10.150.2.4|TCP|1529
10.150.1.1|10.150.2.5|TCP|1529
10.150.1.1|10.150.4.4|TCP|1521
5、最后必须在服务器里,全部能通,才算正确
telnet 10.150.2.2 1529
telnet 10.150.2.3 1529
telnet 10.150.2.4 1529
telnet 10.150.2.5 1529
telnet 10.150.4.4 1521