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

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

Is ORACLE_SID correctly specified?  

also check your oratab file.

>
> 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

--

++---------------------------++----------------------------------------++
|| R.M. Stockmann            ||   InfoMagic Nederland VOF             
||
|| stock_at_infomagic.nl        ||   Unix administration & support       
||
|| http://www.infomagic.nl   ||   The Netherlands  		       ||
++---------------------------++----------------------------------------++
250-Linux: A copylefted Unix-like operating system for 80[3456]86, 
250-       DEC Alpha, Sun SPARC, Sun UltraSPARC, Motorola 68k, 
250-	   PowerPC/PowerMac, ARM, Mips R[3,4]x00, Fujitsu AP/1000+ 
250-	   and more to come.