Re: Replication Of Oracle 9i in RH9

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