决策系统连接不上oracle数据库

决策系统连接不上orale数据库,如何解决?

error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor  (CONNECTION_ID=jenmntWGQN6uQuHJMeGu8g==) 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=jenmntWGQN6uQuHJMeGu8g==) 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

image.pngimage.png

FineReport Qin 发布于 2023-10-20 17:18
1min目标场景问卷 立即参与
回答问题
悬赏:3 F币 + 添加悬赏
提示:增加悬赏、完善问题、追问等操作,可使您的问题被置顶,并向所有关注者发送通知
共2回答
最佳回答
0
CD20160914Lv8专家互助
发布于2023-10-20 17:19(编辑于 2023-10-20 17:22)

你的sid有错误呀

还有把:改成/看

/rac11g

oracle-ORA-12505报错 - 知乎 (zhihu.com)

image.png

image.png

最佳回答
0
ID1208Lv6高级互助
发布于2023-10-20 17:22

image.png

  • 3关注人数
  • 181浏览人数
  • 最后回答于:2023-10-20 17:22
    请选择关闭问题的原因
    确定 取消
    返回顶部