ORA-01102:cannot mount database in EXCLUSIVE mode

Hello,
1)Thanks to markqeer,bkowalski and meowsh.  I am really appreciative of your help.
2)Now that I can connect to my new database DB5.  I got an error ORA-01102:cannot mount database in EXCLUSIVE mode when tried to open.  The yellow light went on(Instance Started).  I am sure I didn't check the option EXCLUSIVE when create this instance.
Can somebody help?
Thanks.
gizmosanAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

tbcoxCommented:
This is a false error -- it thinks you're trying to set up a Parallel Server (like on a VAX cluster) -- because you're trying to MOUNT the database but there's still a defunct Oracle process running, with a file lock on at least one datafile.

Either kill the defunct Oracle process, or restart the machine.  Then try a fresh restart.

 -Tom
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
gizmosanAuthor Commented:
Tom,
I reboot the server, login instance.  I got
MGR-03514:unable to start the database
ORA-00205:error in identifying controlfile, check alert log for more info
I tried to look for the log file(alert.*) but couldn't find it.
Any suggestions?  Thanks.
0
tbcoxCommented:
Alert logs are written to BACKGROUND_DUMP_DEST, or by default to $ORACLE_HOME/dbs -- look for a recent file with 'alert_SID.log' as a name, where SID is your database system identifier.  My APRD database has an alert_aprd.log file.

The INIT.ORA or CONFIG.ORA need to say where the controlfile(s) is(are).

You may need to say this in Server Manager: STARTUP PFILE=my_init_ora_file

Tell me what you find.
 -Tom
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

gizmosanAuthor Commented:
Tom,
Please allow me to start from the very beginning.  I used oradim80 to create a new instance DB6 and specified the password as 'test'.  The instance was created successfully.  I then launched New8 Assistant to create a service.  Service Name = DB6, Networking Protocol = Bequeath(I did this at server), Database SID = DB6.  To me, the tricky part is what I should use for Username and Password to test the service.  Is there a default admin username for a new instance?  Is the password the one I entered when creating the instance?
I use internal/oracle, sys/change_on_install, system/manager and get the same error :ORA-01034:ORACLE not available.
Thanks.
0
tbcoxCommented:
The ORA-1034 is irritating -- you could have a perfectly good username and password but not know it because Oracle is not even checking it.

Your INTERNAL password should be whatever password you entered during database creation; it will also be the password for the SYS user.

Do you have SVRMGRL or SVRMGR23 or a similar program?  That program can connect to the database even when it is not yet started, but only as INTERNAL (usually).

To reset the INTERNAL password, there is a program named ORAPWDxx you can use from a DOS prompt.  Try it if SVRMGRxx won't let you CONNECT INTERNAL.

 -Tom
0
gizmosanAuthor Commented:
Tom,
Thanks a lot for solving my problem.

Jacob
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.