欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页

ORA-12170:TNS:连接超时

程序员文章站 2024-01-22 22:01:16
...

ORA-12170:TNS:连接超时

参考各位大佬的意见,貌似都是防火墙,iptables等问题,可我都全都关了,最后想到了,原来是我没放通安全规则,1521 端口过不去

第一位
第二位

放开云服务器安全规则

ORA-12170:TNS:连接超时

命令行现在连上了



[aaa@qq.com ~]# telnet 182.254.178.213 1521
Trying 182.254.178.213...
Connected to 182.254.178.213.
Escape character is '^]'.
Connection closed by foreign host.


[aaa@qq.com ~]$ tnsping 182.254.178.213

TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 01-MAR-2020 19:37:52

Copyright (c) 1997, 2013, Oracle.  All rights reserved.

Used parameter files:
/work/oracle/product/11.2.0/network/admin/sqlnet.ora

Used EZCONNECT adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=182.254.178.213)(PORT=1521)))
OK (0 msec)



两个工具也都连接成功了

ORA-12170:TNS:连接超时
ORA-12170:TNS:连接超时