Re: Semaphores on W2K

joel-garry_at_home.com (Joel Garry) wrote in message news:<91884734.0405271332.1b6f4d33_at_posting.google.com>...
> From the alert log on an otherwise problem-free 9.0.4 infrastructure
> V9.0.1.5.1 database, starting up after an OS restart:
>
> alter database mount exclusive
> Thu May 27 10:15:34 2004
> ORA-09341: scumnt: unable to mount database
> OSD-04400: unable to acquire internal semaphore for process
> O/S-Error: (OS 997) Overlapped I/O operation is in progress.
>
> Thu May 27 10:15:39 2004
> Successful mount of redo thread 1, with mount id 2130186692.
> Thu May 27 10:15:39 2004
> Database mounted in Exclusive Mode.
> Completed: alter database mount exclusive
> Thu May 27 10:15:39 2004
>
> The services listing of this db was stuck at "starting" and I could
> connect as sysdba in sqlplus in a dos box, but couldn't shutdown.
>
> Would someone be so kind as to explain semaphores on Windows?
>
> http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=176354.1
> doesn't exactly explain what the problem is, although I could guess a
> timing issue starting up the listener.
>
> jg

Joel,

I think that you may have 2 oracle processes for the same instance in a non-RAC config. Grab a copy of Process Explorer from the SysInternals site
http://www.sysinternals.com
You'll see the Semaphores listed as
\NamedBaseObjects\*scumntsem_%ORACLE_SID% but there is not much detail displayed for the semaphores.

here is a link to an article on the msdn site: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dllproc/base/semaphore_objects.asp

hth.

Pd Received on Fri May 28 2004 - 10:37:15 CDT