oel7+oracle12c tns 超时

最新推荐文章于 2025-03-05 14:46:39 发布

原创最新推荐文章于 2025-03-05 14:46:39 发布 · 331 阅读

0 ·

CC 4.0 BY-SA版权

本文介绍了在尝试连接Oracle数据库时遇到TNS超时错误的排查过程。通过逐步检查SELinux、iptables及firewalld的状态，最终定位到firewalld服务未关闭导致的问题，并给出了具体的解决方案。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

selinux已经关了，iptables已经关了，

[root@localhost ~]# getenforce
Disabled
[root@localhost ~]# systemctl status iptables.service
iptables.service - IPv4 firewall with iptables
Loaded: loaded (/usr/lib/systemd/system/iptables.service; disabled)
Active: inactive (dead)

May 01 23:22:45 localhost.localdomain systemd[1]: Stopped IPv4 firewall with iptables.
[root@localhost ~]#

tns超时

已使用 TNSNAMES 适配器来解析别名
尝试连接 (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.109.199)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
TNS-12535: TNS: 操作超时

最后发现

firewalld没关

[root@localhost ~]# systemctl status firewalld
firewalld.service - firewalld - dynamic firewall daemon
   Loaded: loaded (/usr/lib/systemd/system/firewalld.service; enabled)
   Active: active (running) since Wed 2017-05-03 04:43:06 EDT; 1min 41s ago
Main PID: 51011 (firewalld)
   CGroup: /system.slice/firewalld.service
           └─51011 /usr/bin/python -Es /usr/sbin/firewalld --nofork --nopid

May 03 04:43:06 localhost.localdomain systemd[1]: Starting firewalld - dynamic firewall daemon...
May 03 04:43:06 localhost.localdomain systemd[1]: Started firewalld - dynamic firewall daemon.
[root@localhost ~]#

关闭firewalld

[root@localhost ~]# systemctl stop firewalld
[root@localhost ~]#