Re: Space problem when running two db at the same time (question)
Date: 1995/07/11
Message-ID: <3tua7r$1ed_at_mother.usf.edu>#1/1
In article <3tr792$be6_at_erinews.ericsson.se>, "wei he (martletts)" <etlwihe_at_etlxdmx.ericsson.se> says:
>
>Hi
>
>I tried to run two databases at the same time but got a problem. Hope someone
>can give me a help.
>
>Basically, when I start up another instance without shut down the one running, I
>got a error message as follow:
>
>CAUTION
>
>ORA-07279: spcre: semget error, unable
>to get first semaphore set.
>SunOS Error: 28: No space left on device
>Additional information: 2
>
>
>Orcale support said this is a problem with space on the platform. In fact
>the hard disk which conatins all the files (data file, control file etc)
>for the two database still has a lot of space (more than 500 M). I don't
>understand which space that the error message was talking about.
>
>
>Thanks advance.
>
>Wei
>etlwihe_at_etlxdmx.ericsson.se
>
>
This may be a semaphore problem. Look in the Oracle7 Server for Unix installation guide in the index under semaphore. You need to allocate semaphores for each database. Generally one semaphore per simultaneous Oracle connection to the database. This is a common problem when a second database is added to a machine. Only one database will start. You need to look at the Unix kernal parameters SEMMNI, SEMMSL, and SEMMNS. If you do an "ipcs -a" and view the semaphore section, you will see the allocated semaphores.
Below I have 200 semaphores (the NSEMS column) allocated to each of 3 databases running. This displays after the databases are started.
Example of ipcs -a:
IPC status from /dev/kmem as of Tue Jul 11 12:50:40 1995
T ID KEY MODE OWNER GROUP CREATOR CGROUP CBYTES QNUM
QBYTES LSPID LRPID STIME RTIME CTIME
Message Queues:
T ID KEY MODE OWNER GROUP CREATOR CGROUP NATTCH SEGS
Z CPID LPID ATIME DTIME CTIME
Shared Memory:
m 2800 0x097f01f6 -Crw-r----- oracle dba oracle dba 5130539
52 24596 26660 10:48:10 12:47:25 1:33:17
m 2801 0x0afe7b1a -Crw-r----- oracle dba oracle dba 5130539
52 24637 24637 1:33:43 1:33:46 1:33:33
m 2802 0x097f0201 -Crw-r----- oracle dba oracle dba 7275865
60 24665 27021 12:21:14 12:20:44 1:33:46
T ID KEY MODE OWNER GROUP CREATOR CGROUP NSEMS OTIM
E CTIME
Semaphores:
s 2800 0x00000000 --ra-r----- oracle dba oracle dba 200 11:08:
44 1:33:17
s 2801 0x00000000 --ra-r----- oracle dba oracle dba 200 1:33:
46 1:33:33
s 2802 0x00000000 --ra-r----- oracle dba oracle dba 200 12:50:
34 1:33:46
$
Received on Tue Jul 11 1995 - 00:00:00 CEST