ORA-02068/ORA-03114/ORA-03113 Errors From Streams Propagation Process - Remote Database is Available and Unschedule/Reschedule Does Not Resolve (Doc ID 564649.1)

Last updated on MAY 12, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.8 to 11.2.0.2 [Release 9.2 to 11.2]
Information in this document applies to any platform.

Symptoms

In a Streams replication environment, Streams propagation stops working with the following errors at the source:

ORA-02068: following severe error from PROD2
ORA-03114: not connectd to ORACLE
ORA-02068: following severe error from PROD2
ORA-03113: end-of-file on communication channel
ORA-02068: following severe error from PROD2
ORA-03113: end-of-file on communication channel


At the target, the trace files appear with the following content, but they do not occur at the same time as the errors on the source and are intermittently produced:

kwqphwmcbk: Source queue name NULL, flag = 0, action = 2

 

At the time of this writing, it is unclear if they are associated with the propagation problem, though the trace file message does refer to Streams propagation components.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms