Oracle Windows service does not start DB
Date: Thu, 9 May 2002 09:32:01 +0200
Message-ID: <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.
When I start service manually in command prompt:
D:\>net start OracleServiceXYZ
I got the following:
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
SVRMGR> connect internal
D:\>net start OracleServiceXYZ
The OracleServiceXYZ service is starting.....
The OracleServiceXYZ service was started successfully.
--
JServer Release 8.1.7.0.0 - Production
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 Received on Thu May 09 2002 - 09:32:01 CEST