Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Solaris Unix Shared Memory Semaphores - 3113 Problem

Re: Solaris Unix Shared Memory Semaphores - 3113 Problem

From: JustAnotherDBA <jadba_at_bellsouth.net>
Date: Sat, 22 Feb 2003 14:49:01 -0600
Message-ID: <g9R5a.11438$1N4.5293@fe05.atl2.webusenet.com>


Interesting... but, not sure that would have helped me today.

I couldn't get a successful connect internal.

Before issueing a connect, svrmgrl would generate the error 3113 and any command I issued like connect would fail with 3113.

"koert54" <nospam_at_nospam.com> wrote in message news:A7Q5a.68694$Jd.8164_at_afrodite.telenet-ops.be...
> 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 - 14:49:01 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US