Firewalls can ping but fail to access Oracle instability

Our IDC core data area to the DMZ in the Thursday has experienced a very strange failure.

Although I have judged the issue of non-Oracle from the outset, since the application of multiple Oracle databases connecting to the core data area has the same problem, if more than three Oracle can think of such a serious problem at the same time, I think Oracle should also be "out of business". However, the application of colleagues can see that there is a very suspicious of Oracle problems, coupled with links to ping, and finally through the replacement method to determine the firewall problem, and finally come to an end. The process lasted from 4:00 the same day to the next day 8:00, is thrilling.

Symptom: The application reported the following error:

SQL state [NULL]; Error code [17410]; No more data to read from socket; Nested exception is java.sql.SQLException:No the more data to read from socket

Java.sql.SQLException:No more data to read from socket

At Oracle.jdbc.driver.DatabaseError.throwSqlException (databaseerror.java:112)

At Oracle.jdbc.driver.DatabaseError.throwSqlException (databaseerror.java:146)

At Oracle.jdbc.driver.DatabaseError.throwSqlException (databaseerror.java:208)

At Oracle.jdbc.driver.T4CMAREngine.unmarshalUB1 (t4cmarengine.java:1118)

At Oracle.jdbc.driver.T4CMAREngine.unmarshalSB1 (t4cmarengine.java:1070)

At Oracle.jdbc.driver.T4C8Oall.receive (t4c8oall.java:478)

At Oracle.jdbc.driver.T4CPreparedStatement.doOall8 (t4cpreparedstatement.java:216)

At Oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe (t4cpreparedstatement.java:799)

At Oracle.jdbc.driver.OracleStatement.executeMaybeDescribe (oraclestatement.java:1037)

At Oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe (t4cpreparedstatement.java:839)

At Oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout (oraclestatement.java:1132)

At Oracle.jdbc.driver.OraclePreparedStatement.executeInternal (oraclepreparedstatement.java:3316)

At Oracle.jdbc.driver.OraclePreparedStatement.executeQuery (oraclepreparedstatement.java:3361)

At Weblogic.jdbc.wrapper.PreparedStatement.executeQuery (preparedstatement.java:100)

At Org.hibernate.jdbc.AbstractBatcher.getResultSet (abstractbatcher.java:120)

At Org.hibernate.loader.Loader.getResultSet (loader.java:1272)

At Org.hibernate.loader.Loader.doQuery (loader.java:391)

At Org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections (loader.java:218)

At Org.hibernate.loader.Loader.doList (loader.java:1593)

At Org.hibernate.loader.Loader.list (loader.java:1577)

At Org.hibernate.loader.hql.QueryLoader.list (queryloader.java:395)

At Org.hibernate.hql.ast.QueryTranslatorImpl.list (querytranslatorimpl.java:271)

At Org.hibernate.impl.SessionImpl.list (sessionimpl.java:844)

At Org.hibernate.impl.QueryImpl.list (queryimpl.java:74)

At Cn.gov.zjport.persistence.core.hibernate.persistencehibernateimpl$1.doinhibernate ( PERSISTENCEHIBERNATEIMPL.JAVA:96)

At Org.springframework.orm.hibernate3.HibernateTemplate.execute (hibernatetemplate.java:366)

At Org.springframework.orm.hibernate3.HibernateTemplate.execute (hibernatetemplate.java:334)

At Cn.gov.zjport.persistence.core.hibernate.PersistenceHibernateImpl.query (persistencehibernateimpl.java:93)

At Cn.gov.zjport.normandy.dao.persistence.base.impl.BaseDAOImpl.getListByFilter (basedaoimpl.java:109)

At Sun.reflect.GeneratedMethodAccessor466.invoke (Unknown Source)

At Sun.reflect.DelegatingMethodAccessorImpl.invoke (delegatingmethodaccessorimpl.java:43)

At Java.lang.reflect.Method.invoke (method.java:618)

At Org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection (aoputils.java:287)

At Org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint (Reflectivemethodinvocation.java : 181)

At Org.springframework.aop.framework.ReflectiveMethodInvocation.proceed (reflectivemethodinvocation.java:148)

At Cn.gov.zjport.houston.service.base.cache.interceptor.ParaCacheInterceptor.invoke (Paracacheinterceptor.java : 68)

At Org.springframework.aop.framework.ReflectiveMethodInvocation.proceed (reflectivemethodinvocation.java:170)

At Org.springframework.transaction.interceptor.TransactionInterceptor.invoke (transactioninterceptor.java:96)

At Org.springframework.aop.framework.ReflectiveMethodInvocation.proceed (reflectivemethodinvocation.java:170)

At Org.springframework.aop.framework.JdkDynamicAopProxy.invoke (jdkdynamicaopproxy.java:176)

At $Proxy 595.getListByFilter (Unknown Source)

At Cn.gov.zjport.normandy.service.exchange.impl.ImbackDeclareServiceImpl.queryImbackDeclare ( IMBACKDECLARESERVICEIMPL.JAVA:65)

At Sun.reflect.GeneratedMethodAccessor465.invoke (Unknown Source)

At Sun.reflect.DelegatingMethodAccessorImpl.invoke (delegatingmethodaccessorimpl.java:43)

At Java.lang.reflect.Method.invoke (method.java:618)

At Org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection (aoputils.java:287)

At Org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint (Reflectivemethodinvocation.java : 181)

At Org.springframework.aop.framework.ReflectiveMethodInvocation.proceed (reflectivemethodinvocation.java:148)

At Cn.gov.zjport.houston.service.base.cache.interceptor.ParaCacheInterceptor.invoke (Paracacheinterceptor.java : 68)