Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-03113 error when connecting to Oracle
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