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
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
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
shutdown immediate (or) abort
startup
Thats the only solution.If you are using windows, restart the service.