oracle10g连接报12505

[编号1994]

### Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is 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:orcl
)

是监听配置问题吗，求各位打什么指教

[学海无涯-回头是岸]

你给的服务名 或者实例名错了

[sych888]

1、检查TNSNAME配置文件 2、检查监听和数据服务是否已经启动 3、TNSPING

[jdsnhan]

host port sid 检查这三者是否正确

[minsic78]

服务器端lsnrctl status输出和客户端使用的连接字符串贴下

[wj901470]

localhost 只能是本机，你的服务器和客户端不是一个电脑就不行。