Home » RDBMS Server » Server Administration » ORA-27100: shared memory realm already exists
ORA-27100: shared memory realm already exists [message #179304] Mon, 26 June 2006 16:02 Go to next message
orcl dba
Messages: 68
Registered: August 2005
Member
I get the error ORA-27100: shared memory realm already exists while starting the database. The action for the error message says: Action: Use a different instance name, or cleanup the failed instance's SGA. How do I clean up the instance's SGA?

Report message to a moderator

Re: ORA-27100: shared memory realm already exists [message #179307 is a reply to message #179304] Mon, 26 June 2006 16:23 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
SQL> SHUTDOWN ABORT

Report message to a moderator

Re: ORA-27100: shared memory realm already exists [message #179345 is a reply to message #179304] Tue, 27 June 2006 01:09 Go to previous message
madhusunkara
Messages: 59
Registered: March 2006
Location: hyderabad,india
Member
if you still have problem with shared memory you many want to remove them
using
ipcs -m
------ Shared Memory Segments --------
shmid owner perms bytes nattch status

and then

ipcrm <msg | sem | shm> <IPC ID>


Thanks
Madhu

Report message to a moderator

Previous Topic: Out of 2 Database only one is running
Next Topic: Finding raw file size
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 10 22:39:47 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.