This content has been marked as final. Show 2 replies
You need to install GoldenGate on both servers and start Golden Gate manager process on both the server. To set up replication, on your source server create extract process and on your target server created replicat process and start these processes... replication done.
For documents, search on oracle.com.
Telling someone they "need" to install an expensive product is bad advice. Although your one over the world view of setting up GoldenGate is technically accurate, it also leaves out quite a bit, using a data pump, as an example.
For the OP:
Do you really mean 11i, as in E-Business Suite, or did you mean 11g, as in the RDBMS?
Your choices are:
Use what you've already paid for - Oracle Streams
License another Oracle product - GoldenGate
Buy a third party tool - Quest Shareplex, as an example
Do your own replication - materialized views, triggers, database links, and so on.