Re: Oracle Restore Problems - ora-01034

Yeah, and if that doesn't work, check to make sure the restore finished, then keep trying. I think it's an NT related problem more than Oracle (I may be wrong). I have two IBM 325's that do that all the time. After rebooting a time or two and starting and stopping the instance, it catches.

If you are running multiple instances, shut the other(s) down and retry.

You can file this under the least technical advice you've ever gotten, but if I can't start it through SM, I take the Microsoft advice and "reboot"

<name removed to protect the embarrassed>

On Mon, 26 Apr 1999 10:54:42 +0200, Frank van Bortel <f.van.bortel_at_vnl.nl> wrote:

>Start the database;
>- make sure the service is started
>- connect internal
>- startup
>
>Niall McSharry wrote:
>
>> Hi,
>> I had a major Crash on an NT Server 4.0 running Oracle, I managed to restore
>> everything ok,
>> but now when I try an access a database I get the following message:
>> ERROR: ORA-01034: ORACLE not available
>> ORA-09243: smsget: error attaching to SGA
>> OSD-04101: invalid SGA: SGA not initialized
>>
>> Anybody have any ideas?
>>
>> Thanks
>> Niall
>
>--
>Met vriendelijke groet,
>kind regards,
>
>Frank van Bortel
>Technical consultant Oracle
>V&L Informatica BV
>-----------------------------------------------
>Work Home
>Postbus 545 Hunzestraat 4
>7500 AM Enschede 7555 WB Hengelo
>(31)53.434.1500 (31)74.242.5046
>
>
Received on Tue Apr 27 1999 - 21:15:39 CDT