RE: (no subject)

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-----
DBAtracker_at_aol.com
Sent: Wednesday, February 20, 2002 7:54 AM To: Multiple recipients of list ORACLE-L

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? Thanks!
Bill Johnson

Content-Type: text/plain; name="ReadMe.txt"; charset="us-ascii" Content-Transfer-Encoding: 7bit

The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail.

This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact Postmaster_at_fatcity.com for clarification.

------_=_NextPart_000_01C1BA33.B02E3040--

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: JoJo Al-Zawawi
  INET: jojo_at_jojo-zawawi.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



application/octet-stream attachment: CONTROL.SQL