[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1850
  • Last Modified:

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.
0
gizmosan
Asked:
gizmosan
  • 3
  • 3
1 Solution
 
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
 
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 new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
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

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now