快捷导航

oracle 数据库

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:419)        at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:536)        at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:228)        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)        at java.sql.DriverManager.getConnection(DriverManager.java:664)        at java.sql.DriverManager.getConnection(DriverManager.java:208)        at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:153)        at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:144)        at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnectionFromDriver(AbstractDriverBasedDataSource.java:155)        at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnection(AbstractDriverBasedDataSource.java:120)        at org.apache.ibatis.mapping.VendorDatabaseIdProvider.getDatabaseProductName(VendorDatabaseIdProvider.java:77)        at org.apache.ibatis.mapping.VendorDatabaseIdProvider.getDatabaseName(VendorDatabaseIdProvider.java:62)        at org.apache.ibatis.mapping.VendorDatabaseIdProvider.getDatabaseId(VendorDatabaseIdProvider.java:50)        at org.mybatis.spring.SqlSessionFactoryBean.buildSqlSessionFactory(SqlSessionFactoryBean.java:445)        at org.mybatis.spring.SqlSessionFactoryBean.afterPropertiesSet(SqlSessionFactoryBean.java:336)        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1633)        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1570)        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)        at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)        at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)        at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:736)        at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:757)        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:480)        at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:403)        at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306)        at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:106)        at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:5118)        at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5634)        at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:145)        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:899)        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:875)        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:652)        at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1260)        at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:2002)        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)        at java.util.concurrent.FutureTask.run(FutureTask.java:266)        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)        at java.lang.Thread.run(Thread.java:745)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:386)        at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1054)        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:308)        ... 42 more

免责声明:本内容仅代表回答者见解不代表本站观点,请谨慎对待。

版权声明:作者保留权利,不代表本站立场。

回复

使用道具 举报

参与会员1

你的SID写的对吗
回复

使用道具 举报

可能感兴趣的问答

发新帖
TA的信息
  • 会员所属: 注册会员
  • 认证信息: 邮箱认证手机认证
  • 微信访问
  • 手机APP