免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 15728 | 回复: 3

[WebLogic] Weblogic The Network Adapter could not establish the connection问题 [复制链接]

论坛徽章:
0
发表于 2008-09-16 10:09 |显示全部楼层
在weblogic813里面建立oracle9的连接池,采用oracle.jdbc.OracleDriver,数据库跟weblogic server在两个城市,测试连接时报如下错误,数据库监听等正常,用PLSQL连接正常.
traceroute:
# traceroute 10.1.5.240-------------------(数据库服务器)
traceroute: Warning: Multiple interfaces found; using 10.67.12.21 @ bge0
traceroute to 10.1.5.240 (10.1.5.240), 30 hops max, 40 byte packets
1  10.67.12.253 (10.67.12.253)  0.896 ms  0.546 ms  0.676 ms
2  10.67.12.146 (10.67.12.146)  0.779 ms  0.913 ms  0.963 ms
3  10.66.1.12 (10.66.1.12)  1.544 ms  1.431 ms  1.465 ms
4  10.218.41.201 (10.218.41.201)  157.496 ms  165.289 ms  144.429 ms
5  10.218.2.30 (10.218.2.30)  184.316 ms  136.311 ms  145.097 ms
6  10.218.2.70 (10.218.2.70)  188.312 ms  212.200 ms  187.219 ms
7  10.1.5.240 (10.1.5.240)  180.834 ms  148.349 ms  145.792 ms

下面为weblogic报错:
<2008-9-12 下午03时18分59秒 CST> <Warning> <JDBC> <BEA-001129> <Received exception while creating connection for pool "scdd-zb2": Io 异常: The Network Adapter could not establish the connection>
<2008-9-12 下午03时18分59秒 CST> <Info> <JDBC> <BEA-001156> <Stack trace associated with message 001129 follows:

java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:274)
        at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:319)
        at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:344)
        at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:14
        at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
        at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:545)
        at weblogic.jdbc.common.internal.ConnectionEnvFactory.makeConnection(ConnectionEnvFactory.java:189)
        at weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(ConnectionEnvFactory.java:124)
        at weblogic.common.resourcepool.ResourcePoolImpl.makeResources(ResourcePoolImpl.java:1145)
        at weblogic.common.resourcepool.ResourcePoolImpl.makeResources(ResourcePoolImpl.java:1079)
        at weblogic.common.resourcepool.ResourcePoolImpl.start(ResourcePoolImpl.java:171)
        at weblogic.jdbc.common.internal.ConnectionPool.doStart(ConnectionPool.java:1001)
        at weblogic.jdbc.common.internal.ConnectionPool.start(ConnectionPool.java:142)
        at weblogic.jdbc.common.internal.ConnectionPoolManager.createAndStartPool(ConnectionPoolManager.java:29
        at weblogic.jdbc.common.internal.JDBCService.addDeployment(JDBCService.java:180)
        at weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(DeploymentTarget.java:331)
        at weblogic.management.mbeans.custom.DeploymentTarget.addDeployments(DeploymentTarget.java:591)
        at weblogic.management.mbeans.custom.DeploymentTarget.updateServerDeployments(DeploymentTarget.java:569)
        at weblogic.management.mbeans.custom.DeploymentTarget.updateDeployments(DeploymentTarget.java:241)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:324)
        at weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl.java:731)
        at weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:710)
        at weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBeanImpl.java:484)
        at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1557)
        at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1525)
        at weblogic.management.internal.RemoteMBeanServerImpl.private_invoke(RemoteMBeanServerImpl.java:985)
        at weblogic.management.internal.RemoteMBeanServerImpl.invoke(RemoteMBeanServerImpl.java:943)
        at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:946)
        at weblogic.management.internal.MBeanProxy.invokeForCachingStub(MBeanProxy.java:481)
        at weblogic.management.configuration.ServerMBean_Stub.updateDeployments(ServerMBean_Stub.java:7351)
        at weblogic.management.deploy.slave.SlaveDeployer.updateServerDeployments(SlaveDeployer.java:1304)
        at weblogic.management.deploy.slave.SlaveDeployer.resume(SlaveDeployer.java:347)
        at weblogic.management.deploy.DeploymentManagerServerLifeCycleImpl.resume(DeploymentManagerServerLifeCycleImpl.java:229)
        at weblogic.t3.srvr.SubsystemManager.resume(SubsystemManager.java:131)
        at weblogic.t3.srvr.T3Srvr.resume(T3Srvr.java:966)
        at weblogic.t3.srvr.T3Srvr.run(T3Srvr.java:361)
        at weblogic.Server.main(Server.java:32)
>
<2008-9-12 下午03时19分00秒 CST> <Error> <JDBC> <BEA-001150> <Connection Pool "scdd-zb2" deployment failed with the following error: 0:Could not create pool connection. The DBMS driver exception was: Io 异常: The Network Adapter could not establish the connection.>
<2008-9-12 下午03时19分00秒 CST> <Info> <JDBC> <BEA-001156> <Stack trace associated with message 001150 follows:

weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: Io 异常: The Network Adapter could not establish the connection
        at weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(ConnectionEnvFactory.java:153)
        at weblogic.common.resourcepool.ResourcePoolImpl.makeResources(ResourcePoolImpl.java:1145)
        at weblogic.common.resourcepool.ResourcePoolImpl.makeResources(ResourcePoolImpl.java:1079)
        at weblogic.common.resourcepool.ResourcePoolImpl.start(ResourcePoolImpl.java:171)
        at weblogic.jdbc.common.internal.ConnectionPool.doStart(ConnectionPool.java:1001)
        at weblogic.jdbc.common.internal.ConnectionPool.start(ConnectionPool.java:142)
        at weblogic.jdbc.common.internal.ConnectionPoolManager.createAndStartPool(ConnectionPoolManager.java:29
        at weblogic.jdbc.common.internal.JDBCService.addDeployment(JDBCService.java:180)
        at weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(DeploymentTarget.java:331)
        at weblogic.management.mbeans.custom.DeploymentTarget.addDeployments(DeploymentTarget.java:591)
        at weblogic.management.mbeans.custom.DeploymentTarget.updateServerDeployments(DeploymentTarget.java:569)
        at weblogic.management.mbeans.custom.DeploymentTarget.updateDeployments(DeploymentTarget.java:241)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:324)
        at weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl.java:731)
        at weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:710)
        at weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBeanImpl.java:484)
        at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1557)
        at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1525)
        at weblogic.management.internal.RemoteMBeanServerImpl.private_invoke(RemoteMBeanServerImpl.java:985)
        at weblogic.management.internal.RemoteMBeanServerImpl.invoke(RemoteMBeanServerImpl.java:943)
        at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:946)
        at weblogic.management.internal.MBeanProxy.invokeForCachingStub(MBeanProxy.java:481)
        at weblogic.management.configuration.ServerMBean_Stub.updateDeployments(ServerMBean_Stub.java:7351)
        at weblogic.management.deploy.slave.SlaveDeployer.updateServerDeployments(SlaveDeployer.java:1304)
        at weblogic.management.deploy.slave.SlaveDeployer.resume(SlaveDeployer.java:347)
        at weblogic.management.deploy.DeploymentManagerServerLifeCycleImpl.resume(DeploymentManagerServerLifeCycleImpl.java:229)
        at weblogic.t3.srvr.SubsystemManager.resume(SubsystemManager.java:131)
        at weblogic.t3.srvr.T3Srvr.resume(T3Srvr.java:966)
        at weblogic.t3.srvr.T3Srvr.run(T3Srvr.java:361)
        at weblogic.Server.main(Server.java:32)
--------------- nested within: ------------------
weblogic.common.ResourceException: 0:Could not create pool connection. The DBMS driver exception was: Io 异常: The Network Adapter could not establish the connection - with nested exception:
[weblogic.common.ResourceException: Could not create pool connection. The DBMS driver exception was: Io 异常: The Network Adapter could not establish the connection]
        at weblogic.common.resourcepool.ResourcePoolImpl.makeResources(ResourcePoolImpl.java:1224)
        at weblogic.common.resourcepool.ResourcePoolImpl.makeResources(ResourcePoolImpl.java:1079)
        at weblogic.common.resourcepool.ResourcePoolImpl.start(ResourcePoolImpl.java:171)
        at weblogic.jdbc.common.internal.ConnectionPool.doStart(ConnectionPool.java:1001)
        at weblogic.jdbc.common.internal.ConnectionPool.start(ConnectionPool.java:142)
        at weblogic.jdbc.common.internal.ConnectionPoolManager.createAndStartPool(ConnectionPoolManager.java:29
        at weblogic.jdbc.common.internal.JDBCService.addDeployment(JDBCService.java:180)
        at weblogic.management.mbeans.custom.DeploymentTarget.addDeployment(DeploymentTarget.java:331)
        at weblogic.management.mbeans.custom.DeploymentTarget.addDeployments(DeploymentTarget.java:591)
        at weblogic.management.mbeans.custom.DeploymentTarget.updateServerDeployments(DeploymentTarget.java:569)
        at weblogic.management.mbeans.custom.DeploymentTarget.updateDeployments(DeploymentTarget.java:241)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:324)
        at weblogic.management.internal.DynamicMBeanImpl.invokeLocally(DynamicMBeanImpl.java:731)
        at weblogic.management.internal.DynamicMBeanImpl.invoke(DynamicMBeanImpl.java:710)
        at weblogic.management.internal.ConfigurationMBeanImpl.invoke(ConfigurationMBeanImpl.java:484)
        at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1557)
        at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1525)
        at weblogic.management.internal.RemoteMBeanServerImpl.private_invoke(RemoteMBeanServerImpl.java:985)
        at weblogic.management.internal.RemoteMBeanServerImpl.invoke(RemoteMBeanServerImpl.java:943)
        at weblogic.management.internal.MBeanProxy.invoke(MBeanProxy.java:946)
        at weblogic.management.internal.MBeanProxy.invokeForCachingStub(MBeanProxy.java:481)
        at weblogic.management.configuration.ServerMBean_Stub.updateDeployments(ServerMBean_Stub.java:7351)
        at weblogic.management.deploy.slave.SlaveDeployer.updateServerDeployments(SlaveDeployer.java:1304)
        at weblogic.management.deploy.slave.SlaveDeployer.resume(SlaveDeployer.java:347)
        at weblogic.management.deploy.DeploymentManagerServerLifeCycleImpl.resume(DeploymentManagerServerLifeCycleImpl.java:229)
        at weblogic.t3.srvr.SubsystemManager.resume(SubsystemManager.java:131)
        at weblogic.t3.srvr.T3Srvr.resume(T3Srvr.java:966)
        at weblogic.t3.srvr.T3Srvr.run(T3Srvr.java:361)
        at weblogic.Server.main(Server.java:32)

论坛徽章:
0
发表于 2008-09-16 10:13 |显示全部楼层
这是ping的信息
# ping -s 10.1.5.240
PING 10.1.5.240: 56 data bytes
64 bytes from 10.1.5.240: icmp_seq=0. time=86. ms
64 bytes from 10.1.5.240: icmp_seq=1. time=93. ms
64 bytes from 10.1.5.240: icmp_seq=2. time=128. ms
64 bytes from 10.1.5.240: icmp_seq=3. time=131. ms
64 bytes from 10.1.5.240: icmp_seq=4. time=200. ms
64 bytes from 10.1.5.240: icmp_seq=5. time=163. ms
64 bytes from 10.1.5.240: icmp_seq=6. time=161. ms
64 bytes from 10.1.5.240: icmp_seq=7. time=115. ms
64 bytes from 10.1.5.240: icmp_seq=8. time=114. ms
64 bytes from 10.1.5.240: icmp_seq=9. time=186. ms
^C
----10.1.5.240 PING Statistics----
10 packets transmitted, 10 packets received, 0% packet loss
round-trip (ms)  min/avg/max = 86/137/200

论坛徽章:
0
发表于 2008-09-17 08:11 |显示全部楼层
HOHO 已经解决了

论坛徽章:
0
发表于 2009-02-04 16:08 |显示全部楼层
解决方法:
1.在连接池配置里设置Login Delay为1秒
2.更换数据库driver,以前是oracle.jdbc.OracleDriver,更换成weblogic.jdbc.oracle.OracleDriver,更改后运行稳定
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP