What's your ORACLE_SID set to? Did you add your new database to your
listener? You didn't say how you created the second database.
DBAtracker
@aol.com To: Multiple recipients of list ORACLE-L
Sent by: root <[EMAIL PROTECTED]>
cc:
Subject: (no subject)
02/20/2002
10:53 AM
Please
respond to
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
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
