ORA-12505, TNS:listener does not currently know of SID

最新推荐文章于 2021-11-09 16:42:55 发布

cov61598

最新推荐文章于 2021-11-09 16:42:55 发布

阅读量289

点赞数

文章标签：数据库

公司上了很多Oracle 12c版本的数据库，开发人员通过JDBC连接数据库时，经常遇到ora-12505报错：

报错信息：

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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/27126919/viewspace-2124731/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/27126919/viewspace-2124731/

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

cov61598

关注关注

0
点赞
踩
1

收藏

觉得还不错? 一键收藏
0
评论
复制链接

分享到 QQ

分享到新浪微博

扫一扫

Oracle连接失败，ORA-12514, TNS:listener does not currently know of service requested in connect descripto

十三月的博客

01-22

3820

在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数据库，报错提示ORA-12505, TNS:listener does not currently know of SID

qq_38050852的博客

10-18

5940

调用配置文件连接oracle数据库，报错提示ORA-12505, TNS:listener does not currently know of SID 场景复现：监听文件：配置文件：由于我用的是springboot框架，所以配置文件是application.properties。其他框架视自身情况而定错误原因 jdbc连接数据库的时候，需要使用数据库的sid_name，而不是数据库...

参与评论您还未登录，请先登录后发表或查看评论

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

热门推荐

古柏树下的博客

09-11

8万+

ORA-12505: TNS: 监听程序当前无法识别连接描述符中所给出的SID 给程序配置新的数据库的时候，出现了以下错误 ORA-12505, TNS:listener does not currently know of SID given in connect descriptor 说明给到的sid有误,很有可能就是服务名和sid混淆使用。首先了解数据库url的写法有两种 ...

ORA-12505 TNS:listener does not currently know of SID given in connect descriptor

jihuanliang的专栏

09-27

4468

Caused by: java.sql.SQLException: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor问题解决方案

flytalei的博客

11-09

2738

今天开发需求需要链接oracle数据库，公司最近做了测试环境的ip地址迁移，于是我把oralce的链接配置换上了新地址后，准备启动项目跑起来。谁知一起动就报错 Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is org.apache.commons.dbcp.S...

ORA-12505, TNS:listener does not currently know of SID given

清水的专栏

05-28

275

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

【FAQ】ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

loongshawn的博客

07-26

438

需求来源 oracle连通性问题问题描述 ORA-12514: TNS:listener does not currently know of service requested in connect descriptor 解决方式 1、联系数据库dba； 2、看看是不是监听服务没有起来，这个错误是因为Listener出了问题，请检查一下你的listener.ora文件； SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLS

ORA-12505 TNS:listener does not currently konw of sid given i

最新发布

11-17

ORA-12505 TNS:listener does not currently know of SID given in connect descriptor错误通常是由于Oracle数据库实例的SID或服务名称不正确或未在监听器中注册引起的。解决此问题的方法包括： 1.检查连接描述符中...

PL/SQP登录报错：TNS:listener does not currently know of service requested in connect descriptor

qq_41384705的博客

09-13

369

找到oracle安装目录下network/admin/listener.ora 打开：SID_LIST_LISTENER = (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = D:\downLoad\WINDOWS.X64_193000_db_home) ...

ORA-12505,TNS:listener does not currently know of SID given in connect descriptor

iFairStyle的博客

04-04

1053

这是tnsnames.ora和listener.ora的目录文件 D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN 记住，每次更改这些文件都需要重启服务计算机-右击管理-服务和应用程序，在找OracleOraDb11g_home1TNSListener 重新启动就好了这是我的tnsnames.ora文件内容 ORCL =

ORA-12505, TNS:listener does not currently know of SID given in connect descript

baibashige的专栏

09-03

1041

错误：java.sql.SQLException: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect 且不能修改数据库的配置文件。解决：select instance_name fro

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.

‘ORA-12505, TNS:listener does not currently know of SID given in connect descriptor’

Yahets_Lee的专栏

06-30

520

打开Oracle的 listener.ora 文件：（F:\oracle\product\10.2.0\db_1\network\ADMIN/listener.ora）修改前：# listener.ora Network Configuration File: F:\oracle\product\10.2.0\db_1\network\admin\listener.ora# Generated ...

ORA-12505：TNS:listener does not currently know of SID given in connect descriptor

记录日常开发过程中遇到的一些问题

09-15

1781

安装oracle后自动生成的listener.ora文件如下： # listener.ora Network Configuration File: /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora # Generated by Oracle configuration tools. LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (A

ORA12505, TNS:listener does not currently know of SID given in connect descriptor

weixin_34197488的博客

10-10

Listener refused the connection with the following error:|ORA12505, TNS:listener does not currently know of SID given in connect descriptor|The Connection descriptor used by the client was:...

error 2013 (hy000): lost conne

03-16

ction to MySQL server during query 这个错误提示意味着在执行查询期间，与MySQL服务器的连接丢失了。可能是由于网络问题、服务器故障或其他原因导致的。建议检查网络连接、MySQL服务器状态和查询语句是否正确。如果问题仍然存在，可以尝试重新连接MySQL服务器或联系管理员寻求帮助。