Link to home
Start Free TrialLog in
Avatar of Kamlesh77
Kamlesh77

asked on

ORA-27100: shared memory realm already exists

I have installed ORACLE and created a database with SID siebel.
I shutdown the oracle instance using Shutdown abort, but the system hanged at this instance so I rebooted the system
Now when I try to start the Oracle Instance I get the following

ORA-27100: shared memory realm already exists
SVR4 Error: 17: File exists

Any help will be greatly appreciated.

Thanks
Kamlesh
Avatar of catchmeifuwant
catchmeifuwant

Shutdown the instance and restart again..


shutdown immediate (or) abort  
startup

Thats the only solution.If you are using windows, restart the service.

Avatar of schwertner
Stop the service in Windows.
Kamlesh77:

that's ok. It's normal. that means your oracle instance has been started.

Just login to the database , it's also problaby started.
ASKER CERTIFIED SOLUTION
Avatar of baonguyen1
baonguyen1

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Seeing as how you rebooted the server, ipcs and ipcrm to remove the memory segment is not valid.  The segment would have been removed when the system was rebooted.

If the database is truly down, and you need to make sure before you do this, look in the $ORACLE_HOME/dbs directory.  There should be files in there named lk*.  Delete file file that corresponds to the ORACLE_SID you are trying to start, then start the database.