gizmosan
asked on
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
ASKER
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.
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.
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
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
ASKER
Tom,
Thanks a lot for solving my problem.
Jacob
Thanks a lot for solving my problem.
Jacob
ASKER
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.