WebSphere Application Server & Liberty

WebSphere Application Server & Liberty

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only

  • 1.  Socket read timed out while start the server

    Posted 01/23/14 07:56 AM
    Hi,

    We are getting below error while start the Websphere application server. We are using websphere 6.1.0.31 version.

    ------Start of DE processing------ = [1/23/14 17:09:58:605 GMT+05:30] , key = java.sql.SQLException com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper.getPooledCon 1298
    Exception = java.sql.SQLException
    Source = com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper.getPooledCon
    probeid = 1298
    Stack Dump = java.sql.SQLException: Socket read timed out
     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 oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:280)
     at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:207)
     at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPhysicalConnection(OracleConnectionPoolDataSource.java:139)
     at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:88)
     at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:70)
     at com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper$1.run(InternalGenericDataStoreHelper.java:937)
     at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:118)
     at com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper.getPooledConnection(InternalGenericDataStoreHelper.java:974)
     at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooledConnection(WSRdbDataSource.java:1695)
     at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:1256)
     at com.ibm.ejs.j2c.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:1990)
     at com.ibm.ejs.j2c.FreePool.createOrWaitForConnection(FreePool.java:1662)
     at com.ibm.ejs.j2c.PoolManager.reserve(PoolManager.java:2364)
     at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:937)
     at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:611)
     at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:449)
     at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:418)
     at com.ibm.mm.icmrm.mdmanager.object.RMMetadataManagerDB.getDBConnection(RMMetadataManagerDB.java:819)
     at com.ibm.mm.icmrm.mdmanager.object.RMMetadataManagerOra.getObjectMetadata(RMMetadataManagerOra.java:948)
     at com.ibm.mm.icmrm.mdmanager.object.RMMetadataManagerOra.getObjectMetadata(RMMetadataManagerOra.java:930)
     at com.ibm.mm.icmrm.services.migrator.LocalMigrationWorker.executeTask(LocalMigrationWorker.java:140)
     at com.ibm.mm.icmrm.services.impl.j2ee.WorkTaskWrapper.run(WorkTaskWrapper.java:49)
     at com.ibm.ws.asynchbeans.J2EEContext$RunProxy.run(J2EEContext.java:257)
     at java.security.AccessController.doPrivileged(AccessController.java:214)
     at javax.security.auth.Subject.doAs(Subject.java:495)
     at com.ibm.websphere.security.auth.WSSubject.doAs(WSSubject.java:118)
     at com.ibm.ws.asynchbeans.J2EEContext$DoAsProxy.run(J2EEContext.java:328)
     at java.security.AccessController.doPrivileged(AccessController.java:241)
     at com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:1111)
     at com.ibm.ws.asynchbeans.WorkWithExecutionContextImpl.go(WorkWithExecutionContextImpl.java:195)
     at com.ibm.ws.asynchbeans.CJWorkItemImpl.run(CJWorkItemImpl.java:187)
     at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1497)
    Caused by: oracle.net.ns.NetException: Socket read timed out
     at oracle.net.ns.Packet.receive(Packet.java:320)
     at oracle.net.ns.NSProtocol.connect(NSProtocol.java:286)
     at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1042)
     at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:301)

    The abobe error is appearing after reading our "web moduke" which was installed already in websphere. I have checked the network connection between application server to Database server. There is no error. And also I have checked "test Connection" from WAS console and it is connected.

    We are useing oracle version is 11g (11.2.0) and ojdbc5.jar

    So, could you please why this error is everytimes and povide your feedback.

    Regards,
    RSY Narayan


  • 2.  Socket read timed out while start the server

    Posted 01/23/14 10:39 AM

    Hi


      When you say "I have checked the network connection between application server to Database server"


      Have you tested in WAS server and in Oracle server, that when application ask for connection if there is any port in SYN_SENT state?


      A test connection does not ensure that the application that use the pool will work


      Please review.


    regards




     



Related Content