Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Loss of Connection on Query Execution
Hi,
we also got ora-3113 and the reason was a bug (108389) when using prespawned dedicated server prosesses. I believe it's fixed in Oracle 7.3.4 and in the meantime you cannot use them. You can check your listener.ora whether you are using them or not (prespawn_max=...). I'm working with Alpha/OpenVMS so this may not help you since you are using Solaris...
There's also another bug (103660) which breaks long-lasting transactions but then you should first get ora-1013. It can be fixed by setting EXPIRE_TIME = 0 in SQLNET.ORA.
Regards,
Maija-Leena
Chittesh wrote:
>
> Hi,
>
> Recently I have encountered this weired problem.
>
> I am using Oracle with Solaris
> Oracle7 Server Release 7.3.2.2.0 - Production Release
>
> In certain cases when I execute query which has like operator with
> '%' clause in condition server disconnects the connection.
>
> This happens also even when I try to run this query at SQL Prompt.
> Error Message is
>
> ORA-03113: end-of-file on communication channel
>
> Any help on this will really be appriciated.
> Thanks,
>
> - Chittesh Mehta
Received on Tue Oct 06 1998 - 18:40:37 CDT