7 Replies Latest reply: Nov 26, 2011 6:00 AM by 19426 RSS

    ora-3114 error

    902206
      Please help on this issue which i am confronting.

      We have 3 tier application. if the application is not used for a couple of hours
      the connection is getting disconnected. When checked the application log
      it was showing ora-3114 error. I loged in as sqlplus from the client system and issued a sql 'select sysdate from dual' after some couple of hours again i tried to issue the same sql its started throwing

      SQL> /
      select sysdate from dual
      ERROR at line 1:
      ORA-03113: end-of-file on communication channel
      Process ID: 19040
      Session ID: 971 Serial number: 17043

      Database RAC 11.2.0.2
      OS OEL 5.6
      Client 11.2.0.1
      OS Windows Server 2008R2

      Any help on this is appreciated.

      Thanks
      -Dave

      Edited by: 899203 on Nov 25, 2011 8:53 AM
        • 1. Re: ora-3114 error
          sb92075
          899203 wrote:
          Please help on this issue which i am confronting.

          We have 3 tier application. if the application is not used for a couple of hours
          the connection is getting disconnected. When checked the application log
          it was showing ora-3114 error. I loged in as sqlplus from the client system and issued a sql 'select sysdate from dual' after some couple of hours again i tried to issue the same sql its started throwing

          SQL> /
          select sysdate from dual
          ERROR at line 1:
          ORA-03113: end-of-file on communication channel
          Process ID: 19040
          Session ID: 971 Serial number: 17043

          Database RAC 11.2.0.2
          OS OEL 5.6
          Client 11.2.0.1
          OS Windows Server 2008R2

          Any help on this is appreciated.

          Thanks
          -Dave

          Edited by: 899203 on Nov 25, 2011 8:53 AM
          I suspect some sort of network/Firewall timeout disconnection.
          • 2. Re: ora-3114 error
            902206
            Hi,

            Thanks for the prompt reply. We have disabled the firewalls.

            Thanks
            -Dave
            • 3. Re: ora-3114 error
              P.Forstmann
              Please clarify first whether you get ORA-3113 or ora-3114 errors: these are different errors although they look like similar. But in both cases have a close look to all instance alert logs to check for possible database session crashes:
              $ oerr ora 3113
              03113, 00000, "end-of-file on communication channel"
              // *Cause: The connection between Client and Server process was broken.
              // *Action: There was a communication error that requires further investigation.
              //          First, check for network problems and review the SQL*Net setup.
              //          Also, look in the alert.log file for any errors. Finally, test to
              //          see whether the server process is dead and whether a trace file
              //          was generated at failure time.
              
              $ oerr ora 3114
              03114, 00000, "not connected to ORACLE"
              // *Cause:
              // *Action:
              • 4. Re: ora-3114 error
                19426
                Do you have sqlnet.expire_time in sqlnet.ora?

                http://docs.oracle.com/cd/B19306_01/network.102/b14213/sqlnet.htm#sthref474

                It's possible that an idle connection gets disconnected according to this parameter. ORA-03113 may be a follow-up error to ORA-03114.

                Werner
                • 5. Re: ora-3114 error
                  853131
                  I am getting this error

                  SQL> select sysdate from dual;
                  select sysdate from dual
                  *
                  ERROR at line 1:
                  ORA-03113: end-of-file on communication channel
                  Process ID: 21845
                  Session ID: 203 Serial number: 28981
                  • 6. Re: ora-3114 error
                    sb92075
                    user5350741 wrote:
                    I am getting this error

                    SQL> select sysdate from dual;
                    select sysdate from dual
                    *
                    ERROR at line 1:
                    ORA-03113: end-of-file on communication channel
                    Process ID: 21845
                    Session ID: 203 Serial number: 28981
                    ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support

                    typically a trace file is generated which contains additional clues as indicated by contents of alert_SID.log file
                    • 7. Re: ora-3114 error
                      19426
                      and issued a sql 'select sysdate from dual' after some couple of hours again ...
                      This is one of the situations, where you don't need an ORA-00600 investigation. Assuming the connection is lost (ORA-03114 not connected to Oracle), a following ORA-03113 is not a mystery,when you issue a statement.

                      Werner