Re: starting up an instance

mdesouza_at_YAHOO.COM wrote:

<snip>
]ERROR: ORA-01034: ORACLE not available
]ORA-09243: smsget: error attaching to SGA
]OSD-04101: invalid SGA: SGA not initialized
<snip>

Saw something very like this some time ago. There was an sgadef lying around that was no longer valid c.f. the new configuration. (I think it was after a stuff'ed up upgrade).

Anyway, in my case, a
shutdown abort;
startup;

fixed it. Yep, the db was/is down when you do the "shutdown abort", but that command gets rid of the invalid SGA; so you can then do the startup.

--

 ,-,_|\   George Dau,                                             __
/    * \  Unix (Solaris, DEC Unix, Linux), Oracle, Internet.     (OO)
\_,--\_/  Home: gedau_at_pobox.com      Work: gedau_at_isa.mim.com.au ( \/ )
      v   WWW:  http://pobox.com/~gedau                          W--W

MIM Internet policy item 3.4 compliance - "I am clearly stating that any views or opinions expressed above do * NOT * necessarily represent the views or opinions of MIM." Received on Fri Oct 30 1998 - 18:12:42 CST