| Finding Semaphore id for one database in a server [message #354211] |
Fri, 17 October 2008 01:01 |
sanei05
Messages: 104
Registered: September 2008
|
Senior Member |
|
|
I have 2 database(DB1 and DB2) in a unix server. I am trying to bring up the databases (DB1 and DB2) back to normal.
I managed to bring to one(DB1) database. When I tried for another db(DB2), I get the below error..
ORA-01102: cannot mount database in EXCLUSIVE mode
I went through the oracle docs and find out that we need to kill the background process and remove the semaphore id's...
I have a doubt here.. I got two databases.. When I gave the below command, I got the semaphore id's and and shared server segment id's owned by the oracle.
ipcs -b| grep oracle
Now the thing is I need to remove the semaphore id of one database and not for all the databases present in the server.
Can you pls help how can i proceed to remove the semaphore id's and and shared server segment id's for DB2 alone.
I followed the steps in the link
http://www.orafaq.com/forum/t/40030/0/
Pls help me out...
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
