【Java】数据库连接失败：ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

最新推荐文章于 2023-12-19 09:07:04 发布
最新推荐文章于 2023-12-19 09:07:04 发布
阅读量4.3k 收藏
点赞数
分类专栏： 【Oracle】 文章标签： ORA-12505 TNS SID Oracle descriptor
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/River_Continent/article/details/88941561
版权

一、问题

ERROR StatusLogger No log4j2 configuration file found. Using default configuration: logging only errors to the console. Set system property 'org.apache.logging.log4j.simplelog.StatusLogger.level' to TRACE to show Log4j2 internal initialization logging.
09:22:15.125 [main] ERROR com.alibaba.druid.pool.DruidDataSource - init datasource error, url: jdbc:oracle:thin:@127.0.0.1:1521:ORCL
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
 
	at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:412) ~[ojdbc6.jar:11.2.0.1.0]
	at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:531) ~[ojdbc6.jar:11.2.0.1.0]
	at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:221) ~[ojdbc6.jar:11.2.0.1.0]
	at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32) ~[ojdbc6.jar:11.2.0.1.0]
	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:503) ~[ojdbc6.jar:11.2.0.1.0]
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1583) ~[druid-1.1.15.jar:1.1.15]
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1649) ~[druid-1.1.15.jar:1.1.15]
	at com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:918) ~[druid-1.1.15.jar:1.1.15]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_92]
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_92]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_92]
	at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_92]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1835) ~[spring-beans-5.0.2.RELEASE.jar:5.0.2.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1778) ~[spring-beans-5.0.2.RELEASE.jar:5.0.2.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1706) ~[spring-beans-5.0.2.RELEASE.jar:5.0.2.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:583) ~[spring-beans-5.0.2.RELEASE.jar:5.0.2.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:502) ~[spring-beans-5.0.2.RELEASE.jar:5.0.2.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:312) ~[spring-beans-5.0.2.RELEASE.jar:5.0.2.RELEASE]
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228) [spring-beans-5.0.2.RELEASE.jar:5.0.2.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:310) [spring-beans-5.0.2.RELEASE.jar:5.0.2.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200) [spring-beans-5.0.2.RELEASE.jar:5.0.2.RELEASE]
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:758) [spring-beans-5.0.2.RELEASE.jar:5.0.2.RELEASE]
	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:839) [spring-context-4.2.7.RELEASE.jar:4.2.7.RELEASE]
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:538) [spring-context-4.2.7.RELEASE.jar:4.2.7.RELEASE]
	at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139) [spring-context-4.2.7.RELEASE.jar:4.2.7.RELEASE]
	at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:93) [spring-context-4.2.7.RELEASE.jar:4.2.7.RELEASE]
	at com.caliper.tail.batch.common.BatchApp.start(BatchApp.java:85) [classes/:?]
	at com.caliper.tail.batch.service.CaliperBatchMain.start(CaliperBatchMain.java:40) [classes/:?]
	at com.caliper.tail.batch.service.CaliperBatchMain.main(CaliperBatchMain.java:25) [classes/:?]
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
 
	at oracle.net.ns.NSProtocol.connect(NSProtocol.java:385) ~[ojdbc6.jar:11.2.0.1.0]
	at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1042) ~[ojdbc6.jar:11.2.0.1.0]
	at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:301) ~[ojdbc6.jar:11.2.0.1.0]
	... 28 more
09:22:15.140 [main] ERROR com.alibaba.druid.pool.DruidDataSource - {dataSource-1} init error
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
 
	at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:412) ~[ojdbc6.jar:11.2.0.1.0]
	at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:531) ~[ojdbc6.jar:11.2.0.1.0]
	at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:221) ~[ojdbc6.jar:11.2.0.1.0]
	at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32) ~[ojdbc6.jar:11.2.0.1.0]
	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:503) ~[ojdbc6.jar:11.2.0.1.0]
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1583) ~[druid-1.1.15.jar:1.1.15]
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1649) ~[druid-1.1.15.jar:1.1.15]
	at com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:918) ~[druid-1.1.15.jar:1.1.15]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_92]
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_92]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_92]
	at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_92]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1835) ~[spring-beans-5.0.2.RELEASE.jar:5.0.2.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1778) ~[spring-beans-5.0.2.RELEASE.jar:5.0.2.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1706) ~[spring-beans-5.0.2.RELEASE.jar:5.0.2.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:583) ~[spring-beans-5.0.2.RELEASE.jar:5.0.2.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:502) ~[spring-beans-5.0.2.RELEASE.jar:5.0.2.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:312) ~[spring-beans-5.0.2.RELEASE.jar:5.0.2.RELEASE]
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228) [spring-beans-5.0.2.RELEASE.jar:5.0.2.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:310) [spring-beans-5.0.2.RELEASE.jar:5.0.2.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200) [spring-beans-5.0.2.RELEASE.jar:5.0.2.RELEASE]
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:758) [spring-beans-5.0.2.RELEASE.jar:5.0.2.RELEASE]
	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:839) [spring-context-4.2.7.RELEASE.jar:4.2.7.RELEASE]
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:538) [spring-context-4.2.7.RELEASE.jar:4.2.7.RELEASE]
	at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139) [spring-context-4.2.7.RELEASE.jar:4.2.7.RELEASE]
	at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:93) [spring-context-4.2.7.RELEASE.jar:4.2.7.RELEASE]
	at com.caliper.tail.batch.common.BatchApp.start(BatchApp.java:85) [classes/:?]
	at com.caliper.tail.batch.service.CaliperBatchMain.start(CaliperBatchMain.java:40) [classes/:?]
	at com.caliper.tail.batch.service.CaliperBatchMain.main(CaliperBatchMain.java:25) [classes/:?]
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
 
	at oracle.net.ns.NSProtocol.connect(NSProtocol.java:385) ~[ojdbc6.jar:11.2.0.1.0]
	at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1042) ~[ojdbc6.jar:11.2.0.1.0]
	at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:301) ~[ojdbc6.jar:11.2.0.1.0]
	... 28 more
Exception in thread "main" org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in class path resource [application-persistence.xml]: Invocation of init method failed; nested exception is 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
 
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1710)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:583)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:502)
	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:312)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228)
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:310)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:758)
	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:839)
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:538)
	at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139)
	at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:93)
	at com.caliper.tail.batch.common.BatchApp.start(BatchApp.java:85)
	at com.caliper.tail.batch.service.CaliperBatchMain.start(CaliperBatchMain.java:40)
	at com.caliper.tail.batch.service.CaliperBatchMain.main(CaliperBatchMain.java:25)
Caused by: 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
 
	at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:412)
	at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:531)
	at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:221)
	at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:503)
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1583)
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1649)
	at com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:918)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1835)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1778)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1706)
	... 14 more
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
 
	at oracle.net.ns.NSProtocol.connect(NSProtocol.java:385)
	at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1042)
	at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:301)
	... 28 more
09:22:15.144 [Druid-ConnectionPool-Create-507819576] ERROR com.alibaba.druid.pool.DruidDataSource - create connection SQLException, url: jdbc:oracle:thin:@127.0.0.1:1521:ORCL, errorCode 12505, state 66000
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
 
	at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:412) ~[ojdbc6.jar:11.2.0.1.0]
	at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:531) ~[ojdbc6.jar:11.2.0.1.0]
	at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:221) ~[ojdbc6.jar:11.2.0.1.0]
	at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32) ~[ojdbc6.jar:11.2.0.1.0]
	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:503) ~[ojdbc6.jar:11.2.0.1.0]
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1583) ~[druid-1.1.15.jar:1.1.15]
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1649) ~[druid-1.1.15.jar:1.1.15]
	at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2579) [druid-1.1.15.jar:1.1.15]
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
 
	at oracle.net.ns.NSProtocol.connect(NSProtocol.java:385) ~[ojdbc6.jar:11.2.0.1.0]
	at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1042) ~[ojdbc6.jar:11.2.0.1.0]
	at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:301) ~[ojdbc6.jar:11.2.0.1.0]
	... 7 more
09:22:15.148 [Druid-ConnectionPool-Create-507819576] ERROR com.alibaba.druid.pool.DruidDataSource - create connection SQLException, url: jdbc:oracle:thin:@127.0.0.1:1521:ORCL, errorCode 12505, state 66000
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
 
	at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:412) ~[ojdbc6.jar:11.2.0.1.0]
	at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:531) ~[ojdbc6.jar:11.2.0.1.0]
	at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:221) ~[ojdbc6.jar:11.2.0.1.0]
	at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32) ~[ojdbc6.jar:11.2.0.1.0]
	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:503) ~[ojdbc6.jar:11.2.0.1.0]
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1583) ~[druid-1.1.15.jar:1.1.15]
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1649) ~[druid-1.1.15.jar:1.1.15]
	at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:2579) [druid-1.1.15.jar:1.1.15]
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
 
	at oracle.net.ns.NSProtocol.connect(NSProtocol.java:385) ~[ojdbc6.jar:11.2.0.1.0]
	at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1042) ~[ojdbc6.jar:11.2.0.1.0]
	at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:301) ~[ojdbc6.jar:11.2.0.1.0]
	... 7 more

Process finished with exit code 1

二、解决

原因是Oracle的OracleServiceORCL服务没有开启；
可以通过按快捷键：ctrl+Shift+ESC打开任务管理器，然后找到服务名称为：OracleServiceORCL的服务，右键打开菜单，点击【开始】即可；

也可以按command（就是那个windows标志的4色窗键）+R键，在查询窗口中输入：services.msc，可快捷打开服务窗口；
在这里插入图片描述

陶洲川
关注
专栏目录
Oracle连接失败，ORA-12514, TNS:listener does not currently know of service requested in connect descripto
十三月的博客
01-22 3876
在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
启动startup.bat文件报错:listener does not currently know of SID given in connect descriptor
shui_bu_duo的专栏
11-11 720
启动startup.bat文件报错:  nc.jdbc.framework.exception.DB2Exception: java.sql.SQLException: Listener refused the connection with the following error:  ORA-12505, TNS:listener does not currently know of SID
java操作报错误信息：ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
weixin_39098944的博客
04-03 3020
今天在通过代码连接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 通常建议如下操
java 项目oracle数据源 连接中的坑ORA-12505, TNS:listener does not currently know of SID given in connect descri
lbx1314ybfq的专栏
08-08 734
一般java 项目用ssh或ssm 都是通过spring配置文件连接数据源，个人在项目中一般采用 &lt;bean id="test" class="org.apache.commons.dbcp.BasicDataSource"         destroy-method="close"&gt;         &lt;property name="driverClassName" valu...
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...
Java Oracle：ORA-12505, TNS:listener does not currently know of SID given in connect descriptor.
张小凡
12-16 437
Java链接oracle的时候报错： ORA-12505, TNS:listener does not currently know of SID given in connect descriptor The Connection descriptor used by the client was: xx.xx..x..x:1521:lj08rac 解决方法： 将： jdbc...
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
06-28
这个错误提示表明监听程序无法识别连接描述符中指定的 SID。SID 是 Oracle 数据库的系统标识符，它用于唯一地识别一个特定的实例。 要解决这个问题，你可以检查以下几个方面： 1. 确认数据库实例的 SID 是否正确。...
记一次数据连接失败问题Caused by: java.io.EOFException: Can not read response from server. Expected to read 4 by
qq_27886773的博客
06-01 5199
异常信息， The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. at sun.reflect.NativeConstructorAccessorImpl.newInstance...
解决ORA-12514：TNS:listener does not currently know of service requested in connect descriptor问题，亲测有效
热门推荐
weixin_45685353的博客
07-21 5万+
使用Navicat连接Oracle数据库时，报错ORA-12514：TNS:listener does not currently know of service requested in connect descriptor，如下 经过几番检查，发现主机、端口号、用户名和密码都是正确的，剩下只有服务名没有检查。在Navicat连接Oracle时，服务名默认是ORCL，然后我通过终端连接Oracle，进入后执行 select global_name from global_name; 语句查询Oracle
java连接oracle出现ORA-12505错误
编写博客，学习交流
12-19 1473
sqlplus可以连接;但java连接报错:ORA-12505。
Java程序连接数据库常见故障及问题汇总
weixin_47066756的博客
09-02 1151
如果感觉步骤写得不清楚，或者还遇到新问题，请加以批正，我们来把文章做得更实用一些。
删除oracle归档日志
机智的大黄鱼的博客
02-15 2020
create connection SQLException, url: jdbc:oracle:thin:@//192.168.2.9:1521/ment2, errorCode 257, state 64000 java.sql.SQLException: ORA-00257: archiver error. Connect internal only, until freed. 系统启动时报这个错，原因是oarcle归档日志满了，话不多说，在数据库所在的服务器执行以下命令即可删除无用的日志，如果是生
ORA-12505 web服务器连接数据库错误
DBA小站
09-16 2384
问题描述： 之前给开发在生产环境新建了数据库用户，今天开发反映测试连接的时候无法从web服务器端连接到数据库。 报错如下： java.sql.SQLException: Listener refused the connection with the following error:  ORA-12505, TNS:listener does not currently know of SID
Java 连接oracle 数据库
nurv_nurv的专栏
05-02 1484
Java连接Oracle步骤： 1.注册加载驱动 驱动名：DRIVER="oracle.jdbc.driver.OracleDriver"; Class.forName("驱动类名"); 2.获得连接 数据库地址： URL="jdbc:oracle:thin:@localhost:1521:ORCL"; Connection conn = DriverManager.getConnec
连接ORACLE 提示 ：the account is locked
bir_oct的博客
07-09 766
[ERROR] (druid.pool.DruidDataSource:2336).run:create connection SQLException, url: jdbc:oracle:thin:@***.***.***.***:1521:orcl, errorCode 28000, state 99999 java.sql.SQLException: ORA-28000: the account is locked 由于oracle密码修改，代码中忘记同步了，密码错误一直重连，导致oracle.
求助create connection SQLException如何解决
YX14567的博客
11-07 370
大佬帮帮我
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

陶洲川

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

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

余额充值