Re: Crashed WinNT 3.51:Oracle SGA error messages,please help...

I don't know about NT, but in UNIX, if you get the same kind of error. There is several things that you need to check: 1) Is the owner of Oracle set to 6751? are you using the owner Oracle to start up the database (you need to be oracle because there are a lot of background setting for user oracle)
2) the memory is not big enough to let the SGA to reside in. Or the swapping size is not enough.

Winnie

kgrigg_at_my-dejanews.com wrote in message <6tmrro$48l$1_at_nnrp1.dejanews.com>...
>Hello all,
>
>I'm trying to help with a problem on a Oracle 7.3 instance running on a
WinNT
>3.51 machine that just crashed and burned. I didn't set up the instance,
>but, and trying to work with those who did. Basically what happened....it
>appears that 3 of the 6 drives went offline, for what reasons, we don't
know.
> We have gotten all of the drives online again, and the server seems to be
>working again. However, we can't seen to get the Oracle instance up again.
>When trying to connect to it we get the following 3 error messages:
>
>ORA-01034: Oracle not available
>ORA-09243: smsget: error attaching to SGA
>ORA-04101: invalid SGA: SGA not initialized
>
>In the HTML help on the server it referers you to your OS specific
>documentation...which isn't to be found around here anywhere. So, could
>someone give some advice, or possibly point me to where I need to look to
>find info on how to fix this. This came at a really bad time (is there a
>good one?), but, a demo of a project that accesses this has a code freeze
>deadline this friday, and we need to have the machine up and running by the
>morning...
>
>One last thing, in the NT services window, the services seem to come up ok,
>just that the instance can't get started. The inin.ora file looks ok...and
>the control files it points to seems to be where they should....
>
>TIA!!!!!
>
>Kelly
>kgrigg_at_diamonddata.com
>cayenne1_at_earthlink.net
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Tue Sep 15 1998 - 21:32:39 CDT