本人的问题已解决，先在安装oracle的服务器上黑窗口输入tnsping，提示说no listener，这是监听服务没有打开。
打开服务后还是不行，最后原因是服务器的网络有防火墙的问题，关掉防火墙连接成功
第一反应是监听没开：
- 测试了一下， 连接超时没用ping 通
C:UsersAdministrator>tnsping brorcl
TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 15-6月 -2015 09:45:43
Copyright (c) 1997, 2010, Oracle. All rights reserved.
已使用的参数文件:
D:oracleproduct11.2.0dbhome_1
etworkadminsqlnet.ora
已使用 TNSNAMES 适配器来解析别名
尝试连接 (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.14.147.112)(PORT = 42525)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = brorcl)))
TNS-12535: TNS: 操作超时
- 我登陆到远程服务器上，查看了一下监听的状态
C:Documents and SettingsAdministrator>lsnrctl status
LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 15-6月 -2015 09:52:54
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
Start Date 15-6月 -2015 09:36:02
Uptime 0 days 0 hr. 16 min. 55 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File F:appAdministratorproduct11.2.0dbhome_1
etworkadminlistener.ora
Listener Log File F:appAdministratorproduct11.2.0dbhome_1
etworkloglistener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=.pipeEXTPROC1521ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=x3650m3)(PORT=47512)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=47512)))
Services Summary...
Service "BANKASSIST" has 1 instance(s).
Instance "brorcl", status READY, has 1 handler(s) for this service...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "brorcl" has 2 instance(s).
Instance "brorcl", status UNKNOWN, has 1 handler(s) for this service...
Instance "brorcl", status READY, has 1 handler(s) for this service...
Service "brorclXDB" has 1 instance(s).
Instance "brorcl", status READY, has 1 handler(s) for this service...
The command completed successfully
看到监听也正常，本地连接进去也很正常。
-
我想了一下本地能访问远程连接不上是不是防火墙问题，于是我关闭了windows防火墙，果然在远程tnsping 能ping通了；
-
结果：应该是防火墙有改动了，最后把 服务器防火墙的 ip和端口添加为例外，应用恢复正常了。
总结： 一般遇到tns 的问题通常都是监听或者是网络问题
1. 查看监听是否正常
2. 查看 ip 或端口有没有改动
3. 查看防火墙
————————————————
原文链接：https://blog.csdn.net/zhengwei125/article/details/46535437