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

In article <3tr792$be6_at_erinews.ericsson.se>

           etlwihe_at_etlxdmx.ericsson.se "martletts" writes:

> 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
>

Sounds like unix is running out of resources, check out the set up of the unix kernel. Two databases take up a lot more resources than one. Under Solaris the file was /etc/system which containg all the system parameters.

>
> 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
>
>
>
 

-- 
-------------
Regards
Steve
-------------