OraFAQ Forum: Performance Tuning » ORA-27100: shared memory realm already exists

Home » RDBMS Server » Performance Tuning » ORA-27100: shared memory realm already exists

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-27100: shared memory realm already exists [message #65623]

Thu, 11 November 2004 16:01

Nguyen Xuan Anh
Messages: 1
Registered: November 2004

Junior Member

I have altered database by this command:
ALTER SYSTEM SET LOCK_SGA=TRUE SCOPE=SPFILE;
then I restart database by commands:
SHUTDOWN IMMEDIATE;
STARTUP;
The following error occurs:
ORA-27100: shared memory realm already exists.
and the instance cannot be started.
Any one can help me to resolve this problem?
Best regards.

Report message to a moderator