Question

pb9 连接oracle9i 数据库时，出现ora-12154:TNS 无法处理服务名，请各位大侠指点，

补充一下，pl/sql develop 能够连接成功，oracle sql develop 也能够连接成功，tnsnames.ora 文件为：
dtest =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.31.0.97)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dtest)
)
)
急，在线等待！

Answer 1

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

把(HOST = leo)改为你的ip地址~~~，还不行，重启监听试试！
如果还不行，看看你的pb9.0连接的端口号对不对。网上找找关于pb9.0的配置文件

追问

现在已解决，原来是bin的路径问题，不过还是谢谢各位了。