ORA-12505 异常 未找到原因

最新推荐文章于 2022-07-04 17:54:19 发布
最新推荐文章于 2022-07-04 17:54:19 发布
阅读量202 收藏
点赞数
分类专栏： 异常 文章标签： Java Oracle Apache JDBC Hibernate
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/wenjinglian/article/details/83951898
版权

 

Caused by: java.sql.SQLException: Unable to open a test connection to the given database. JDBC url = jdbc:oracle:thin:@192.168.0.74:1521:orcltest, username = payment. Terminating connection pool. Original Exception: ------
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
The Connection descriptor used by the client was:
192.168.0.74:1521:orcltest

	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)
	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:260)
	at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:386)
	at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:438)
	at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:164)
	at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34)
	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:752)
	at java.sql.DriverManager.getConnection(DriverManager.java:620)
	at java.sql.DriverManager.getConnection(DriverManager.java:200)
	at com.jolbox.bonecp.BoneCP.obtainRawInternalConnection(BoneCP.java:213)
	at com.jolbox.bonecp.BoneCP.<init>(BoneCP.java:237)
	at com.jolbox.bonecp.BoneCPDataSource.maybeInit(BoneCPDataSource.java:123)
	at com.jolbox.bonecp.BoneCPDataSource.getConnection(BoneCPDataSource.java:85)
	at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:82)
	at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
	at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
	at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:142)
	at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:85)
	at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1353)
	at org.springframework.orm.hibernate3.HibernateTransactionManager.doBegin(HibernateTransactionManager.java:558)
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:374)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:263)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:101)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
	at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:635)
	at com.msd.payCenter.sensitive.service.impl.SensitiveWordServiceImpl$$EnhancerByCGLIB$$78d72aa3.querySensitiveWord(<generated>)
	at com.msd.payCenter.commons.DictionaryManager.loadSensitiveDictMap(DictionaryManager.java:203)
	at com.msd.payCenter.commons.DictionaryManager.init(DictionaryManager.java:74)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:616)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1414)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1375)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1335)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:473)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
	at java.security.AccessController.doPrivileged(Native Method)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:168)
	at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.autowireResource(CommonAnnotationBeanPostProcessor.java:435)
	at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.getResource(CommonAnnotationBeanPostProcessor.java:409)
	at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor$ResourceElement.getResourceToInject(CommonAnnotationBeanPostProcessor.java:537)
	at org.springframework.beans.factory.annotation.InjectionMetadata$InjectedElement.inject(InjectionMetadata.java:180)
	at org.springframework.beans.factory.annotation.InjectionMetadata.injectFields(InjectionMetadata.java:105)
	at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessAfterInstantiation(CommonAnnotationBeanPostProcessor.java:289)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:959)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:472)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
	at java.security.AccessController.doPrivileged(Native Method)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:429)
	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:728)
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:380)
	at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:255)
	at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:199)
	at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:45)
	at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3972)
	at org.apache.catalina.core.StandardContext.start(StandardContext.java:4467)
	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
	at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1041)
	at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:964)
	at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:502)
	at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
	at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
	at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
	at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
	at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
	at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
	at org.apache.catalina.core.StandardService.start(StandardService.java:519)
	at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
	at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:616)
	at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
	at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
------

	at com.jolbox.bonecp.BoneCP.<init>(BoneCP.java:243)
	at com.jolbox.bonecp.BoneCPDataSource.maybeInit(BoneCPDataSource.java:123)
	at com.jolbox.bonecp.BoneCPDataSource.getConnection(BoneCPDataSource.java:85)
	at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:82)
	at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446)
	... 77 more

 

 

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

The Connection descriptor used by the client was:

192.168.0.74:1521:orcltest

 

这个错误导致项目没有启动成功，192.168.0.74:1521:orcltest ，这个配置都是没错了，通过PL/SQL也是可以正确连接的，不知道什么原因。重启又好了。

 

贴个相同问题的BLOG

http://fengqx.iteye.com/blog/419412

 

 

 

 

wenjinglian
关注
专栏目录
oracle重建ehca,java.sql.SQLSyntaxErrorException: ORA-00923: 未找到要求的 FROM 关键字
weixin_32073375的博客
04-16 2040
ssm(Oracle)配置druid数据库连接池,正常启动项目,但是请求访问数据库时报错 “java.sql.SQLSyntaxErrorException: ORA-00923: 未找到要求的 FROM 关键字” 原因: jdbc配置validationQuery:SELECT 1 这是mysql的写法,oracle应改为validationQuery:SELECT * from dual....
java 调用 ora-04068_关于ORA-06508 ， ORA-04068异常的详细说明
weixin_39774044的博客
02-16 596
出现这种情况的原因是因为，对于全局变量，每一个session会生成一个本地copy，如果程序重新编译的话，就会因程序里原变量找不到而丢弃该变量，继而导致这个错误。也就是说在一个会话中调用程序包package时，会生成package中全局变量的副本，如果在另一个会话中对此package进行编译就会使前一个会话中的副本失效，故而产生错误。要想避免这个错误，可以使程序捕获ORA-06508:的错误进行处...
Ora-12505 故障
weixin_33920401的博客
01-04 91
昨天在客户现场处理Oracle重构作业，原以为一切非常顺利。不过在一切均已经完毕后，测试两套应用系统的联动时却报以下错误： Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153093120)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4)))) 开发人员对此不熟悉，不断在翻阅...
ora-12505错误解决，以及查找oracle安装目录
HI,我是小瑞！
12-03 660
甲方新建 oracle环境，然后连接的时候报错ora-12505 自己去aix下面找oracle安装目录， su - oracle set 从环境变量检查oracle的ORACLE_BASE或者ORACLE_HOME，就知道啦。 或者 su - oracle which  sqlplus 这里看到的是oracle的bin目录，那么你就可以推断出来了。
JDBC连接Oracle数据库时出现的ORA-12505错误及解决办法
nj_ybxie的专栏
07-11 1237
问题描述：  ORA-12505, TNS:listener does not currently know of SID given in connect descriptor The Connection descriptor used by the client was: localhost:1521:orcl_project
ORA-12505错误
bennett2009的专栏
07-04 163
在使用oracle时遇到了一个问题： ORA-12505, TNS:listener does not currently know of SID given in connect descriptor The Connection descriptor used by the client was: localhost:1521:orcl 查阅了很多网上的内容，知道了是oracle ...
jdbc连接oracle出现ORA-12505的解决办法
热门推荐
fangzheng_2009的专栏
08-09 3万+
<br />tomcat启动时，报错<br />引用<br />2008-01-22 14:11:53,312 ERROR main org.hibernate.util.JDBCExceptionReporter - Cannot create PoolableConnectionFactory (Io 异常: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=153093120)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)
Oracle12cRAC数据库 出现ora-12520, ora-12516
08-17
### Oracle12cRAC数据库出现ora-12520, ora-12516问题解析 #### 一、问题概述 在使用Oracle12cRAC（Real Application Clusters）数据库的过程中，可能会遇到客户端连接时出现ora-12520或ora-12516错误的问题。这两...
记一次oracle异常恢复，解决ORA-01261、ORA-01262，ORA-00205、ORA-00210、ORA-00202、ORA-27037，ORA-00201
槑の少年的博客
07-04 2457
记一次oracle异常恢复，解决ORA-01261、ORA-01262，ORA-00205、ORA-00210、ORA-00202、ORA-27037，ORA-00201
ora-01403:未找到任何数据
TrHlxc的专栏
03-11 2948
需求： 打算从fa_product_net_value表中拿出一只基金对应的所有估值日期，再应用此日期计算相应的指标。 declare v_date_1 date ; v_product nvarchar2(20) := '00010000388015'; v_date date :=date'2015-06-19'; begin DBMS_OUTPUT.ENABLE (bu
java.sql.SQLException: 内部错误: Unable to construct a Datum from the specified input
09-06
Unable to construct a Datum from the specified input的解决方法
对于ORA-12505新的解决办法
weixin_44278567的博客
06-30 201
对于ORA-12505: TNS: 监听器无法处理连接描述符中所给出的 SID 服务器搭好了Oracle有一段时间了，一直稳定，plsql和项目访问正常，在前几天重启了服务器，结果登录就报12505了，试过大佬说的修改监听文件配置，没有任何效果。 最后突发奇想将Net Configuration Assistant中的监听重新配置，一切都按照之前的配了一遍，最后神奇的可以连接了。 以此希望对大家有所帮助 ...
【Hive】中将元数据Metastore配置到MySql时，hive启动异常
Aimo_哈撒的博客
07-05 985
在将hive中的元数据配置到mysql中，以便实现多窗口启动hive的过程中，一切配置都ok，但是在启动hive的时候出现了以下错误： Caused by: java.sql.SQLException: Unable to open a test connection to the given database. JDBC url = jdbc:mysql://hadoop102:3306/m...
容器启动hive报错：Caused by: java.sql.SQLException: Unable to open a test connection to the given database.
weixin_43968936的博客
11-18 1339
Caused by: java.sql.SQLException: Unable to open a test connection to the given database. JDBC url = jdbc:mysql://localhost:3306/hive?useSSL=false, username = root. Terminating connection pool (set la...
Hive连接Mysql---FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask.
光于前裕于后的博客
03-26 1万+
hive> show tables; FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.metastore.HiveMetaStoreC
spark集群上提交hivecontext任务报拒绝连接的错误
mhw666的博客
07-23 1099
错误如下： Caused by: java.sql.SQLException: Unable to open a test connection to the given database. JDBC url = jdbc:mysql://localhost:3306/hive?createDatabaseIfNotExist=true, username = root. Terminating ...
Hive连接数据库失败的原因（NestedThrowables）
盖世英雄来了
09-22 5313
NestedThrowables: java.sql.SQLException: Unable to open a test connection to the given database. JDBC url = jdbc:mysql://hadoop:3306/metastore?createDatabaseIfNotExist=true, username = root. Terminati...
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
悟世君子的博客
05-25 9536
项目启动报错：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 报错详细内容 java.sql.SQLException: Listener refused the connection with the followin.
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值