as you're using oracle 8 :
svrmgrl
connect internal
oradebug ipc
->>> shows you all the info you need
"JustAnotherDBA" <jadba_at_bellsouth.net> wrote in message
news:6UP5a.13220$A27.2303_at_fe03.atl2.webusenet.com...
> I had to do a ipcrm to zap the shared memory and semaphores for 1 database
.
> I did this based on documents in Metalink and I am sure it was needed.
>
> But, I am wondering if anyone knows how to tell which shared memory and
> semaphores go with which database.
>
> I couldn't find a way, so I shutdown all of the databases. Then, I did the
> ipcrm command to remove the 1 remaining .
>
> No problems after that with the 1 database that I was getting a 3113 on it
> (just by running svrmgrl).
>
> Some more info...
>
> Solaris 8
> Oracle8i 8.1.6.2.0
> 5 databases
>
> Fyi... below is the output of ipcs before running ipcrm, but after
shutting
> down 1 database...
>
> % ==> ipcs
> IPC status from <running system> as of Sat Feb 22 12:08:52 CST 2003
> T ID KEY MODE OWNER GROUP
> Message Queues:
> Shared Memory:
> m 0 0x66ac8bec --rw-r----- or02sup sccdba
> m 2 0xbf400f48 --rw-r----- or02sup sccdba
> m 403 0xf2ff35a4 --rw------- or02sup sccdba
> m 404 0x717ed15c --rw------- or02sup sccdba
> Semaphores:
> s 196608 0x5857945 --ra-r----- or02sup sccdba
> s 196610 0x509aa45 --ra-r----- or02sup sccdba
> s 458755 0x387a875 --ra------- or02sup sccdba
> s 458756 0x51782c5 --ra------- or02sup sccdba
>
>
>
Received on Sat Feb 22 2003 - 13:24:16 CST
