最近,我在使用jdbc连接oracle 9i数据库时，发生如下错误：

Error occured while trying to connect to the database

Error connecting to database: (using class racle.jdbc.driver.OracleDriver)
Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
192.168.1.1:1521:bbcd

----解决办法，经查找，以上的bbcd并不是sid_name,而是SERVICE_NAME

改用sid_name后，运行正常。

2006.07.17

服务器上的相关name:

listener.ora: GLOBAL_NAME,SID_NAME

init.ora        :db_name    

附：有关资料