Home » Server Options » Data Guard » Problem with Dataguard -- ORA-01102: cannot mount database in EXCLUSIVE mode (Oracle9i R2)
Problem with Dataguard -- ORA-01102: cannot mount database in EXCLUSIVE mode [message #330569] Mon, 30 June 2008 08:31 Go to next message
Creems
Messages: 70
Registered: July 2007
Location: Johannesburg
Member
Hi,

I'm trying to create a physical standby database on my Oracle9i DB runing on WinXP.

Note: I have both Primary and Standby on the same system.

Actually everything went well .... I did created the standby DB but the problem is I can not start my primary DB if my standby DB is mounted. I get this error:
ORA-01102: cannot mount database in EXCLUSIVE mode

And when I read about the error message I learnt that I should start my DB in compatible mode ... please how do I do that?

Or possibly how can I make this work.

Regards,

Cherish
Re: Problem with Dataguard -- ORA-01102: cannot mount database in EXCLUSIVE mode [message #330572 is a reply to message #330569] Mon, 30 June 2008 08:43 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Took your title, put it in search field, get:
http://www.orafaq.com/forum/?SQ=f83f44319c383cee4f5f69a8de2f16b8&t=search&srch=ORA-01102%3A+cannot+mount+database+in+EXCLUSIV E+mode&btn_submit=Search&field=all&forum_limiter=12&search_logic=AND&sort_order=DESC&author=

Check these links.

Regards
Michel
icon14.gif  Re: Problem with Dataguard -- ORA-01102: cannot mount database in EXCLUSIVE mode [message #330919 is a reply to message #330569] Tue, 01 July 2008 15:04 Go to previous messageGo to next message
gaperumal
Messages: 8
Registered: June 2008
Location: Chennai India
Junior Member
Hi
Same host, that too in windows, will create the problem like this. Better go for two different hosts. I have tried and failed. I was able to setup in two hosts successfully.

Thanks,
Arangaperumal
Chennai,INDIA

[Updated on: Tue, 01 July 2008 15:05]

Report message to a moderator

Re: Problem with Dataguard -- ORA-01102: cannot mount database in EXCLUSIVE mode [message #331013 is a reply to message #330919] Wed, 02 July 2008 02:44 Go to previous messageGo to next message
Creems
Messages: 70
Registered: July 2007
Location: Johannesburg
Member
Hi,

Actually I thank you for your contribution.

But it finally work on same host maybe you gave up too soon.

Regards,

Cherish
Re: Problem with Dataguard -- ORA-01102: cannot mount database in EXCLUSIVE mode [message #463182 is a reply to message #331013] Wed, 30 June 2010 02:12 Go to previous messageGo to next message
dba4oracle
Messages: 100
Registered: June 2010
Senior Member
Hello
Hello please let me know how your issue is resolved

I am using windows oracle 11g i am trying to implement dataguard on same machine (primary and standby db on same machine)
I follow steps as below:

1)force logging primary
2)shutdown primary copy all datafiles to standby filesystem
3)editing listener and tnsnames for both primary and standby
4)editing init.ora for both primary and standby(for standby
modified and used init.ora of primary so db name etc same,only
parameters as below changed:
Primary:
=======


log_archive_dest_1
log_archive_dest_2
log_archive_dest_state_1
log_archive_dest_state_2
fal_client
fal_server
archive_lag_target
_log_archive_callout
#standby_archive_dest= ## UncDB1ment after switchover ##
#standby_file_management=auto ## UncDB1ment after switchover ##
#log_archive_dest_state_2=DEFER ## UncDB1ment after switchover ##

Standby:
=======
log_archive_dest_1=
log_archive_dest_state_1
log_archive_dest_2=
log_archive_dest_state_2=
standby_archive_dest=
standby_file_management=auto
fal_client=
fal_server=

Am i missing something or doing anything wrong please suggest

thanks
Re: Problem with Dataguard -- ORA-01102: cannot mount database in EXCLUSIVE mode [message #463183 is a reply to message #463182] Wed, 30 June 2010 02:13 Go to previous message
dba4oracle
Messages: 100
Registered: June 2010
Senior Member
sorry i forget to add i also made standby control file and configured on standby
Previous Topic: fast-start failover in data guard
Next Topic: Creating Standby database in same HOST (SUN )
Goto Forum:
  


Current Time: Thu Mar 28 07:27:48 CDT 2024