ORA-27100 after altering the SGA_MAX_SIZE

From: Carlos Correia <cepcorreia_at_hotmail.com>
Date: 20 Jul 2005 02:03:57 -0700
Message-ID: <1121850237.002209.323240@g14g2000cwa.googlegroups.com>

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. Received on Wed Jul 20 2005 - 04:03:57 CDT