Re: # semaphors used by ORACLE

From: <dhuet_at_DHUET-PC>
Date: Wed, 28 Sep 94 18:23:38 EDT
Message-ID: <36crd0$jq2_at_dcsun4.us.oracle.com>


In article <35ve19$5p8_at_pandora.sdsu.edu>, <gtupper_at_monkfish.nosc.mil> writes:
> Path:

dcsun4.us.oracle.com!gatekeeper.us.oracle.com!sgiblab!swrinde!howland.reston.an s.net!usc!nic-nac.CSU.net!newshub.sdsu.edu!monkfish!gtupper
> From: gtupper_at_monkfish.nosc.mil (Greg Tupper)
> Newsgroups: comp.databases.oracle
> Subject: # semaphors used by ORACLE
> Date: 23 Sep 1994 20:32:41 GMT
> Organization: San Diego State University, College of Sciences
> Lines: 15
> Message-ID: <
35ve19$5p8_at_pandora.sdsu.edu>
> NNTP-Posting-Host: monkfish.nosc.mil
> X-Newsreader: TIN [version 1.2 PL2]
>
> We have an oracle 7 db on an hp 9000/700 and would like to build another. In
> the attempt we get a "Not enough semaphores" error of some sort (I do not
 have
> the test handy.) I know how to get the number of semaphores on the machine,
> but I do not know how to get the number of semaphors oracle is using.
>
> Anyone have a solution?
>
>
> Thanks
>
>
> Greg Tupper
> SAIC Comsystems
>
> gtupper_at_nosc.mil

The easiest solution is to simply double the number of semaphore items in the Unix kernel that Oracle recomends for your particular platform. This has always worked for me when creating more than one instance on a Unix machine.

David Huet
Oracle Complex Systems Received on Wed Sep 28 1994 - 23:23:38 CET

Original text of this message