ORACLE 连接超时?

[JACKY_KING]

公司一台ORACLE服务器,本机时可以用SQLPLUS登陆连接,但其余的内网机器不可以.

报 ' 连接超时 ' 12535 错误!

sqlnet.log 信息时:
Fatal NI connect error 12535, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.86)(PORT=1521))(CONNECT_DATA=(SID=ora9i)(SERVER=DEDICATED)(CID=(PROGRAM=C:\Program Files\Oracle\jre\1.1.8\bin\jrew.exe)(HOST=5D49AE4F339148C)(USER=Administrator))))

VERSION INFORMATION:
TNS for 32-bit Windows: Version 9.0.1.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 9.0.1.1.0 - Production
Time: 22-2月 -2008 10:24:50
Tracing not turned on.
Tns error struct:
nr err code: 0
ns main err code: 12535
TNS-12535: TNS: 操作超时
ns secondary err code: 12560
nt main err code: 505
TNS-00505: 操作超时
nt secondary err code: 60
nt OS err code: 0

[logonin]

其余的机器要登陆至少要装个oracle的客户端
并需要配置本地的tnsnames.ora
监听需要开启

[JACKY_KING]

我的TNSNAMES.ORA 文件:


ORA_192.168.1.101 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.101)(PORT = 1521))
)
(CONNECT_DATA = (SID = ORA)(SERVER = DEDICATED))
)

ORA9I_192.168.1.86 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.86)(PORT = 1521))
)
(CONNECT_DATA = (SID = ORA9I)(SERVER = DEDICATED))
)

[老紫竹]

没有启动侦听器吧！

lnstart

好像是这个。
如果是Windows, 则到服务里面找！有一个TNS的就是！