SUMMARY: Semaphores/Oracle related one

No clear answer (only Gods know what's Oracle intending). General consensus is to upper the number of
semaphores in system, but no one has an idea about what's going on. I'll do it, as there are low memory quantities involved. Many thanks.

Patricio Mora escribis:

> I think it's an Oracle issue, but I want to ensure...
>
> SEMAPHORES AVAILABLE:
> frodo# grep semsys /etc/system
> set semsys:seminfo_semmni=100
> set semsys:seminfo_semmsl=800
> set semsys:seminfo_semmns=2000
>
> frodo# ipcs -as
> IPC status from <running system> as of Mon Mar  4 15:24:17 2002
> T         ID      KEY        MODE        OWNER    GROUP  CREATOR   CGROUP NSEMS   OTIME    CTIME
> Semaphores:
> s     131072   00000000 --ra-r-----  oracle8  oracle8  oracle8  oracle8    70 15:18:36  5:56:16
> s     262146   0x00000078 --ra-ra-ra-  oracle8  oracle8  oracle8  oracle8     1 no-entry  5:56:45
> s     327683   00000000 --ra-r-----  oracle8  oracle8  oracle8  oracle8   100 14:04:22  8:16:25
> (IDs not real)
> I STILL HAVE 1829 FREE
>
> STARTING A 800 PROCESSES DATABASE:
> SVRMGR> startup
> ORA-07279: spcre: semget error, unable to get first semaphore set.
> SVR4 Error: 28: No space left on device
> Additional information: 1
>
> frodo$ oerr ora 07279
> ERRFILE= /oracle8/rdbms/mesg/oraus.msg
> 07279, 00000, "spcre: semget error, unable to get first semaphore set."
> // *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.
>
> Shutting down the instance with 100 semaphores is enough to the 800's one succesful startup. I had heard Oracle 8.0 uses double number of semaphores on startup, and late it frees half of them. But I had enough even with this assumption. What's the key ? Have the whole sem set to be contigous in memory? Is oracle asking for more than 1829?
>
> Solaris 2.6. Oracle 8.0.6.3.0. Now sems are:
> frodo# ipcs -as
> IPC status from <running system> as of Mon Mar  4 15:24:17 2002
> T         ID      KEY        MODE        OWNER    GROUP  CREATOR   CGROUP NSEMS   OTIME    CTIME
> Semaphores:
> s     131072   00000000 --ra-r-----  oracle8  oracle8  oracle8  oracle8    70 15:18:36  5:56:16
> s     131073   00000000 --ra-r-----  oracle8  oracle8  oracle8  oracle8   800 15:24:16  8:14:51
> s     262146   0x00000078 --ra-ra-ra-  oracle8  oracle8  oracle8  oracle8     1 no-entry  5:56:45
> s     327683   00000000 --ra-r-----  oracle8  oracle8  oracle8  oracle8   100 14:04:22  8:16:25
>
> Thanks in advance.
> _______________________________________________
> sunmanagers mailing list
> sunmanagers@sunmanagers.org
> http://www.sunmanagers.org/mailman/listinfo/sunmanagers
_______________________________________________
sunmanagers mailing list
sunmanagers@sunmanagers.org
http://www.sunmanagers.org/mailman/listinfo/sunmanagers