Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-27100: shared memory realm already exists

orawarebyteJan 11 2007 — edited Jan 11 2007
After increasing the SGA during production environement,and then accidently the database from cleint end sys/sys as sysdba at sqlprompt

SQL>Shutdown

After that

SQL>Startup

ORA-27100: shared memory realm already exists
Then i connected from server as sys/sys as sysdba

SQL*Plus: Release 10.1.0.2.0 - Production on Thu Jan 11 20:38:01 2007

Copyright (c) 1982, 2004, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup force
ORA-27100: shared memory realm already exists
SQL> startup mount
ORA-27100: shared memory realm already exists
SQL> startup nomount
ORA-27100: shared memory realm already exists
SQL> startup pfile=c:\init.ora.729200584925
ORA-27100: shared memory realm already exists
SQL> startup open
ORA-27100: shared memory realm already exists
SQL> 
What should be done immediate steps cause tommorow is working day.

Khurram
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 8 2007
Added on Jan 11 2007
7 comments
1,193 views