Re: Creating new instance

SHMMAX determines only the Maximum Shared Memory Segment and not the semaphores ..He needs to increase SEMMNS ( the no of Semaphores in the System) and/or SEMMNI ( the no of Semaphore Set Identifiers in the System ).

Also SEMMSL should be greater or equal to the maximum no of All Oracle Processes in the System..

-Thiru

Fredrick Rustum wrote:

> 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 - 09:31:31 CDT