Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-03113 error when connecting to Oracle

Re: ORA-03113 error when connecting to Oracle

From: Ron Reidy <rereidy_at_indra.com>
Date: Thu, 25 Oct 2001 06:59:03 -0600
Message-ID: <3BD80C97.7DAF7084@indra.com>


Marc Navarro wrote:
>
> Hi all,
>
> I am working with an Oracle database in a Solaris machine. If I try to
> start SQL*Plus, I get the error:
> ORA-03113: end-of-file on communication channel
> (I am trying to enter as user scott)
>
> The name of my database instance is CSYS (that's the value of my
> ORACLE_SID environment variable).
>
> But if I try to enter to SQL*Plus with the command:
>
> > sqlplus scott_at_csys
>
> then everything goes fine.
>
> My question is: why do I have to specify the name of the database?
>
> If I log on the machine with a different account, then I can enter
> SQL*Plus without specifying the database name. I am trying to discover
> what's different with this two accounts, so one can enter without
> specifying "@csys" but not the other one. Any ideas?
>
> Thans a lot
>
> --
> Marc Navarro
> Centre de Visio per Computador
> Universitat Autonoma de Barcelona

Have your DBA look at the alert log and follow up from there.

-- 
Ron Reidy
Oracle DBA
Reidy Consulting, L.L.C.
Received on Thu Oct 25 2001 - 07:59:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US