Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to increase semaphores in NT.
Parag wrote:
> Setup:
> OS NT 4 Server
> Oracle 8.1.6
> five instances already running on the server.
>
> started new service through oradim command.
> copied "hot backedup" dbf files and tried to create control file.
> Bombs off with the included error message in alert file.
>
> NOTE:The original controlfiles had been deleted before the create
> controlfile statement is run. Rebooting the server, I can create the
> controlfile and proceed peacefully.looks like it allocates extra
> semaphores during reboot.
>
> Qn: How can I get the present semaphore value and how can I set it to
> a high value ?
>
> Thanks in advance
> Parag
> ========================================================
>
> Mon Oct 07 13:04:14 2002
> ORA-09341: scumnt: unable to mount database
> OSD-04400: unable to acquire internal semaphore for process
> O/S-Error: (OS 183) Cannot create a file when that file already
> exists.
>
> Mon Oct 07 13:04:14 2002
> ORA-1503 signalled during: CREATE CONTROLFILE REUSE DATABASE "ORCL"
> NORESETLO...
> Mon Oct 07 13:04:14 2002
> alter database mount
> Mon Oct 07 13:04:14 2002
> ORA-09341: scumnt: unable to mount database
> OSD-04400: unable to acquire internal semaphore for process
> O/S-Error: (OS 183) Cannot create a file when that file already
> exists.
>
> ===========================================================
Why? Why 5 instances on a single server? What's wrong with one instance and five databases?
Or better yet one instance, one database, and 5 schemas?
Some perverse desire to fragment memory into multiple SGAs?
Daniel Morgan Received on Mon Oct 07 2002 - 13:06:23 CDT