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 -> ORA-03113 error when connecting to Oracle

ORA-03113 error when connecting to Oracle

From: Marc Navarro <mnavarro_at_cvc.uab.es>
Date: Thu, 25 Oct 2001 12:55:32 +0100
Message-ID: <3BD7FDB4.AA1E1440@cvc.uab.es>

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
Received on Thu Oct 25 2001 - 06:55:32 CDT

Original text of this message

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