Friday, July 27, 2012

ORA-03113: end-of-file on communication channel

ERROR Message:
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 12556
Session ID: 96 Serial number: 12509

ERROR:
ORA-03114: not connected to ORACLE
Log file info:

Incident 757262 created, dump file: /u01/app/oracle/database/diag/rdbms/prod/ORCL/incident/incdir_757262/ORCL_ora_12556_i757262.trc
ORA-07445: exception encountered: core dump [evaopn3()+125] [SIGSEGV] [ADDR:0x4] [PC:0x8AA42D1] [Address not mapped to object] []

this is a bug. Manipulate the sql to remove order by or group by or chagne date format might be a work-around.



1 comment:

  1. Hi Benjamin
    Your post helped to solve a problem I had.
    You are mentioning that this is a bug.
    Which patch do I need to deploy to solve this issue?
    We are running Oracle 11.2.0.3.0 on Suse Linux 11.
    Thank you for your feedback.
    Murat

    ReplyDelete