ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

Question

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
localhost:1521:xfhtdb
)
2010-04-16 10:22:39,125 [org.hibernate.cfg.SettingsFactory]-[WARN] 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:xfhtdb
) orcale 11g 数据库 不知道什么问题 有人能解释下嘛？？？

Answer 1

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

devdb=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.84)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME =devdb.ecp888.com)
)
)

Answer 2

解决ORACLE常见错误ORA-12505

http://www.tudou.com/listplay/zlwxNFxGCJ0/sPX_uD6JQjw.html

Answer 3

监听程序不能识别连接标识符中的数据库SID，查一下net manager中的配置。