有没有oracle高手在啊 我连接别人的数据库 老是超时 咋回事啊?
tnsping 10.132.42.144
TNS Ping Utility for 32-bit Windows: Version 11.1.0.6.0 - Production on 12-2月 -2010 09:13:54 Copyright (c) 1997, 2007, Oracle. All rights reserved. 已使用的参数文件:
F:\app\fKF22289\product\11.1.0\db_1\network\admin\sqlnet.ora 已使用 EZCONNECT 适配器来解析别名
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=10.132.42.144)(PORT=1521))
)
TNS-12535: TNS: 操作超时
tnsping 10.132.42.144
TNS Ping Utility for 32-bit Windows: Version 11.1.0.6.0 - Production on 12-2月 -2010 09:13:54 Copyright (c) 1997, 2007, Oracle. All rights reserved. 已使用的参数文件:
F:\app\fKF22289\product\11.1.0\db_1\network\admin\sqlnet.ora 已使用 EZCONNECT 适配器来解析别名
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=10.132.42.144)(PORT=1521))
)
TNS-12535: TNS: 操作超时
如果有的话,检查网络如果没有的话
检查是不是防火墙没有关。
我tns配置应该没问题
我自己的防火墙是关了的
tnsping IP能这样用吗?
F:\app\fKF22289\product\11.1.0\db_1\network\admin\tnsnames.ora
JIANPUZHAI =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.132.42.144)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.132.42.144)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)试试看。 JIANPUZHAI 区分大小写了么?
TNS Ping Utility for 32-bit Windows: Version 11.1.0.6.0 - Production on 12-2月 -2010 10:13:20Copyright (c) 1997, 2007, Oracle. All rights reserved.已使用的参数文件:
F:\app\fKF22289\product\11.1.0\db_1\network\admin\sqlnet.ora
已使用 TNSNAMES 适配器来解析别名
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.132.42.144)(PORT = 1521)) (CONNECT_DATA = (SE
RVER = DEDICATED) (SERVICE_NAME = orcl)))
TNS-12535: TNS: 操作超时
不过没能找到oraclemanagentservice这个服务,
是不是就是oracle主服务啊?oracleservice数据库名
我把服务器的防火墙关了,这边就好了。谢谢各位了!!!