Startup Fails With ORA-27100 After Restarting The Windows Service
(Doc ID 370469.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 to 188.8.131.52 [Release 9.2 to 11.2]
z*OBSOLETE: Microsoft Windows Server 2003
ORA-27100 is reported during a manual startup of the database .
SQL*Plus: Release 10.2.0.4.0 - Production on Mon Dec 19 09:29:20 2011
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to an idle instance.
ORA-27100: shared memory realm already exists
SQL> shutdown immediate
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Restarting the service, the same error is encountered.
Rebooting the server does not help as well (because that also restarts the service).
The parameter sga_max_size was increased, e.g. from 2GB to 3GB.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document