oracle数据库连接不上

bi版本：Build: 2022-04-22 18:07:47  Version:9.7.72810.22175

Oracle数据库版本 Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

使用内置连接驱动，SID连接，能ping的通数据库，用Navicat软件能连接上，正常访问查询。BI这边链接就报错，原因找不到

version: 2022-04-22 18:10:57

packageinfo: Hotfix_SmartbiV97_20220420 

 

 

连接池初始化失败:SQL错误:The Network Adapter could not establish the connection

at smartbi.freequery.basicdata.MetaDataServiceImpl.testConnection(MetaDataServiceImpl.java:610)

at ...(...)

at smartbi.connectionpool.SmartbiPoolableConnection.doGetConnection(SmartbiPoolableConnection.java:82)

Caused by: java.sql.SQLException: SQL错误:The Network Adapter could not establish the connection

at smartbi.connectionpool.SmartbiPoolableConnection.doGetConnection(SmartbiPoolableConnection.java:82)

at smartbi.connectionpool.ConnectionPool.doGetConnection(ConnectionPool.java:720)

at smartbi.connectionpool.ConnectionPool.driverConnect(ConnectionPool.java:525)

at smartbi.connectionpool.ConnectionPool.getConnection(ConnectionPool.java:817)

at smartbi.connectionpool.ConnectionPool.getConnection(ConnectionPool.java:781)

at smartbi.freequery.basicdata.MetaDataServiceImpl.testConnection(MetaDataServiceImpl.java:514)

at smartbi.freequery.client.datasource.DataSourceService.testConnectionList(DataSourceService.java:282)

at sun.reflect.GeneratedMethodAccessor2155.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at smartbi.framework.rmi.ClientService.execute(Smartbi:131)

at smartbi.framework.rmi.RMIServlet.processExecute(RMIServlet.java:249)

at smartbi.framework.rmi.RMIServlet.doPost(RMIServlet.java:178)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:652)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:733)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

at smartbi.extension.ExtensionFilter$2.doFilter(ExtensionFilter.java:192)

at smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:174)

at smartbi.security.patch.PatchFilter.doFilter(PatchFilter.java:77)

at smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:174)

at smartbi.extension.ExtensionFilter.doFilterInternal(ExtensionFilter.java:205)

at smartbi.extension.ExtensionFilter.doFilter(ExtensionFilter.java:83)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

at smartbi.framework.rmi.TransactionFilter.doFilter(Smartbi:71)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

at smartbi.freequery.filter.GZIPFilter.doFilter(GZIPFilter.java:236)

at smartbi.freequery.filter.Filter.doFilter(Filter.java:33)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

at smartbi.freequery.filter.ExceptionResponseFilter.doFilter(ExceptionResponseFilter.java:77)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

at smartbi.freequery.filter.CheckIsLoggedFilter.doFilter(CheckIsLoggedFilter.java:219)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

at smartbi.freequery.filter.CheckRefererFilter.doFilter(CheckRefererFilter.java:45)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

at smartbi.freequery.filter.CheckHttpMethodFilter.doFilter(CheckHttpMethodFilter.java:62)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

at smartbi.freequery.filter.TraceFilter.doFilter(TraceFilter.java:61)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

at smartbi.framework.RedisSessionFilter.doFilter(Smartbi:137)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:544)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81)

at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:698)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:353)

at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:616)

at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)

at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:831)

at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1629)

at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.lang.Thread.run(Thread.java:748)

Caused by: SQL错误:The Network Adapter could not establish the connection

at smartbi.connectionpool.ConnectionPool$5.createConnectionInner(ConnectionPool.java:1249)

at smartbi.connectionpool.ConnectionPool$5.createConnection(ConnectionPool.java:1285)

at smartbi.connectionpool.SmartbiPoolableConnectionFactory.makeObjectInternal(SmartbiPoolableConnectionFactory.java:145)

at smartbi.connectionpool.SmartbiPoolableConnection.doGetConnection(SmartbiPoolableConnection.java:72)

... 69 more

Caused by: java.sql.SQLException: The Network Adapter could not establish the connection

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:412)

at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:531)

at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:221)

at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)

at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:503)

at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)

at smartbi.connectionpool.ConnectionPool$5.createConnectionInner(ConnectionPool.java:1243)

... 72 more

Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection

at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:359)

at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:422)

at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:672)

at oracle.net.ns.NSProtocol.connect(NSProtocol.java:237)

at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1042)

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:301)

... 78 more

Caused by: java.net.NoRouteToHostException: 没有到主机的路由 (Host unreachable)

at java.net.PlainSocketImpl.socketConnect(Native Method)

at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)

at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)

at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)

at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)

at java.net.Socket.connect(Socket.java:589)

at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:141)

at oracle.net.nt.ConnOption.connect(ConnOption.java:123)

at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:337)

... 83 more

 

 

 

可网上资源检查防火墙是否没关闭：https://blog.csdn.net/Andy86666/article/details/125173894
https://blog.csdn.net/weixin_42578567/article/details/126225523