This discussion is archived
7 Replies Latest reply: Nov 26, 2011 4:00 AM by 19426 RSS

ora-3114 error

902206 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    Hi,

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

    Thanks
    -Dave
  • 3. Re: ora-3114 error
    P.Forstmann Guru
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points