I have been configured two data guard in same server when try to open standby database in mount status .It showing ORA-01102 error.Please guiide me how to achieve primary database and standby database in same server.Which precaution to take care.
Will need more information.
OS and Version
Exact Oracle version
Any errors you find in your database alert logs
This ORA-01102 error indicates an instance tried to mount the database in exclusive mode, but some other instance has already mounted the database in exclusive or parallel mode.
I want configure data guard in same server thats why i created 2 instance using oradim but when i tried to mount standby instance it show me ORA-01102 error.even though I tried to open Primary database in parrallel mode.but standby database cannot be come in mount state.
os is windows 7 ultimate.
There's your problem.
Unsupported OS and version of Oracle in desupport.
You have a couple of options.
1. Run Oracle on a server OS using VMware or alike. You can run Oracle 11 on as little as 1.2GB of RMAN per virtual server and set different IP and such. It makes for a flexible, and cheap test area.
2. Just use a Server OS period.
Windows Ultimate is a workstation OS. Oracle and Data Guard need a server environment. Please consider this change.
I have my own techy rule regarding things like this. "Just because you can, does not mean you should". Supporting Documents
Is Microsoft Windows 7 certified to install/run Oracle Database Server/Client ? [ID 952302.1]
Master Note For Database and Client Certification [ID 1298096.1]