Re: Oracle Windows service does not start DB

"Stjepan Brbot" <stjepan.brbot_at_zg.hinet.hr> wrote in message news:abfo5p$7ian$1_at_as201.hinet.hr...
> On my computer (Windows 2000 Pro) I have installed Oracle 8.1.7 EE. and
> only one DB instance. Also, Oracle service on Windows is set to be
> started manually and instance to be started automatically upon starting
> the service.
>
> Firstly everithing was working fine but few weeks ago (after Windows
> found some disk problems and successfully solved them) something strange
> is happening.
>
> When I start service manually in command prompt:
> D:\>net start OracleServiceXYZ
>
> I got the following:
> D:\>net start OracleServiceXYZ
> The OracleServiceXYZ service is starting.....
> The OracleServiceXYZ service was started successfully.
>
> Even it seems that everything is OK, it's not. I cannot connect on this
> DB. When I try connection on DB I got this message:
> "ORA-27101: shared memory realm does not exist"
>
> Then I have to start SVRMGRL, connect as INTERNAL and STARTUP database
> manually "once again", after that DB is started and works.
> --
>
> D:\>svrmgrl
>
> Oracle Server Manager Release 3.1.7.0.0 - Production
>
> Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
>
> Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
> With the Partitioning option
> JServer Release 8.1.7.0.0 - Production
>
> SVRMGR> connect internal
> Connected.
> SVRMGR> startup
> ORACLE instance started.
> Total System Global Area 73127964 bytes
> Fixed Size 75804 bytes
> Variable Size 56197120 bytes
> Database Buffers 16777216 bytes
> Redo Buffers 77824 bytes
> Database mounted.
> Database opened.
> SVRMGR> exit
> Server Manager complete.
>
> D:\>
>
> --
> Before problems with disk when I started service (and DB) manually I was
> getting:
> D:\>net start OracleServiceXYZ
> The OracleServiceXYZ service is
> starting................................................................
> ..........................
> The OracleServiceXYZ service was started successfully.
>
> Notice much more dots (and time of course) after "The OracleServiceXYZ
> service is starting". Before I had two instances, firstly they both
> worked fine but after this disk problem the same situation occured with
> service for second instance. I had to start it using SVRMGRL.
>
> --
>
> So question is how to solve problem with service to automatically and
> correctly start database instance?
>
> --
>
> Stjepan Brbot
>
>
>
>

Please try to be *exact* instead of *vague* 'Windows found *some* disk problems'
Where? It might have corrupted Oracle binaries! Did you check the alert<sid>.log? Probably not. Please check the alert before posting, your post doesn't contain any sensible clues. The error points to the fact Oracle can't create the SGA, you might have changed the init.ora parameters in the meantime. Also: you are one of the regulars here who consistently crosspost. Please stop doing so.

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address