PL/SQL连不上,报 ORA-12170:TNS 连接超时

 

 

排错步骤:

1.查看网络是否通畅

    打开cmd, ping 数据库IP

2. 查看端口是否通畅

   打开cmd,tnsping 数据库IP

    如果piing不通,可能是防火墙问题

3.检查防火墙状态

   #service iptables status

   如果开启,请关闭:#service iptables stop

4.查看监听服务是否开启

   $lsnrctl status

    如果未开启,执行命令启动监听: lsnrctl start

##  tns配置

  ORCL =
(DESCRIPTION =
(ADDRESS =(PROTOCOL = TCP)(HOST = 172.20.36.79)(PORT = 1521))
(CONNECT_DATA=
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

转载于:https://www.cnblogs.com/gw666/p/7889287.html