Home » RDBMS Server » Server Administration » Finding Semaphore id for one database in a server (HP-UX 11.11, Oracle 9i)
Finding Semaphore id for one database in a server [message #354211] Fri, 17 October 2008 01:01
sanei05
Messages: 103
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...
Previous Topic: internal error, conection to the server failed
Next Topic: More Space after Deleting Data
Goto Forum:
  


Current Time: Mon Dec 05 06:30:17 CST 2016

Total time taken to generate the page: 0.09686 seconds