刚刚帮开发安装了oracle客户端,然后配置tnsnames.ora试图用pl/sql developer登录数据库,但总是报告应用程序无法监听;
使用tnsping检查一下,
C:\Documents and Settings\zhoushuangxian>tnsping 192.122.*.*
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 23-9月 -
2011 16:22:19
Copyright (c) 1997, 2005, Oracle. All rights reserved.
已使用的参数文件:
已使用 HOSTNAME 适配器来解析别名
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=192.122.*.*))(ADDRES
S=(PROTOCOL=TCP)(HOST=192.122.*.*)(PORT=1521)))
TNS-12541: TNS: 无监听程序
而tnsnames.ora的配置为
justin =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.122.*.*)(PORT = 1522))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME =justin)
)
)
即明明指定的port为1522,但是tnsping却显示port=1521;
经过一番仔细辨别排查,发现使用tnsping显示出一行信息
已使用 HOSTNAME 适配器来解析别名
看来并没有使用tnsnames.ora用做解析文件,修改该oracle客户端的sqlnet.ora,
NAMES.DIRECTORY_PATH= (TNSNAMES)
强制其只使用tnsnames.ora作为解析文件,修改后tnsping成功
C:\Documents and Settings\zhoushuangxian>tnsping 192.122.*.*
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 23-9月 -
2011 16:33:15
Copyright (c) 1997, 2005, Oracle. All rights reserved.
已使用的参数文件:
D:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
已使用 TNSNAMES 适配器来解析别名
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 192.122.*.*)(PORT = 1522))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_
NAME =justin)))
OK (60 毫秒)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15480802/viewspace-708209/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/15480802/viewspace-708209/