Re: ORA-27100 after altering the SGA_MAX_SIZE

Carlos Correia wrote:
> Hi all,
>
> After issuing the following command
> ALTER SYSTEM SET sga_max_size='2097152000'scope=SPFILE
> and restarting the server.
>
> Oracle does not seem to start up correctly. I then attempt
>
> E:\oracle\product\10.1.0>sqlplus /nolog
>
> SQL*Plus: Release 10.1.0.2.0 - Production on Wed Jul 20 09:36:57 2005
>
> Copyright (c) 1982, 2004, Oracle. All rights reserved.
>
> SQL> connect / as sysdba
> Connected to an idle instance.
> SQL> startup
> ORA-27100: shared memory realm already exists
> SQL> startup force
> ORA-27100: shared memory realm already exists
> SQL> shutdown immediate
> ORA-01034: ORACLE not available
> ORA-27101: shared memory realm does not exist
> SQL> shutdown abort
> ORACLE instance shut down.
> SQL> exit
> Disconnected
>
> E:\oracle\product\10.1.0>sqlplus /nolog
>
> SQL*Plus: Release 10.1.0.2.0 - Production on Wed Jul 20 09:38:05 2005
>
> Copyright (c) 1982, 2004, Oracle. All rights reserved.
>
> SQL> connect / as sysdba
> Connected to an idle instance.
> SQL> startup force
> ORA-27100: shared memory realm already exists
>
> ------
> SERVER DETAILS
> RDBMS Version: 10.1.0.2
> Operating System and Version: Windows 2003 SP1
> Error Number (if applicable): ORA-27100
>
> ---
>
> How do I go about fixing this problem.
>
> Thanks in advance for your help.

Did you start the Oracle service in the Control Panel.

Verify it is running.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)