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

In article <tok.55.3001509B_at_sni.dk> from [Mon, 10 Jul 1995 16:09:00 GMT] you wrote:
|> In article <3tr792$be6_at_erinews.ericsson.se> "wei he (martletts)" <etlwihe_at_etlxdmx.ericsson.se> writes:
|> >From: "wei he (martletts)" <etlwihe_at_etlxdmx.ericsson.se>
|> >Subject: Space problem when running two db at the same time (question)
|> >Date: 10 Jul 1995 12:43:14 GMT
 

|> >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.
|>
|>
|> Hello !
|> The error has got nothing to do with space as in HDD space. It however means,
|> that your kernel ( I'm asuming Unix here ) isn't configured for enough
|> resources.
|> Take a look at the installation guide for Oracle on your platform, concerning
|> shared memory and semaphores, add about 50 %, reconfigure your kernel, reboot,
|> and I'll bet you can get your databases to run concurrently.
|>
|> Regards Tom Krühlmann
|> tok_at_sni.dk
|>
|>
|> >Thanks advance.
 

|> >Wei
|> >etlwihe_at_etlxdmx.ericsson.se
|> >

in addition to that consider the settings of both databases named processes ....

if you do not have to run many programs on a database why use - lets say - 50 processes?

you have to count both process settings and then tune the settings (in ultrix smmax and smseg) in your unix kernel.

hope that helps

chris

--
Ing. Christian Kaiser     chris_at_reblaus.wu-wien.ac.at
ADV-Abteilung
Vienna University of Economics and Business Administration 

Augasse 2-6,  A-1090 Vienna, Austria		
Tel: +43 (1) 31-336 x4040
***************************************************************************
lifes a beach and then you dive
***************************************************************************

                 |\
 |\              | \                   OoOo
 \ \             \  \                  oOOo
 \  \           /     `~~~--__        oOo
 /   \___----~~'              `~~-_  o _______          __________
 \                         /// (O) `\_(__||___)________/____
 / /~~~~-, ,__.    ,      ///  __,,,,)   ||  o  ______/     \
 \/      \/    `~~~;   ,---~~-_`_= \ \---||--o-'             \
                  /   /            / /                        \
                 |_./            _/_/
                                 /;|\