469,366 Members | 2,306 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,366 developers. It's quick & easy.

Reply: Replication Of Oracle 9i in RH9

Frank <fb*****@nescape.net> wrote in message news:<bq**********@news1.tilbu1.nb.home.nl>...
Cherrish Vaidiyan wrote:

I have certain doubts regarding replication of Oracle 9i in Red Hat
Linux 9.

1) I want to implement asynchronous/synchronous multimaster
replication.I have heard about Replication Management Tool in OEM.
What are the steps to be taken initailly for using Replication
Management Tool ?

What - synchronous or async?
The OEM RMT helps setting up a replication environment. Point-and-shoot,
2) I have heard of certain steps

- Setup users, DB Links and schedules for Oracle Advanced

- Define replication groups with replication objects

- Remove replication support from database

- Monitor replication status, sites and groups.

Can anyone tell if for is the steps above are in order? If so, is
there any scripts to perform the above steps or do I have to use SQL
commands one bye one (for user creation, giving previlege)?

Yes - if you want to (I am all for that, and not for using OEM RMT)

3) Do anyone have the scripts or configuration procedure, who can
share with me.

Would be of little value, as your situation will not be mine, your
tables will be different, your requirement different, etc, etc, etc.

There are wonderful examples -scripts included- in the replication
4) Can anyone help me with the reference books which can help a
beginner like me to learn and implement all replications based on
situation? (I have got the concept,types,architecture through the
internet but I need to know what procedure to follow in SQL commands).

See tahiti.oracle.com (or docs.oracle.com), look for the replication
manuals - yes, plural!

Not one of the easiest fields for a beginner, though.


I want to implement replication by means of SQL commamnd prompt.Can u
help me with the sample script that you own.I can change the schema,
tables according to my need...Here is my situation of replication

I have 3 systems with RH 9. A database of Oracle 9i is to be
replicated in the 3 pc.
I thought of Synchronous replication first where a change made once in
a database is updated immediately in all the rest. but the drawback is
that if 1 database server is down the update wont work ie it will
rollback.but it wont have any conflicst if all servers are up.

But, I dont want rollback situation. So I want to implement
Asynchronous replication which means that a change made will be stored
initally as deferred transaction (I think v can set time for updates
say for 2 seconds etc.ie; every 2 sec cache and database will be
updated...but i dont know the paramaeter to set)and later updated in
all database.I know in such case I know in that case i have to handle
conflicts (that the second phase). but wont check if all the database
servers are up.

Hope u have understood my need and would help me ...pls reply
Cherrish Vaidiyan
Jul 19 '05 #1
0 2014

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Amy | last post: by
2 posts views Thread by Cherrish Vaidiyan | last post: by
2 posts views Thread by Andras Kovacs | last post: by
1 post views Thread by RYAN | last post: by
3 posts views Thread by steve | last post: by
15 posts views Thread by Pailloncy Jean-Gérard | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.