7 Replies Latest reply: May 25, 2010 8:27 AM by Jean de Lavarene RSS

    ORA-12592: TNS:bad packet

    762686
      Hi There,

      While executing a select * ..... operation on test environment on Oracle 10G im observing the following errors pretty frequently. could any one tell me what could be causing this issue. i have a sense that this has something related to database server rather from the application or the query that is being executed. any help of possible root cause would be appreciated very much.

      Caused by: java.sql.SQLException: ORA-12592: TNS:bad packet

      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
      at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
      at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
      at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
      at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
      at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
      at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861)
      at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1259)
      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
      at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3550)
      at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
      at org.enhydra.jdbc.core.CorePreparedStatement.execute(CorePreparedStatement.java:82)
      at com.rgb.core.server.persistence.spi.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:401)
      at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteQuery(MappedStatement.java:222)
      at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:190)

      Regards,
      bala.
        • 1. Re: ORA-12592: TNS:bad packet
          sb92075
          Post Operating System (OS) name & version for DB server system.
          Post results of
          SELECT * from v$version

          Is any type of Operating System Virtualization installed on DB server system?

          Does failing SQL utilize DBLINK?
          • 2. Re: ORA-12592: TNS:bad packet
            762686
            Please find the setup details as below

            1. Operating System (OS) name & version for DB server system.
            we are using Linux with 11g.

            2. Is any type of Operating System Virtualization installed on DB server system?
            DB is on a dedicated server machine.

            3. Does failing SQL utilize DBLINK?
            No DBLINKS is running.

            Thank you,
            bala.
            • 3. Re: ORA-12592: TNS:bad packet
              sb92075
              Caused by: java.sql.SQLException: ORA-12592: TNS:bad packet
              3. Does failing SQL utilize DBLINK?
              No DBLINKS is running.
              If you are getting TNS error and query not using DBLINK (no SQL*Net), then failure occurs at network level between client & DB server.
              This means it is not an Oracle problem, but basic OS/network issue.
              Get local Network Administrator involved to find & fix root cause.
              • 4. Re: ORA-12592: TNS:bad packet
                725039
                Caused by: java.sql.SQLException: ORA-12592: TNS:bad packet
                
                at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
                at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
                at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
                at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
                at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
                at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
                Do you mind sharing where these errors are coming from? What sort of application are you using?
                While executing a select * ..... operation on test environment on Oracle 10G 
                im observing the following errors pretty frequently. could any one tell me 
                what could be causing this issue. i have a sense that this has something related 
                to database server rather from the application or the query that is being executed. 
                any help of possible root cause would be appreciated very much.
                How certain are you that the problem is on the Database server side? Are there any other independent checks you have performed to confirm this?

                Regards,
                Phiri
                • 5. Re: ORA-12592: TNS:bad packet
                  762686
                  We are running a web application and the reason im suspecting a server issue is, the same query execution works fine for a lot of other requests the error seems to be happening in random manner.

                  Regards,
                  bala.
                  • 6. Re: ORA-12592: TNS:bad packet
                    sb92075
                    We are running a web application and the reason im suspecting a server issue is,
                    Interesting statement.
                    Webserver?
                    Application server?
                    Database server?
                    or none of the above

                    Oracle RDBMS is victim; not culprit.
                    I've run Oracle DBs since V7.3.4.5 & have NEVER seen ORA-12592 error.
                    I suspect actual networking/OS issue, but you are free to go snipe hunting.
                    • 7. Re: ORA-12592: TNS:bad packet
                      Jean de Lavarene
                      Could you please check the version of the JDBC Thin driver that you are using?