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

454977Mar 10 2006 — edited Mar 10 2006

I started generating this error after I changed the sga_max_size paramter from 1024 to 2048. After I bounced the database I began generating the error - ORA-27100 when trying to log into oracle.

I am running Oracle 10g r2 on win2003.

I have tried:

I set ORACLE_SID=dbname
sqlplus /nolog
connect sys/dba as sysdba
Connected to an idle instance.
startup

and I generate the same error. Any suggestions for getting oracle started would be very helpful, thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 7 2006

Added on Mar 10 2006

#general-database-discussions

1 comment

449 views