设置好连接池后测试下错误代码如下:java.sql.SQLException: 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:
127.0.0.1:1521:ora9 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:261)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:439)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at jdbc.JdbcExampie.main(JdbcExampie.java:17)
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
127.0.0.1:1521:ora9 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:261)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:439)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at jdbc.JdbcExampie.main(JdbcExampie.java:17)
解决方案 »
- 求高手改造SQL
- 请问oracle 9i statpack报告中的几个ordered by中的参数是什么意思啊?
- 序列是否影响性能
- 请问各位 有100张票四个窗口同时发售 的Java实现就是 用四个线程执行 怎样做呀
- 请问oracle中的段是怎么分配的,是不是一个数据库对象占用一个段,比如一个表空间有三张表,那它就有三个数据段?
- 古怪问题:为什么用 SQLServer 导入导出工具 从orcale导入SqlServer数据时 报 openrowset 错误
- export和RMAN的疑问(在线)
- 可以这样创建视图吗?谢谢!
- 请问数据库链的使用时出错ORA-02085:,如何是好呀?
- 对于要进行大数据量查询和更新的数据如何进行处理!
- 新手求助~关于Oracle登录的问题,错误ORA-28547
- oracle 错误 959 解决方法及疑问……
重新配置数据库监听吗?DNS oracle的配置文件 是指Net Configuration Assistant吗?