ORA-12170:TNS:连接超时
程序员文章站
2024-01-22 22:01:16
...
ORA-12170:TNS:连接超时
参考各位大佬的意见,貌似都是防火墙,iptables等问题,可我都全都关了,最后想到了,原来是我没放通安全规则,1521 端口过不去
放开云服务器安全规则
命令行现在连上了
[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)