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

On NT just because the service starts doesn't mean the instance is running. Check your alert log, this should tell you the exact reason why the instance didn't start. Could be as simple as a missing parameter file or incorrect path, or it could be more serious.

The platform specific documentation can be found on your CD in HTML format. It may also have been installed on your hard drive during the original Oracle installation.

Good Luck

kgrigg_at_my-dejanews.com wrote:

> 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 Wed Sep 16 1998 - 11:34:20 CDT