I'm also a brand new
student of Oracle. The EXACT same thing happened to me in class a couple
of weeks ago when I created a 2nd database.
The reason it
happened was that I didn't create the DB all in one day...and when I went in on
the 2nd day to finish it, I did not startup the 2nd database before
continuing to run the scripts, etc. So, the default database started and
then some of the commands/scripts actually modified the default database's
control files, etc. It was a real mess. We couldn't mount to delete
certain files, yet we couldn't delete certain files in nomount, etc. The
teacher had me run the attached script, and that fixed it. And I learned
some more lessons, hahaha!
I don't know if this
is what happened to you, but since your situation is EXACTLY like mine, error
messages, etc., I would suspect this. So check out the attached script and
maybe it'll help.
You'll have to
modify the .sql file to replace with your database names. In the existing
file, "will" is the default database and "test" is the database I was
creating. Check through and fix up filenames, paths,
etc.
--JoJo
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED]
Sent: Wednesday, February 20, 2002 7:54 AM
To: Multiple recipients of list ORACLE-L
Subject: (no subject)
I'm a
student dba'r running 9i on windows xp. I have created a second database
(database name=bill, instance name = bill). After I first created it, I
tried to mount it after shutting down the installation seed database
(database name = orcl, instance name = orcl). I kept getting the message
'cannot mount database in exclusive mode'. After several attempts to get
out of exclusive mode, I gave up. The next night, without making any
changes, I tried again and this time I was sucessful in mounting the bill
database. I created a data tablespace (data) and four tables which I
populated. Then I queried the database name from v$database and got
the response 'bill'. Next I queried the instance name from v$instance and
got 'orcl' when I should have gotten 'bill'. I double checked the database
name and again got 'bill'.&nbs! ! p; How can this be? But the real
problem is that when I tried to mount the database bill again tonight, I again
got the message ''cannot mount database in exclusive mode'. I can't find
an explanation for this in the book. I tried to startup nomount using the
'bill' pfile which showed an idel instance started. Then I tried to issue the
alter database mount parallel command but it comes back with the 'cannot mount
database in exclusive mode'. When I then query the instance_name from
v$instance I get orcl instead of bill. Can any one help me
out?From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED]
Sent: Wednesday, February 20, 2002 7:54 AM
To: Multiple recipients of list ORACLE-L
Subject: (no subject)
Thanks!
Bill Johnson
CONTROL.SQL
Description: Binary data