Myeclipse开发：ORA-12505,TNS:listener does not currently know of SID given in connect descriptor.

题目

Myeclipse开发：ORA-12505,TNS:listener does not currently know of SID given in connect descriptor.
开发环境：Myeclipse 6.5,Tomcat 5.5,oracle 10g,数据库服务器在IP为192.168.10.10的机子上,用户为：username.密码是：password,数据库实例为：test.
启动Tomcat时报错,错误信息如下：
[main] ERROR:org.hibernate.util.JDBCExceptionReporter#logExceptions :Cannot create PoolableConnectionFactory (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:
localhost:1521:mydb
)
(16 ms) [main] WARN :org.hibernate.cfg.SettingsFactory#buildSettings :Could not obtain connection metadata
org.apache.commons.dbcp.SQLNestedException:Cannot create PoolableConnectionFactory (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:
localhost:1521:mydb
)<

答案

碰到过这种问题,改listener.ora 试试是否能解决.
解决方法：
打开Oracle的 listener.ora 文件：
（我的目录 oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora）
可参照参考资料：