Re: DB instance shuting down

From: Joel Garry <joelga_at_pebble.ml.org>
Date: 6 May 1998 14:45:55 -0700
Message-ID: <6iqlmj$mon$1@pebble.ml.org>

In article <6io5j3$cn6_at_bgtnsc01.worldnet.att.net>,  <kelavine_at_worldnet.att.net> wrote:
>We are running Oracle 8.04 on an server running NT 4.0 /w service pak 3
>installed. We are experiencing a problem where the DB instance shuts
>down on its own and there do not seem to be any messages in any of the
>log. We've checked the NT event logs and there do not seem to be any
>related events there.
>
>Oracle asked us to re-install which we did, however we experienced
>another shutdown.
>
>When you check the database service in NT the service is no longer
>started. All we have to do to bring the DB up is restart the service.
>
>I'm hoping that someone might have some ideas, so far Oracle and
>Microsoft have not had a lot of suggestions.

Try cutting your SGA in half. I'm wildly guessing you have some sort of memory problem that NT is picking up on and wiping out Oracle. Perhaps using much less memory will allow Oracle to err before dying. See if keeping everything under 64M doesn't help, too.

>
>Thanks Knut
>

--
These opinions are my own and not necessarily those of Information Quest

jgarry@eiq.com                           http://www.informationquest.com

http://ourworld.compuserve.com/homepages/joel_garry "See your DBA?" I AM the @#%*& DBA! Received on Wed May 06 1998 - 16:45:55 CDT