Re: oracle problem

From: John Oliver <John_at_yellowstone.co.uk>
Date: Tue, 15 Sep 1998 12:16:26 +0100
Message-ID: <35FE4C8A.F3ECD9A4@yellowstone.co.uk>

Cyril Caillaud wrote:
SNIP
> Oracle7 Workgroup Server Release 7.3.4.2.0
> Windows NT
> I reboot the system and now i have a problem
> the services start without problem
> but when i try to access to oracle
> i have error messages
>
> ORA-01034 Oracle not available
> ORA-09243 smsget error attaching to Sga
> OSD-04101 invalid SGA SGA not initialized
> O/S error (OS 203) the system could not find the envirennement option that
> was entered

Probably the instance has not started automatically. Check that automatic start of instance is expected, e.g. using Instance Manager.

If not, you can use ORADIM73, using -EDIT, to make it start automatically.

If it is expected to be automatic, then it has failed. See the log file in <HOME>RDBMS73\oradim73.log for an error message.

Also check your init<sid>.ora file for TABs, as these can stop the instance starting automatically.

--
Regards,
John. Received on Tue Sep 15 1998 - 06:16:26 CDT