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

7同行回答

hbhe0316hbhe0316数据库管理员IBM
这个错误就是两个机器之间互联不上:1.确定oracle的tns是否处于开启状态,进入oracle的操作系统,su - oracle,#lsnrctl status查看是否是成功的状态,2.查看防火墙是否关闭3.查看IP地址、库名以及用户密码是否都正确。...显示全部
这个错误就是两个机器之间互联不上:1.确定oracle的tns是否处于开启状态,进入oracle的操作系统,su - oracle,#lsnrctl status查看是否是成功的状态,2.查看防火墙是否关闭3.查看IP地址、库名以及用户密码是否都正确。收起
IT分销/经销 · 2014-03-21
浏览10778
zjyshmilyzjyshmily系统工程师河南拓普网络计算机工程有限公司
再次多谢各位,我的问题得到了解决,原因是vip解析问题,也可以说是vip与was中间件的网络不通显示全部
再次多谢各位,我的问题得到了解决,原因是vip解析问题,也可以说是vip与was中间件的网络不通收起
政府机关 · 2014-03-25
浏览9578
vesaavesaa技术总监保密
这个是RAC连接字符串的问题, 前几天刚解决过。    RAC的连接字符串和普通的 连SID的字符串不一样。 他走的是统一的一个RAC服务名,改过来就行了。显示全部
这个是RAC连接字符串的问题, 前几天刚解决过。

    RAC的连接字符串和普通的 连SID的字符串不一样。 他走的是统一的一个RAC服务名,改过来就行了。收起
互联网服务 · 2014-03-25
浏览10271
niuphniuphit技术咨询顾问IBM
重启一下Nodeagent试试显示全部
重启一下Nodeagent试试收起
互联网服务 · 2014-03-24
浏览9583
zhwshzhwsh其它SK
The Network Adapter could not establish the connectionDSRA0010E: SQL 状态:08006,错误码:17,002。网络异常。显示全部
The Network Adapter could not establish the connectionDSRA0010E: SQL 状态:08006,错误码:17,002。
网络异常。收起
互联网服务 · 2014-03-22
浏览9817
泊涯泊涯系统测试工程师高伟达公司
是不是JDBC配置有问题显示全部
是不是JDBC配置有问题收起
银行 · 2014-03-21
浏览10323
huangdoshuangdosCTO深圳乐凯撒股份有限公司
这个是网络不通,你确定 WAS服务器上面能ping 通数据库服务器?显示全部
这个是网络不通,你确定 WAS服务器上面能ping 通数据库服务器?收起
互联网服务 · 2014-03-21
浏览9827

提问者

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

相关问题

问题状态

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