Re: Oracle Replication raise ORA-03113 end of communication

Not seen this error do what you describe.

I've seen 'End of Communication Channel' on SQL Plus sessions.

Usually the replication will just fail if there are network problems, and eventually the replication jobs will be 'broken' after 16 attempts.

You can just 'Make Normal' the job in Replication manager (assuming you can now use the DB link correctly)

I think you may be seeing the symptom (large queue) of the cause ('a network problem').

Certainly you can 'Make Normal' a job, when there are 10,000's of transactions in the queue.

I've seen reference to problems occuring if replication can not push all the outstanding transactions within the period between jobs (i.e. a backlog develops), but I've never experienced these.

There are also some issues with NT and TCP/IP that affect replication, especially through firewalls. E-mail me if you are completely lost.

    Simon

Aik Khoon <panadol_at_singnet.com.sg> wrote in message news:86a4ag$6ai$1_at_mawar.singnet.com.sg... Hi,

I urgently need an answer to this question. It seems like the Oracle8 (version 8.0.5.2.1) Advanced
replication (on windows NT) will raise this error ORA-03113 on the deferred queue if
the deferred transaction queue is quite big, for example >300.

Can someone verify this or is there an answer or solution to it besides restarting the database.

TIA Rgds,
AK. Received on Fri Jan 21 2000 - 12:07:56 CST