bonny
Junior Member

Registered: Aug 2002
Posts: 2
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.





08-05-2002 03:01 PM IP: Logged

julian
Senior Advisor

Registered: Jun 2001
Posts: 2942
When you created the database you had remote_login_passwordfile = none. Now, change remote_login_passwordfile = exclusive and startup again.

__________________
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i
email: [email protected]


08-06-2002 02:54 AM IP: Logged

sandycrab
Junior Member

Registered: Jul 2002
Posts: 27
If the solution provided by Julian does not work then check if your service name is correct. It is case sensitive. e.g. 'ORACLE' is different than 'oracle'. So while setting Oracle_sid mention in appropriate case.
All The Best
Sandy
__________________



06 aug 2002
hi Julian & Sandy

The "test" database was created on stand alone PC Which already had oracle installed on that machine.
I used the init.ora file of oracle changing the parameters.But remote_logon_password = was kept shared.
I have checked the service / sid lower /upper case.
But it still has the same problem.?
I am a certified oracle trainer.on some other computers i had the same problem.what i did is given hereunder-
i started oracle database on command propmt.without shutting down oracle ,i forced to start test database using the following command-
startup force pfile= 'c:\......\inittes.ora';
In some cases it started the test database,but some caes the same did not work.
please suggest.
thanks