| ORA-01102: cannot mount database in EXCLUSIVE mode [message #99437] |
Fri, 09 November 2001 18:51  |
Tushar Nerurkar
Messages: 4
Registered: November 2001
|
Junior Member |
|
|
Dear All,
I have Oracle 8.1.6 and 4 instances on that.
If I try to restart the instances through svrmgrl. I am unable to start the instances. Its gives me error "ORA-01102: cannot mount database in EXCLUSIVE mode". How can i start instances manually?
Regards
Tushar
----------------------------------------------------------------------
|
|
|
|
| Re: ORA-01102: cannot mount database in EXCLUSIVE mode [message #99438 is a reply to message #99437] |
Fri, 09 November 2001 23:49  |
Suresh Baral
Messages: 11
Registered: October 2001
|
Junior Member |
|
|
Hi
There is some conflict between instance-names & database-names. So u check these and if necessary make some unique names for these. So after reboot the system, manually u have to startup all these instances. So before u run svrmgrl for each instances, u have to set environmental variable i.e. oracle_sid=.....
Good luck.
Suresh
----------------------------------------------------------------------
|
|
|
|
|
|
| Re: ORA-01102: cannot mount database in EXCLUSIVE mode [message #142636 is a reply to message #101377] |
Mon, 17 October 2005 00:48 |
hailua19
Messages: 1
Registered: October 2005
|
Junior Member |
|
|
i've come aross this situation. My Oracle database server was not setup in Paralell Mode, but there were 2 db existing in the same server.
In this case, to start up the database must specify pfile
Syntax: startup pfile = <physical path of the ora file>
OS: Windows 2k
Oracle db: 8.1.7
Hope this can help.
|
|
|
|
| Re: ORA-01102: cannot mount database in EXCLUSIVE mode [message #240426 is a reply to message #142636] |
Thu, 24 May 2007 16:25 |
naraparajus
Messages: 1
Registered: May 2007
Location: Washington DC
|
Junior Member |
|
|
Hi,
I got the same error on Oracle 10g DB. I have three databases on the same machine.
I stopped two of the services and used the following from command prompt.
set oracle_sid=the active sid name
sqlplus /nolog
At the sqlprompt...
connect sys as sysdba
startup force pfile='.....' from the command prompt
and it worked!
Then I started the next service by setting
ORACLE_SID=mysid and did the same steps as above.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
