Re: Oracle Replication

As the generated objects are not getting created you won't get the replication.

run repcat.sql( The file name is respective to UNIX i am not sure about the NT) file again and make sure that each package in the repcat.sql has created succesfully.

Vijay

aaa wrote:
>
> Recently I have been asked to set up replication between two NT boxes (I
> know, I prefer UNIX too). I am an experienced Oracle DBA but after a few
> hours of trying to get replication to work I had to keep reminding myself
> of this to keep my spirits up. I was hoping someone might have some
> personal insights as to how to get replication working for the first time.
>
> The Primary goal for the systems was to offer some measure of load
> balancing and provide fault tolerance in the event of a single environment
> failure (7x24 operation).
>
> Specifications:
>
> - Replicate all table data between two geographically separated
> environments (T-1 network line).
>
> - If object definitions could be replicated all the better but not
> necessary.
>
> - Updates will occur in either environment simultaneously (volume is
> relatively low 1000 transactions / day / environment).
>
> - The application accessing the database environments would still have to
> be operational in the case of either system going down.
>
> My Approach:
>
> I thought it would be a snap using Oracles replication manager but nothing
> seems to be replicating in the two environments after setting up my Master
> groups. I have repeatedly selected generate objects and resume replication
> with no effect. There aren't even any generated objects showing up in the
> generated objects folder (perhaps a clue).
>
> I read Oracle's Distibuted Systems Volume II: Replicated Data book and BBS
> 2546 article and thought I was religiously following the directions but
> obviously not.
>
> Any personal insights would be appreciated.
>
> Mark
> mlgraham_at_bellsouth.net
>
>
>
Received on Sun May 11 1997 - 00:00:00 CDT