Home » Server Options » Replication » Linking databases
Linking databases [message #75154] Mon, 18 March 2002 00:53 Go to next message
Harsha
Messages: 8
Registered: December 2000
Junior Member
How to link databases for replication.
I have 2 servers in Winnt platform. My oracle version is 8i rel 8.1.5.0
First one oraserv1 in domain ora1 with database test and other oraserv2 in domain ora2 with database oratest.
Please help me with settings for global database,
tnsnames.ora & listner.ora.

Report message to a moderator

Re: Linking databases [message #75163 is a reply to message #75154] Mon, 08 April 2002 04:14 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Hi,

An example script is provided at http://www.orafaq.org/scripts/advrepl/repprep.txt. Also see the on-line manuals at http://www.orafaq.org/supsearc.htm and the See Replication FAQ at http://www.orafaq.org/faqrepl.htm.

Best regards

Frank

Report message to a moderator

Re: Linking databases - Repgen sw to generate scripts [message #75184 is a reply to message #75154] Fri, 24 May 2002 16:12 Go to previous message
David Simpson
Messages: 29
Registered: May 2002
Junior Member
I wrote an application called Repgen which automatically generates advanced replication setup, removal and monitoring scripts along with the documentation for the replicated setup. For some Replication setups I have spent literally days writing and testing scripts manually, but now I use Repgen to create them in a few seconds and without any syntax errors.
http://www.dotcomsolutionsinc.net/products/repgen/repgen_features_benefits.html

You might want to look at the sample scripts on my web site:
http://www.dotcomsolutionsinc.net/products/repgen/repgen_files.html

Or you may download a demo version and look at the sample scripts on your own computer:
http://www.dotcomsolutionsinc.net/downloads/demo_software/index.html

One of the critical aspects of Advanced Replication which is automatically handled by the scripts created by Repgen is the setup of conflict resolution. An incorrect setup of the conflict resolution parameters will cause data divergence between the replicated systems - which is not desirable.
http://www.dotcomsolutionsinc.net/products/repgen/repgen_features_benefits.html

Report message to a moderator

Previous Topic: Oracle multimaster replication agents
Next Topic: How can I tune my DB for using whole canal width?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 18:29:25 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.