Re: Creating new instance

From: Fredrick Rustum <fredrick.rustum_at_tele2.se>
Date: Thu, 16 Sep 1999 10:28:07 +0200
Message-ID: <AO1E3.1728$yU2.4341@nntpserver.swip.net>

Hi,

SHMMAX
SHMMIN
SHMMNI
SHMSEG ex set shmsys:shminfo_shmmax=535242435

But I would recommend you to use one database for several purposes, use different schemas instead
of just creating more instances.

>fabriceh wrote in message <7rq6kr$enr$1_at_oceanite.cybercable.fr>...
>>
>>I use Oracle 7 on SCO Unix.
>>I still have 2 instance running.
>>I want to create a third.
>>But when the two first are started, and I try to create another one I get
:
>>ORA-7279: spcre: smget error, unable to get first semaphore set.
>>AT&T System V/386 Error: 28: No space left on device
>>
>>When I have one Instance down, I can create another one.
>>But after I can run only 2 together.
>>When I start the third I get :
>>ORA-7252: spcre: smget error, could not allocate semaphores.
>>AT&T System V/386 Error: 28: No space left on device
>>
>>I have enough RAM memory (96 Mo), and enough disk space.
>>I tune the shared_pool_size, but even with very small set it doesn't work.
>>
>>I certainly have to tune Unix parameters to get more semaphores, but which
>>one ? I'm not expert in unix administration.
>>
>>Any advices ?
>>Thanks
>>Fabrice.
>>
>>
>
>
Received on Thu Sep 16 1999 - 03:28:07 CDT