ORA-12152: TNS:unable To Send Break Message During Inserts (Doc ID 1942951.1)

ORA-12152: TNS:unable To Send Break Message During Inserts (Doc ID 1942951.1)

To Bottom

---

In this Document   Symptoms   Cause   Solution   References   APPLIES TO: JDBC - Version 11.2.0.2.0 and later Oracle Net Services - Version 11.2.0.4 to 11.2.0.4 [Release 11.2] Information in this document applies to any platform. SYMPTOMS Application reports continuously the following error message while trying to insert data into the database: JDBC error reported: (SQLState = 66000) - java.sql.SQLException: ORA-12152: TNS:unable to send break message at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:759) at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:661) at oracle.jdbc.driver.T2CPreparedStatement.executeForDescribe(T2CPreparedStatement.java:542) at oracle.jdbc.driver.T2CPreparedStatement.executeForRows(T2CPreparedStatement.java:725) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3657) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350) CAUSE   This issue can also be reproduced with SQL*Plus, so it is not particular to the JDBC driver. Underlying layer / TCP network has disconnected the client-server communication link (TCP socket). In this particular case, it is caused by a faulty ethernet card resulting in ORA-12152: TNS:unable to send break message.   SOLUTION Replace the client faulty ethernet card     网络层面测试： [root@lixora ~]# ping -D -S 1000 -l 65535 -f 134.26.84.25    --- 134.26.84.25 ping statistics ---                                                                                                          325065 packets transmitted, 68862 received, 78% packet loss, time 3389ms                                                                       rtt min/avg/max/mdev = 8.565/33.190/42.276/2.361 ms, pipe 4990, ipg/ewma 0.010/32.708 ms