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

Jonathan Scott wrote:

> As I said in my other post, it is currently at 320MB, physically, and still
> having the same problem.
>
> Here's one for you: I've checked all available documentation on how to
> modify the kernel, and the extent I have found: "Modify such and such
> parameter". Talk about being obscure beyond belief! They dont bother to
> mention the actual name of the parameter in the header file nor what a
> minimum amount is expected! It seems there is a minimum setting for Solaris
> that is recommended, in fact even required! But the Linux installation can
> be so completely arbitrary?
>
> Solaris installations were a piece of cake compared to installations on
> Linux, considering the amount of information (and sometimes mis-information)
> available.
>
> Jonathan Scott
>
> P.S. I told you how much physical memory was unused, which would seem more
> relevent than how much is actually installed. It was at 192MB, now it's at
> 320MB. Are there any other details that you might consider more necessary?
> If so, please do mention, as I am giving as much information as I can find
> out!
>
> "Howard J. Rogers" <dba_at_hjrdba.com> wrote in message
> news:afpi6r$pe3$1_at_lust.ihug.co.nz...
> > You don't think, just possibly, that knowing the physical RAM on your box
> > might be relevant? Given that you mention it might be the problem???
> >
> > I'll just guess, shall I?
> >
> > However much a Pro you may or may not be, you really need to learn how to
> > describe a problem accurately (which you didn't do too badly on) and
> include
> > all available diagnostic information (which you did [do badly on]).
> >
> > If you have 256Mb, there shouldn't be a problem, provided you follow the
> > install instructions and its kernel-setting instructions to the letter.
> > Otherwise... more information needed.
> >
> > (Incidentally, please don't cross-post, as this is the newsgroup for these
> > kind of questions)
> >
> > Regards
> > HJR
> >
> >
> >
> > "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=@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
> > >
> > >
> >
> >

Either amount of RAM is sufficient to get Oracle installed and running.

I'm still betting on semaphores and shared memory parameters not being set properly.

Daniel Morgan Received on Mon Jul 01 2002 - 11:51:28 CDT