Removing a semaphore set for Oracle Oracle Tips by Burleson Consulting

Removing a semaphore set for Oracle

We start by issuing the ipcs –sb command to display details of the semaphore set.

root> ipcs -sb|grep oracle
s 67 0x00000000 --ra-r----- oracle Remote DBA 400
s 223 0x00000000 --ra-r----- oracle Remote DBA 400
s 334 0x00000000 --ra-r----- oracle Remote DBA 300

Now, we can remove the semaphores from the locked-up database. In this example, we assume that set 223 is the one for the crippled database.}

root> ipcrm -s 223

Now we can confirm that the semaphores are deleted.

root> ipcs -sb|grep oracle

s 67 0x00000000 --ra-r----- oracle Remote DBA 400
s 334 0x00000000 --ra-r----- oracle Remote DBA 300

The above is an excerpt from the "Oracle9i UNIX Administration Handbook" by Oracle press, authored by Donald K. Burleson.

Expert Remote DBA BC is America's oldest and largest Remote DBA Oracle support provider.  Get real Remote DBA experts, call BC Remote DBA today.