Replication Of Oracle 9i in RH9

[Cherrish Vaidiyan]

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

[Frank]

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

[dias]

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