Re: Space problem when running two db at the same time (question)

"wei he (martletts)" <etlwihe_at_etlxdmx.ericsson.se> writes:
>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.

        There isn't enough memory for the additional set of semaphores needed for the database instance. The semaphores are kernel objects -- they exist within kernel memory space -- disk space has nothing to do with it. You either need more RAM or need to reconfigure the kernel to handle more semaphore sets.

-- 
Robert Crawford		crawford_at_iac.net	http://msen.com/~rcrawfor

MC: "The lights fall on a scene of exquisite beauty."
Crow: "And kill it!"