can't mount the instance. PLEASE HELP IT's URGENT

[ashley75]

I am running 8.1.6 on NT , I am running NOARCHIVE on the database. The backup running last night from the backup unit and I have the scripts to startup the instance.



this is part of my alert log


PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
SNP0 started with pid=8
SNP1 started with pid=9
SNP2 started with pid=10
SNP3 started with pid=11
Fri Mar 08 02:58:21 2002
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Fri Mar 08 02:58:22 2002
alter database mount
Fri Mar 08 02:58:22 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.




Please help it's urgent.

this is a standalone database, we don't run parellel

[ashley75]

JEFF or JILIAN or any senior member , please help

[julian]

You should not try to startup instances on the same machine having the same db_name.

The name of the semaphore, scumntsem_, is created on mounting the database.

When starting another instance, even with a different
ORACLE_SID, the same DBName will cause a conflict with
the existing semaphore.

Do you have a standby DB on the same machine?

[ashley75]

Jilian,

as I mentioned earlier on my first email, this is a standalone database.

The only thing I could thing off is that we have the shutdown and startup scripts on our backup server to startup and shutdown the database.

I did stop and restart the service and it doesn't help


Please advise

[ocpwannabe]

shutdown the database, stop all services, reboot the box, and start back up.

[aarroyob]

Look from metalink:

Error: OSD 4400
Text: unable to acquire internal semaphore for process
---------------------------------------------------------------------------
Cause: Too many ORACLE processes active, maximum number of connections
exceeded
Action: Delete unused connections, try again

And as I think your platform is NT, if this say nothing to you, the best option with MS when you have not idea of the problem is to shutdown the server and restart

Regards

Angel

[Shestakov]

This situation:
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.
may be if any other programm(s) open one or more control files
or
WinNT stay control file in undefined(locked) stage

[julian]

Try that: shutdown abort, stop the services, reboot the computer and startup.

[aarroyob]

Originally posted by julian
Try that: shutdown abort, stop the services, reboot the computer and startup.

Yah, and you should pray a bit

Good Luck

Angel

[ashley75]

Thank you all,

I did stop the service , shutdown and startup the database etc....


I will try to reboot the server