Re: Problems with semaphores in Sun.

From: Martin Hepworth <maxsec_at_totalise.co.uk>
Date: 2000/03/09
Message-ID: <38C75D3F.DFB26623@totalise.co.uk>#1/1

Julio
I find it best to increase the kernal parameters to 'something huge' on SOlaris systems running Oracle. There's little performance/memory hit in doing so and it means you don't have to re-do them ever again.

Here's mine for a large database...

set priority_paging=1 # works with solaris 7 or 2.6 with a patch # means that data files get paged before executables, can help with systems with low memory.

set shmsys:shminfo_shmmax=4294967295 # max with solaris
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=1024
set shmsys:shminfo_shmseg=1024
set semsys:seminfo_semmap=1002
set semsys:seminfo_semmni=500
set semsys:seminfo_semmns=400
set semsys:seminfo_semmnu=500
set semsys:seminfo_semmsl=500
set semsys:seminfo_semopm=100
set semsys:seminfo_semume=100
set semsys:seminfo_semusz=256
set semsys:seminfo_semvmx=32767
set semsys:seminfo_semaem=16384

set rlim_fd_cur=2048
set rlim_fd_max=8192
set max_nprocs=10000

Increase number of ptys
Number of 5.x pseudo-ptys. set pt_cnt=255 # always worthwhile increasing this

martin

Julio wrote:
>
> Hi all,
>
> We're migrating to Solaris from Digital and I've found a problem with the
> semaphores. As I'm trying to increase the processes more than 35 I get the
> following error at starting up my instance:
>
> ORA-07279: spcre: semget error, unable to get first semaphore set.
> SVR4 Error: 28: No space left on device
> Additional information: 1
>
> The documentation recomends the following:
> 07279, 00000, "spcre: error semget, no se ha podido obtener el primer conjunto
> de semáforos."
> // *Cause: An error occurred when trying to get first semaphore set.
> // *Action: Check errno. Verify that system is configured to have semaphores.
> // Verify that enough semaphores are available. Additional information
> // indicates how many semaphores were requested.
>
> In OSF had no problems with the default values for sempahores but we've changed
> the following values, indicating the rest as default:
>
> set semsys:seminfo_semns=120
> set semsys:seminfo_semmsl=50
> set semsys:seminfo_semmni=30
> set semsys:seminfo_semmap=30
>
> We work with Oracle 7.3.4 in a Sun Enterprise 250 with Solaris 2.6
>
> Any help would be greatly apreciated.
> --
> Julio Negueruela
>
> 'Hay algunas cosas que son tan serias
> que solo puedes bromear con ellas.' (Bohr)
Received on Thu Mar 09 2000 - 00:00:00 CST