Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

JDBC Oracle error: java.sql.SQLException: ORA-12592: TNS:bad packet

I am getting below error while fetching record from ResultSet.Please could you help to resole this sissue.

java.sql.SQLException: ORA-12592: TNS:bad packet
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.ava:225)
    at oracle.jdbc.driver.T4CPreparedStatement.fetch(T4CPreparedStatement.java:1066)
    at oracle.jdbc.driver.OracleStatement.fetchMoreRows(OracleStatement.java:3716)
    at oracle.jdbc.driver.InsensitiveScrollableResultSet.fetchMoreRows(InsensitiveScrollableResultSet.java:1015)
    at oracle.jdbc.driver.InsensitiveScrollableResultSet.absoluteInternal(InsensitiveScrollableResultSet.java:979)
    at oracle.jdbc.driver.InsensitiveScrollableResultSet.next(InsensitiveScrollableResultSet.java:579)
    at sun.reflect.GeneratedMethodAccessor36.invoke(Unknown Source)
like image 278
user5773508 Avatar asked Sep 20 '25 07:09

user5773508


1 Answers

Root Cause:

  • Due to a defect or configuration issue in the operating environment.

  • May be a firewall was intermittently interrupting database requests on the network which led to this exception.

    More help: http://www.tek-tips.com/viewthread.cfm?qid=1673903

like image 173
coderpc Avatar answered Sep 22 '25 04:09

coderpc