OraFAQ Forum: Server Administration » ORA-27100: shared memory realm already exists

Home » RDBMS Server » Server Administration » 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 #130234]

Thu, 28 July 2005 21:29

nhom9a
Messages: 51
Registered: July 2005
Location: VN

Member

hi all.
This is state of my database when I try to start it.
Can anybody help me ?

ORA-27100: shared memory realm already exists
Cause: An attempt was made to start duplicate instances, or tried to restart an instance that had not been properly shut down.
Action: Use a different instance name, or cleanup the failed instance's SGA.

Report message to a moderator

Re: ORA-27100: shared memory realm already exists [message #130248 is a reply to message #130234]

Fri, 29 July 2005 00:19

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

HI

If possible, reboot the machine. This problem will resolve.

This issue comes when you try to start an instance even when an instance with same name is running.

You can also try starting the DB after stopping all oracle processes.

Regds
Girish

Report message to a moderator

Re: ORA-27100: shared memory realm already exists [message #130717 is a reply to message #130248]

Tue, 02 August 2005 02:20

nhom9a
Messages: 51
Registered: July 2005
Location: VN

Member

Hi
Thanks for your help.
I rebooted my machine but this error still display

Report message to a moderator

Re: ORA-27100: shared memory realm already exists [message #130725 is a reply to message #130717]

Tue, 02 August 2005 02:41

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Just for a try , use

SQL> Startup Force

It might work.

regards,
tarun

Report message to a moderator

Re: ORA-27100: shared memory realm already exists [message #131891 is a reply to message #130725]

Wed, 10 August 2005 00:06

enkhbold
Messages: 36
Registered: July 2005
Location: Mongolia

Member

What is RAM on the server

Report message to a moderator

Re: ORA-27100: shared memory realm already exists [message #131894 is a reply to message #131891]

Wed, 10 August 2005 00:11

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

RAM -- RANDOM ACCESS MEMORY.

Search this word on google n u wil get lots of responses.

Report message to a moderator

Re: ORA-27100: shared memory realm already exists [message #131898 is a reply to message #131894]

Wed, 10 August 2005 00:21

enkhbold
Messages: 36
Registered: July 2005
Location: Mongolia

Member

Sorry, it is my fault.

My question is : what is your server spec and RAM size?

Do you use VLM on the server?

Report message to a moderator

Previous Topic:	Error in connecting
Next Topic:	Housekeeping in listener.log

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 08:45:15 CST 2025