Hello,
I am a newbie to Oracle. Since Oracle can run on many operating systems, are there any issues in replication of data among Oracle databases based in different operating systems?
No it should not be. Replicating data bypasses the operating system. WhatI mean is that when you replicate data between Oracle instances on the same or different O/S you are only interacting with Oracle which in effect an application (i.e Oracle binary) running on the O/S. Also bear in mind you can also replicate among heteregeneous RDBMS, for example, between Oracle and Sybase. So it does not matter where your RDBMS is sitting (Linux, Solaris, AIX, Windows etc). Indeed one of the areas that we use data replication is when for instance you are migrating from Oracle on Solaris to Oracle on Linux. You use export/import to sync the data in tables first and then turn on replication to keep data in sync between a table on an instance on Solaris and the same on Linux. Once you are happy that all is OK, you turn off replication and decomission Oracle on Solaris.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.