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

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Tue, 22 Mar 2011 11:49:33 +0000
Message-ID: <AANLkTinNFKnmUoVOV447nUsxv+QC4qNm3mmteECNn1Tv_at_mail.gmail.com>

ORA-03113 means your session and the server process have stopped talking. This shouldn't happen in your situation. Of course if you have further complications (like it's not a table but a complex view, or there's a VPD function or....) then there maybe a specifc bug/issue that you hit. In either case the trace files mentioned earlier should give you more info

On Tue, Mar 22, 2011 at 11:08 AM, jo <jose.soares_at_sferacarta.com> wrote:

> Hi all,
>
> Does someone know what this error mean?
> "end-of-file on communication channel"
>
> I have the following table, with no rows stored:
>
> name | data_type | nullable | data_default | data_length
> --------------- + --------- + -------- + ------------- + -----------
> COD_MALATTIA | NVARCHAR2 | Y | NULL | 20
> COD_MATRICE | NVARCHAR2 | Y | NULL | 20
> COD_NAZIONE | NVARCHAR2 | Y | NULL | 6
> DATA_FINE | DATE | Y | NULL | 11
> DATA_INIZIO | DATE | N | CURRENT_DATE | 11
> ID | NUMBER | N | NULL | 38
> ID_MACELLAZIONE | NUMBER | N | NULL | 38
>
> I tried these queries:
>
> select count(*) from restrizione where COD_MALATTIA is not null
> count(*)
> --------
> 0
>
> select count(*) from restrizione where COD_MATRICE is not null
> count(*)
> --------
> 0
>
> select count(*) from restrizione where COD_NAZIONE is not null
> count(*)
> --------
> 0
>
> select count(*) from restrizione where DATA_INIZIO is not null
> count(*)
> --------
> 0
>
> select count(*) from restrizione where ID is not null
> count(*)
> --------
> 0
>
> select count(*) from restrizione where ID_MACELLAZIONE is not null
> count(*)
> --------
> 0
>
> select count(*) from restrizione
> count(*)
> --------
> 0
>
> but this one raises the error
>
> select count(*) from restrizione where DATA_FINE is not null
> ORA-03113: end-of-file on communication channel
>
> Only when I use DATA_FINE column in the WHERE clause it raise the error.
> what's wrong with this column?
>
> Thanks for any help.
>
> j
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Mar 22 2011 - 06:49:33 CDT