RE: synchronizing database on linux and windows ?

I'm a bit confused by your use of the phrase "so that data on both the databases are synchronous" together with the subject line "synchronizing."  

In the thread you've been given a few suggestions about ultimately "synchronizing" your databases (together with appropriate caveats about what might be appropriate depending on your load and volume).  

However, if you truly want the data on both databases to be synchronous, and since you cannot RAC across different platform types, you will need to utilize two phase commit in your application.  

Oracle's two phase commit protocol is razored down to extreme efficiency compared to what must be done to achieve the goal. Even so, it is a high overhead if you don't truly need synchronization.  

What is your real service level requirement? Is there an acceptable non-zero lag time during which the databases may diverge as updates arrive? Are updates allowed at both locations? Might conflicting updates be attempted at different locations? (If so, you'll need a tie breaking protocol.)  

Regards,  

mwf  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of nilesh kumar
Sent: Monday, September 10, 2007 9:13 AM To: oracle-l_at_freelists.org
Subject: synchronizing database on linux and windows ?  

Hello All,

I have installed oracle 10g on windows and on linux on two different machines, I need to create a application in which, through front end any changes made to the database on windows that changes need to be reflected on the database on linux so that data on the both the database are synchronous. Could any one help me how shall I proceed.

 Thanks

 Nilesh Soni  

--
http://www.freelists.org/webpage/oracle-l