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

From: Anton Buijs <aammbuijs_at_xs4all.nl>
Date: Fri, 26 Apr 2002 22:29:38 +0200
Message-ID: <aacdcv$e8m$1@news1.xs4all.nl>

ORA-3113 has so many causes but when 2 different versions are on one machine I always get suspicious about the variables that are set. Many people put PATH=$PATH:$ORACLE_HOME/bin in the .profile. Ending up with directories of several Oracle versions in variables PATH or LD_LIBRARY_PATH.
Well: that's the perfect way of getting core dumps, crashing databases terrible errors like ORA-3113.

Mayby you could check if this is the case in your situation.

Tim Smith <timasmith_at_hotmail.com> schreef in berichtnieuws a7234bb1.0204231524.3fda7134_at_posting.google.com...
> Hi,
> We have Oracle 7.3 and Oracle 8.1 on the sun4u sparc SUNW,Ultra-4
> Solaris 2.6 server.
>
> Before a reboot we could connect to databases on either version.
>
> After the reboot if I log on as either user (oracle8 or oracle7) I
> can connect via the listener to all Oracle7 databases but none of the
> Oracle8 databases.
>
> The listener was originally started by Oracle7 but then was
> restarted by the Oracle8 user.
>
> I get the error ORA-03113: end-of-file on communication channel
> trying to get via svrmgrl or directly through sqlplus
Received on Fri Apr 26 2002 - 15:29:38 CDT