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

From: Harpreet Singh <harpreet_at_ruksun.com>
Date: Mon, 1 Jul 2002 17:59:20 +0530
Message-ID: <afph5o$ioo$1_at_news.vsnl.net.in>


Hi Jonathan

    I had a very similar problem while creating the DB on Windows 2000. My computer was on the network hence while authenticating it was using NTS authentication method, just change it to none. This error troubled me for more than 2 weeks and finally i got a link where it is reported.. Please do the following :-
In the file "ORACLE_HOME\network\admin\sqlnet.ora" replace the following line -
SQLNET.AUTHENTICATION_SERVICES= (NTS)
with
SQLNET.AUTHENTICATION_SERVICES= (NONE) http://www.orafaq.com/msgboard/server/messages/7643.htm

Please tell me if it works by this method, also do tell me if its resolved by some other method, this would help us understand the various possilbe causes of this error

Regards
Harpreet

"Jonathan Scott" <jonokun_at_hotmail.com> wrote in message news:ChXT8.94693$lo2.906844_at_news.easynews.com...
> I am trying to run Oracle 8.1.7 on SuSE 8.0 Linux, and I've got the
> installation done for the most part, but as with all things, there is
 always
> something left to be done.
>
> My problem is that when I try to create my first database on this
> installation(my first Linux installation ever), using an .sql file, when
> svrmgrl runs for a few minutes, thinking, before it even finishes the
 first
> statement, the following comes out:
>
> ORA-03113: end-of-file on communication channel
> LCC-00161: Message 161 not found; product=SVRMGR; facility=MGR
>
> Before running this, I could start up svrmgrl without any problem. Once I
> run the "svrmgrl command=_at_crdbtrad5" command, it hits the above messages,
> and forever after that it continues to print
>
> ORA-03113: end-of-file on communication channel
>
> when I just run svrmgrl alone.
>
> I've checked top and it seems SWAP is not getting touched, however
 physical
> memory is very low, down to about 4MB even before I start the DB creation.
>
> Im not a pro, but it seems maybe physical memory could be the problem?
 Maybe
> there just isnt enough in the machine to do what I need? If someone could
> give me some pointers on how to investigate this a bit better or has a
> solution, I'd be open to just about anything right now.
>
> Thanks in advance!
> Jonathan Scott
>
>
Received on Mon Jul 01 2002 - 14:29:20 CEST

Original text of this message