Re: 03113 EOF on communication channel

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: 8 Oct 2003 06:36:46 -0700
Message-ID: <1a75df45.0310080536.1076b016@posting.google.com>

This error means, usually AFAIK, either one of the two following:

1. Network connection has been closed unexpectedly Cause : network problems/bugs Action: Check patches, kernel & network drivers. (have seen this happened first hand)
2. Your shadow has died ungracefully e.g. via a Unix signal that does not trigger the shadow's signal handler which means that the shadow cannot close gracefully. Cause : something (or someone as the code below illustrates) caused the shadow to die Action: beat the sysadmin who killed your shadow with a lead pipe ;-) (or determine why the process died - e.g. lack of Unix resources)

(SQL*Plus connection made to user_at_tnsalias - if a local connection is made in this scenario you will get a TNS packet writer failure instead)

SQL> select sysdate from dual;

SYSDATE

---

08-OCT-03 SQL> select spid from v$process where addr = (select paddr from v$session where sid = (select sid from v$mystat where rownum=1) );

SPID

---

21226

SQL> !ps -fp 21226

     UID   PID  PPID  C    STIME TTY       TIME COMMAND
  oracle 21226     1  0 15:22:44 ?         0:00 oracledev (LOCAL=NO)

SQL> !kill -9 21226

SQL> select sysdate from dual;
select sysdate from dual
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel

SQL>

--
Billy

Received on Wed Oct 08 2003 - 08:36:46 CDT