was连接oracle11g rac时报错SQL 状态:08006,错误码:17,002。

我采用的中间件是was 7.0.0.29


在通过oracle11g scan ip连接数据库时报错误:
[14-3-20 14:08:28:810 CST] 0000001e SystemErr     R java.sql.SQLRecoverableException: IO 错误: The Network Adapter could not establish the connectionDSRA0010E: SQL 状态:08006,错误码:17,002。
[14-3-20 14:08:28:810 CST] 0000001e SystemErr     R
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:458)
[14-3-20 14:08:28:810 CST] 0000001e SystemErr     R
at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:546)
[14-3-20 14:08:28:810 CST] 0000001e SystemErr     R
at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:236)
[14-3-20 14:08:28:810 CST] 0000001e SystemErr     R
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
[14-3-20 14:08:28:810 CST] 0000001e SystemErr     R
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
[14-3-20 14:08:28:810 CST] 0000001e SystemErr     R
at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:280)
[14-3-20 14:08:28:810 CST] 0000001e SystemErr     R
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:207)
[14-3-20 14:08:28:811 CST] 0000001e SystemErr     R
at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPhysicalConnection(OracleConnectionPoolDataSource.java:139)
[14-3-20 14:08:28:811 CST] 0000001e SystemErr     R
at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:88)
[14-3-20 14:08:28:811 CST] 0000001e SystemErr     R
at com.ibm.ws.rsadapter.DSConfigurationHelper$2.run(DSConfigurationHelper.java:1705)
[14-3-20 14:08:28:811 CST] 0000001e SystemErr     R
at com.ibm.ws.security.auth.ContextManagerImpl.runAs(ContextManagerImpl.java:5305)
[14-3-20 14:08:28:811 CST] 0000001e SystemErr     R
at com.ibm.ws.security.auth.ContextManagerImpl.runAsSystem(ContextManagerImpl.java:5483)
[14-3-20 14:08:28:811 CST] 0000001e SystemErr     R
at com.ibm.ws.security.core.SecurityContext.runAsSystem(SecurityContext.java:255)
[14-3-20 14:08:28:811 CST] 0000001e SystemErr     R
at com.ibm.ws.rsadapter.DSConfigurationHelper$3.run(DSConfigurationHelper.java:1721)
[14-3-20 14:08:28:811 CST] 0000001e SystemErr     R
at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:118)
[14-3-20 14:08:28:811 CST] 0000001e SystemErr     R
at com.ibm.ws.rsadapter.DSConfigurationHelper.getPooledConnection(DSConfigurationHelper.java:1733)
[14-3-20 14:08:28:811 CST] 0000001e SystemErr     R
at com.ibm.ws.rsadapter.DSConfigurationHelper.getPooledConnection(DSConfigurationHelper.java:1628)
[14-3-20 14:08:28:811 CST] 0000001e SystemErr     R
at com.ibm.ws.rsadapter.DSConfigurationHelper.getConnectionFromDSOrPooledDS(DSConfigurationHelper.java:3371)
[14-3-20 14:08:28:811 CST] 0000001e SystemErr     R
at com.ibm.ws.rsadapter.DSConfigurationHelper.getConnectionFromDSOrPooledDS(DSConfigurationHelper.java:3246)
[14-3-20 14:08:28:811 CST] 0000001e SystemErr     R
at com.ibm.ws.rsadapter.DSConfigurationHelper.testConnectionForGUI(DSConfigurationHelper.java:4106)
[14-3-20 14:08:28:811 CST] 0000001e SystemErr     R
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[14-3-20 14:08:28:811 CST] 0000001e SystemErr     R
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48)
[14-3-20 14:08:28:811 CST] 0000001e SystemErr     R
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[14-3-20 14:08:28:811 CST] 0000001e SystemErr     R
at java.lang.reflect.Method.invoke(Method.java:600)
[14-3-20 14:08:28:811 CST] 0000001e SystemErr     R
at com.ibm.ws.management.DataSourceConfigHelperMBean.testConnectionToDataSource2(DataSourceConfigHelperMBean.java:556)
[14-3-20 14:08:28:811 CST] 0000001e SystemErr     R
at com.ibm.ws.management.DataSourceConfigHelperMBean.testConnection(DataSourceConfigHelperMBean.java:484)
[14-3-20 14:08:28:812 CST] 0000001e SystemErr     R
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[14-3-20 14:08:28:812 CST] 0000001e SystemErr     R
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:48)
[14-3-20 14:08:28:812 CST] 0000001e SystemErr     R
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[14-3-20 14:08:28:812 CST] 0000001e SystemErr     R
at java.lang.reflect.Method.invoke(Method.java:600)
[14-3-20 14:08:28:812 CST] 0000001e SystemErr     R
at sun.reflect.misc.Trampoline.invoke(MethodUtil.java:57)
[14-3-20 14:08:28:812 CST] 0000001e SystemErr     R
at sun.reflect.GeneratedMethodAccessor29.invoke(Unknown Source)
[14-3-20 14:08:28:812 CST] 0000001e SystemErr     R
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[14-3-20 14:08:28:812 CST] 0000001e SystemErr     R
at java.lang.reflect.Method.invoke(Method.java:600)
[14-3-20 14:08:28:812 CST] 0000001e SystemErr     R
at sun.reflect.misc.MethodUtil.invoke(MethodUtil.java:260)
[14-3-20 14:08:28:812 CST] 0000001e SystemErr     R
at javax.management.modelmbean.RequiredModelMBean$4.run(RequiredModelMBean.java:1137)
[14-3-20 14:08:28:812 CST] 0000001e SystemErr     R
at java.security.AccessController.doPrivileged(AccessController.java:250)
[14-3-20 14:08:28:812 CST] 0000001e SystemErr     R
at com.ibm.oti.security.CheckedAccessControlContext.securityCheck(CheckedAccessControlContext.java:30)
[14-3-20 14:08:28:812 CST] 0000001e SystemErr     R
at sun.misc.JavaSecurityAccessWrapper.doIntersectionPrivilege(JavaSecurityAccessWrapper.java:29)
[14-3-20 14:08:28:812 CST] 0000001e SystemErr     R
at javax.management.modelmbean.RequiredModelMBean.invokeMethod(RequiredModelMBean.java:1131)
[14-3-20 14:08:28:812 CST] 0000001e SystemErr     R
at javax.management.modelmbean.RequiredModelMBean.invoke(RequiredModelMBean.java:984)
[14-3-20 14:08:28:812 CST] 0000001e SystemErr     R
at com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:836)
[14-3-20 14:08:28:812 CST] 0000001e SystemErr     R
at com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:762)
[14-3-20 14:08:28:812 CST] 0000001e SystemErr     R
at com.ibm.ws.management.AdminServiceImpl$1.run(AdminServiceImpl.java:1331)
[14-3-20 14:08:28:813 CST] 0000001e SystemErr     R
at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:118)
[14-3-20 14:08:28:813 CST] 0000001e SystemErr     R
at com.ibm.ws.management.AdminServiceImpl.invoke(AdminServiceImpl.java:1224)
[14-3-20 14:08:28:813 CST] 0000001e SystemErr     R
at com.ibm.ws.management.commands.AdminServiceCommands$InvokeCmd.execute(AdminServiceCommands.java:251)
[14-3-20 14:08:28:813 CST] 0000001e SystemErr     R
at com.ibm.ws.console.core.mbean.MBeanHelper.invoke(MBeanHelper.java:239)
[14-3-20 14:08:28:813 CST] 0000001e SystemErr     R
at com.ibm.ws.console.core.mbean.ResourceMBeanHelper.testNode(ResourceMBeanHelper.java:860)
[14-3-20 14:08:28:813 CST] 0000001e SystemErr     R
at com.ibm.ws.console.core.mbean.ResourceMBeanHelper.testConnection(ResourceMBeanHelper.java:292)
[14-3-20 14:08:28:813 CST] 0000001e SystemErr     R
at com.ibm.ws.console.resources.database.jdbc.DataSourceCollectionAction.execute(DataSourceCollectionAction.java:369)
[14-3-20 14:08:28:813 CST] 0000001e SystemErr     R
at org.apache.struts.action.RequestProcessor.processActionPerform(Unknown Source)
[14-3-20 14:08:28:813 CST] 0000001e SystemErr     R
at org.apache.struts.action.RequestProcessor.process(Unknown Source)
[14-3-20 14:08:28:813 CST] 0000001e SystemErr     R
at org.apache.struts.action.ActionServlet.process(Unknown Source)
[14-3-20 14:08:28:813 CST] 0000001e SystemErr     R
at org.apache.struts.action.ActionServlet.doPost(Unknown Source)
[14-3-20 14:08:28:813 CST] 0000001e SystemErr     R
at javax.servlet.http.HttpServlet.service(HttpServlet.java:738)
[14-3-20 14:08:28:813 CST] 0000001e SystemErr     R
at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
[14-3-20 14:08:28:813 CST] 0000001e SystemErr     R
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1661)
[14-3-20 14:08:28:813 CST] 0000001e SystemErr     R
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1602)
[14-3-20 14:08:28:813 CST] 0000001e SystemErr     R
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:113)
[14-3-20 14:08:28:814 CST] 0000001e SystemErr     R
at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:80)
[14-3-20 14:08:28:814 CST] 0000001e SystemErr     R
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:908)
[14-3-20 14:08:28:814 CST] 0000001e SystemErr     R
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:939)
[14-3-20 14:08:28:814 CST] 0000001e SystemErr     R
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:507)
[14-3-20 14:08:28:814 CST] 0000001e SystemErr     R
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:181)
[14-3-20 14:08:28:814 CST] 0000001e SystemErr     R
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:374)
[14-3-20 14:08:28:814 CST] 0000001e SystemErr     R
at org.apache.struts.action.RequestProcessor.doForward(Unknown Source)
[14-3-20 14:08:28:814 CST] 0000001e SystemErr     R
at org.apache.struts.tiles.TilesRequestProcessor.doForward(Unknown Source)
[14-3-20 14:08:28:814 CST] 0000001e SystemErr     R
at org.apache.struts.action.RequestProcessor.processForwardConfig(Unknown Source)
[14-3-20 14:08:28:814 CST] 0000001e SystemErr     R
at org.apache.struts.tiles.TilesRequestProcessor.processForwardConfig(Unknown Source)
[14-3-20 14:08:28:814 CST] 0000001e SystemErr     R
at com.ibm.isclite.container.controller.InformationController.processForwardConfig(InformationController.java:218)
[14-3-20 14:08:28:814 CST] 0000001e SystemErr     R
at org.apache.struts.action.RequestProcessor.process(Unknown Source)
[14-3-20 14:08:28:814 CST] 0000001e SystemErr     R
at org.apache.struts.action.ActionServlet.process(Unknown Source)
[14-3-20 14:08:28:814 CST] 0000001e SystemErr     R
at org.apache.struts.action.ActionServlet.doPost(Unknown Source)
[14-3-20 14:08:28:814 CST] 0000001e SystemErr     R
at javax.servlet.http.HttpServlet.service(HttpServlet.java:738)
[14-3-20 14:08:28:814 CST] 0000001e SystemErr     R
at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
[14-3-20 14:08:28:814 CST] 0000001e SystemErr     R
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1661)
[14-3-20 14:08:28:814 CST] 0000001e SystemErr     R
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1602)
[14-3-20 14:08:28:815 CST] 0000001e SystemErr     R
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:149)
[14-3-20 14:08:28:815 CST] 0000001e SystemErr     R
at com.ibm.ws.console.core.servlet.WSCUrlFilter.setUpCommandAssistence(WSCUrlFilter.java:970)
[14-3-20 14:08:28:815 CST] 0000001e SystemErr     R
at com.ibm.ws.console.core.servlet.WSCUrlFilter.continueStoringTaskState(WSCUrlFilter.java:504)
[14-3-20 14:08:28:815 CST] 0000001e SystemErr     R
at com.ibm.ws.console.core.servlet.WSCUrlFilter.doFilter(WSCUrlFilter.java:325)
[14-3-20 14:08:28:815 CST] 0000001e SystemErr     R
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)
[14-3-20 14:08:28:815 CST] 0000001e SystemErr     R
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:125)
[14-3-20 14:08:28:815 CST] 0000001e SystemErr     R
at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:80)
[14-3-20 14:08:28:815 CST] 0000001e SystemErr     R
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:908)
[14-3-20 14:08:28:815 CST] 0000001e SystemErr     R
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:939)
[14-3-20 14:08:28:815 CST] 0000001e SystemErr     R
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:507)
[14-3-20 14:08:28:815 CST] 0000001e SystemErr     R
at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:181)
[14-3-20 14:08:28:815 CST] 0000001e SystemErr     R
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:91)
[14-3-20 14:08:28:815 CST] 0000001e SystemErr     R
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:878)
[14-3-20 14:08:28:815 CST] 0000001e SystemErr     R
at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1592)
[14-3-20 14:08:28:815 CST] 0000001e SystemErr     R
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:191)
[14-3-20 14:08:28:815 CST] 0000001e SystemErr     R
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:453)
[14-3-20 14:08:28:815 CST] 0000001e SystemErr     R
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:515)
[14-3-20 14:08:28:815 CST] 0000001e SystemErr     R
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:306)
[14-3-20 14:08:28:816 CST] 0000001e SystemErr     R
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:84)
[14-3-20 14:08:28:816 CST] 0000001e SystemErr     R
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:175)
[14-3-20 14:08:28:816 CST] 0000001e SystemErr     R
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
[14-3-20 14:08:28:816 CST] 0000001e SystemErr     R
at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
[14-3-20 14:08:28:816 CST] 0000001e SystemErr     R
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
[14-3-20 14:08:28:816 CST] 0000001e SystemErr     R
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
[14-3-20 14:08:28:816 CST] 0000001e SystemErr     R
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)
[14-3-20 14:08:28:816 CST] 0000001e SystemErr     R
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)
[14-3-20 14:08:28:816 CST] 0000001e SystemErr     R
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1656)
[14-3-20 14:08:28:816 CST] 0000001e SystemErr     R Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection
[14-3-20 14:08:28:816 CST] 0000001e SystemErr     R
at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:392)
[14-3-20 14:08:28:816 CST] 0000001e SystemErr     R
at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:434)
[14-3-20 14:08:28:817 CST] 0000001e SystemErr     R
at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:687)
[14-3-20 14:08:28:817 CST] 0000001e SystemErr     R
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:343)
[14-3-20 14:08:28:817 CST] 0000001e SystemErr     R
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1102)
[14-3-20 14:08:28:817 CST] 0000001e SystemErr     R
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:320)
[14-3-20 14:08:28:817 CST] 0000001e SystemErr     R
... 104 more
[14-3-20 14:08:28:817 CST] 0000001e SystemErr     R Caused by: java.net.SocketTimeoutException: connect timed out
[14-3-20 14:08:28:817 CST] 0000001e SystemErr     R
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:370)
[14-3-20 14:08:28:817 CST] 0000001e SystemErr     R
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:232)
[14-3-20 14:08:28:817 CST] 0000001e SystemErr     R
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:219)
[14-3-20 14:08:28:817 CST] 0000001e SystemErr     R
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
[14-3-20 14:08:28:817 CST] 0000001e SystemErr     R
at java.net.Socket.connect(Socket.java:528)
[14-3-20 14:08:28:817 CST] 0000001e SystemErr     R
at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:150)
[14-3-20 14:08:28:817 CST] 0000001e SystemErr     R
at oracle.net.nt.ConnOption.connect(ConnOption.java:133)
[14-3-20 14:08:28:817 CST] 0000001e SystemErr     R
at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:370)
[14-3-20 14:08:28:818 CST] 0000001e SystemErr     R
... 109 more
参与9

提问者

zjyshmily
系统工程师河南拓普网络计算机工程有限公司

相关问题

问题状态

  • 发布时间:2014-03-21
  • 关注会员:1 人
  • 问题浏览:27022
  • 最近回答:2014-03-25
  • X社区推广