I HAVE STANDLONE PC HAVING ORACLE DATABASE -8I INSTALLED ON WINDOWS NT.
I CREATE ANOTHER DATABASE ON THE SAME PC SAY-"TEST" USING DIFFERENT SERVICE AND SID.DATABASE GETS CREATED .I CAN RUN CATLOG AND CATPROC SCRIPTS ALSO AND CREATE TABLESPACES AND USERS.

BUT WHEN I SHUTDOWN AND TRY TO CONNECT AGAIN USING PFILE,IT GIVES ERROR-
ORA-01102 UNABLE TO MOUNT DATABASE IN EXCLUSIVE MODE.
ANY SUGGESTION.?


08-04-2002 01:08 PM IP: Logged

stecal
Advisor


I don't find sgadef.def & ik.def files on my system.
It did not work as other database was shutdown properly.
Plaese advise.
Thank
BONNY

=====================

The "lk" and "sgadef.dbf" files are used for locking shared memory.
It seems that even though no memory is allocated, Oracle thinks memory is
still locked. By removing the "sgadef" and "lk" files you remove any knowledge
oracle has of shared memory that is in use. Now the database can start.