连接oracle报错

当前驱动加载路径:D:\tomcat-win64\tomcat-win64\webapps\webroot\WEB-INF\lib\ojdbc8.jar

检测驱动

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  (CONNECTION_ID=4dmaR502Q2Sc8AQ+5Ct3YQ==) at oracle.jdbc.driver.T4CConnection.handleLogonNetException(T4CConnection.java:870) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:675) at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:1032) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:90) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:681) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:602) at com.fr.third.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1666) at com.fr.third.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1732) at com.fr.third.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2907) Caused by: oracle.net.ns.NetException: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor  (CONNECTION_ID=4dmaR502Q2Sc8AQ+5Ct3YQ==) at oracle.net.ns.NSProtocolNIO.createRefusePacketException(NSProtocolNIO.java:816) at oracle.net.ns.NSProtocolNIO.handleConnectPacketResponse(NSProtocolNIO.java:396) at oracle.net.ns.NSProtocolNIO.negotiateConnection(NSProtocolNIO.java:207) at oracle.net.ns.NSProtocol.connect(NSProtocol.java:350) at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1967) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:640) ... 7 more

FineReport yzmxAkXN2229786 发布于 2024-1-5 14:02
1min目标场景问卷 立即参与
回答问题
悬赏:3 F币 + 添加悬赏
提示:增加悬赏、完善问题、追问等操作,可使您的问题被置顶,并向所有关注者发送通知
共3回答
最佳回答
0
CovidLv3高级互助
发布于2024-1-5 14:05
最佳回答
0
ID1208Lv6高级互助
发布于2024-1-5 14:06(编辑于 2024-1-5 14:08)

sid不对,或者用的是service_name,参考下面的格式试试

image.png

最佳回答
0
yzmZQSy29696569Lv4初级互助
发布于2024-1-5 14:07

图1.png

  • 3关注人数
  • 429浏览人数
  • 最后回答于:2024-1-5 14:08
    请选择关闭问题的原因
    确定 取消
    返回顶部