java操作报错误信息：ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

最新推荐文章于 2024-02-19 16:16:35 发布
最新推荐文章于 2024-02-19 16:16:35 发布
阅读量3k 收藏 3
点赞数 2
分类专栏： 笔记
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_39098944/article/details/115414001
版权
当尝试通过代码连接Oracle 12c数据库时遇到ORA-12505错误，可能是因为驱动版本不匹配。解决方法包括升级ojdbc驱动到兼容12c的版本，或者修改URL格式，例如将`jdbc:oracle:thin:@10.1.251.115:1521:ORCL`改为`jdbc:oracle:thin:@//10.1.251.115:1521/ORCL`。
摘要由CSDN通过智能技术生成

今天在通过代码连接oracel数库库时，一直报ORA-12505, TNS:listener does not currently know of SID given in connect descriptor的错误信息。。经过多方查找问题原因，原来oracle版本比较新，需要升级驱动包或者更改url样式。。如下

报错信息： ORA-12505, TNS:listener does not currently know of SID given in
connect descriptor

通常建议如下操作可解决问题：
1，升级ojdbc的驱动包，版本至 能支持 12c数据库的。
2，修改连接串：
原始方式： jdbc:oracle:thin:@10.1.251.115:1521:ORCL
修改成： jdbc:oracle:thin:@//10.1.251.115:1521/ORCL

常识的Blog
关注
专栏目录
Oracle连接失败，ORA-12514, TNS:listener does not currently know of service requested in connect descripto
十三月的博客
01-22 3845
在Window上搭建Oracle数据库，安装后启动，使用Dbeaver连接时无法连接，报错：Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor Listener refused the connection with the following error: O
Oracle 11G数据库报错 ：ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
majian_1987的专栏
02-26 8774
本人在做Oracle11G的数据库迁移的时候，报错如下： ORA-12505, TNS:listener does not currently know of SID given in connect descriptor The Connection descriptor used by the client was: 172.1.3.111:1521:eq_test…… 我的数据库ne
ORA-12505, TNS:listener does not currently know of SID given in connect
Selegant的博客
05-26 697
ORA-12505, TNS:listener does not currently know of SID given in connect
Oracle数据库连接出现：ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
weixin_40587144的博客
02-19 5849
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
ORA-12505,TNS:listener does not currently know of SID given in connect descriptor
热门推荐
wl_ldy的专栏
09-24 15万+
1.Oracle客户端的安装： Oracle的安装这里不再细说，网上的安装图解也很详细，Oracle安装完之后，就安装Oracle的客户端，首选从Oracle的官方网站上下载客户端，大小差不多700M的样子，这里使用的是Oracle11g版本，解压之后的目录结构如下： 点击“setup.exe”文件，启动安装程序，具体的安装配置详图参考： http://www.cnblogs.com/j
部署容器数据库连接失败：TNS:listener does not currently know of SID given in connect descriptor
kang1011的博客
11-21 2万+
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor 之前用PL/SQL DEVELOPER和SQLPLUS 登录数据库都没有问题，就是应用程序通过JDBC连接Oracle时无法成功连接，出现ORA-12505错误listener does not currently know of SID given in connect descriptor…。 经过查找， 发现Oracle的serv
连接linux下的oracle数据库报错：ORA-12505: TNS:listener does not currently know of SID given in connect descrip
qq_36703810的博客
04-12 1170
一种可能的解决方案是检查您的JDBC字符串并确保它是正确的。输入 show parameter instance_name 并按回车键。输入 connect sys as sysdba 并按回车键。输入 connect sys as sysdba 并按回车键。输入 sqlplus /nolog 并按回车键。输入 sqlplus /nolog 并按回车键。输入 lsnrctl start 并按回车键。输入 startup 并按回车键。输入您的系统密码并按回车键。输入您的系统密码并按回车键。
Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
最新发布
03-30
"Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor" 是Oracle数据库连接时可能遇到的错误之一。这个错误通常是...
Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
02-02
ORA-12505错误是Oracle数据库连接错误，表示监听程序无法识别连接描述符中给定的SID。这个错误通常发生在以下情况下： 1. SID错误：连接描述符中指定的SID与数据库实例的SID不匹配。请确保连接描述符中的SID与...
ORA-12505: TNS:listener does not currently know of SID given in connect descriptor
09-20
ORA-12505: TNS:listener does not currently know of SID given in connect descriptor 是一个Oracle数据库连接错误。它的原因是监听器不知道给定的SID在连接描述符中。这通常是由于配置问题或者网络问题导致的。 ...
执行请求的操作时遇到错误: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor 供应商代码 12505
07-08
这个错误是执行请求操作时遇到的，错误信息是“listener refused the connection with the following error: ora-12505, tns:listener does not currently know of sid given in connect descriptor”，错误代码是...
ORA-12505, TNS:listener does not currently know of SID given in connect desc
shen_xiao_wei的专栏
07-12 3万+
<br />出现以上的问题是无法识别SID，解决方法如下：<br /> <br />1.找到以下目录,/opt/oracle/product/10.2.0/db_1/network/admin，修改listener.ora，（find -name listener.ora即可找到该文件）为：<br />    <br />    # listener.ora Network Configuration File: /opt/oracle/product/10.2.0/db_1/network/admin/l
ORA-12505, TNS:listener does not currently know of SID given in connect desc .
weixin_33726313的博客
11-29 557
一、正确的链接字符串"Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.100)(PORT=1521))(CONNECT_DATA=(SID=ORACLE)));User Id=system;Password=sa;" --HOST=服务器IP地址， 如192.16.1.100 --SID= .Net Confi...
listener does not currently know of SID given in connect descriptor
evilcry2012的专栏
06-13 1156
listener does not currently know of SID given in connect descriptor 标签： descriptororaclelist数据库tcp 2010-12-14 15:47 7143人阅读 评论(0) 收藏 举报 版权声明：本文为博主原创文章，未经博主允许不得转载。 第一种可能  是配置得数据库SID名
java 启动tomcat时报错：TNS:listener does not currently know of SID given in connect descriptor
滴水穿石
04-30 1978
30-Apr-2019 14:25:01.080 警告 [RMI TCP Connection(2)-127.0.0.1] org.springframework.web.context.support.XmlWebApplicationContext.refresh Exception encountered during context initialization - cancelling...
解决连接oracle服务器故障：TNS:listener does not currently know of SID given in connect descriptor
hustcqb的专栏
04-09 2557
解决方法： 打开Oracle的 listener.ora 文件： （oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora） 修改前： # listener.ora Network Configuration File: /app/oracle/oracle/product/10.2.0/db_1/network/adm
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor异常
添柴程序猿的专栏
09-29 890
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.
使用dbeaver链接oracle报错ORA-12505, TNS:listener does not currently know of SID given in connect descripto
lx2wenhui的博客
05-15 2236
使用dbeaver连接oracle
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值