Startup Fails With ORA-27100 After Restarting The Windows Service
Last updated on DECEMBER 06, 2016
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 to 126.96.36.199 [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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms