469,266 Members | 2,014 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Replication Of Oracle 9i in RH9

Hello,

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 ?

2) I have heard of certain steps

- Setup users, DB Links and schedules for Oracle Advanced
Replication

- 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)?

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

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).

Pls do help me..... urgent

regards,
Cherrish Vaidiyan
Jul 19 '05 #1
2 3750
Cherrish Vaidiyan wrote:
Hello,

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,
basically.
2) I have heard of certain steps

- Setup users, DB Links and schedules for Oracle Advanced
Replication

- 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
manuals.
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.
--
Regards, Frank van Bortel

Jul 19 '05 #2
Hi,

Can you email direclty, I'll give you a script to setup an example for
multimaster replication.

Dias
un***************@yahoo.com (Cherrish Vaidiyan) wrote in message news:<f0**************************@posting.google. com>...
Hello,

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 ?

2) I have heard of certain steps

- Setup users, DB Links and schedules for Oracle Advanced
Replication

- 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)?

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

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).

Pls do help me..... urgent

regards,
Cherrish Vaidiyan

Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Amy | last post: by
reply 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
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.