Re: symmetric replication

have you setup all the dblinks etc ? if you login as repadmin,surrogate and schemauser
can you select * from global_name_at_remotemaster ? is global_names set to true ?
you can push the repcatlog queue - select job, what from dba_repcatlog shows the job you
need to execute
have you setup all your init.ora params e.g. job_queue_processes, distributed_transactions
etc there's about 8-10 you need to setup (more for oracle 8)

hth
regards
brian

"DHT" <dht_at_on.aibn.com> wrote in message news:3AC8DF39.6DD846C6_at_on.aibn.com...
> Hi,
>
> I am trying to do symmetric replication(Oracle 7.3) with two instances
> running on the same HP-UX machine(OS 10.20). After setting up three
> users with appropriate privilleges(REPADMIN,SURROGATE and SCHEMAUSER) on
> two sites (Master def. and Master dest.), I do the following on master
> definetion site:
>
> 1. Create repgroup
> 2. Create repobject
> 3. Generate replication support
> 4. Add master database
>
> On examining the dba_repcatlog, following are the entries on Master def.
>
> 1. CReate Repobject.........Status Await_Callback
> 2. Generate Rep. Support...... Await_callback
> 3. Add Master database .......... Await_callback.
> 4. Add Master database .......... Ready
>
> On the master destination:
>
> 1. CReate Repobject.........Status DO_Callback
> 2. Generate Rep. Support...... Ready
> 3. Add Master database .......... Ready
>
> This never changes as if every thing is in hung situation.
>
> I can observe in LISTCTL that every 10 minutes, Master Dest. is
> establishing conact with Master Def. but nothing is going in the other
> direction. There are no error messages anywhere to be found.
>
> If anybody can help .....Thanks in advance
>
>
> Ashok
> dhttech_at_netscape.net
>
Received on Wed Apr 04 2001 - 12:33:52 CEST