ORA-600 [kwqpuspse0-ack] In Streams Environment (Doc ID 1165583.1)

Last updated on JUNE 23, 2011

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.4 to 11.1.0.7 - Release: 10.2 to 11.1
Information in this document applies to any platform.

Symptoms

You have Oracle Streams setup in place and noticed following error in the Alert Log file:

ORA-00600: internal error code, arguments: [kwqpuspse0-ack], [], [], []

A trace file for the failed RDBMS Job process is also generated and looks like:

ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kwqpuspse0-ack], [], [], [], [], [], [], []
Current SQL statement for this session:
DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN next_date := sys.dbms_aqadm.aq$_propaq(job); :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END;
----- PL/SQL Call Stack -----
object line object
handle number name
5A8868E8 7235 package body SYS.DBMS_AQADM_SYS
5A8868E8 7513 package body SYS.DBMS_AQADM_SYS
54FEB0BC 978 package body SYS.DBMS_AQADM
5A888958 1 anonymous block
check trace file d:\oracle\product\10.2.0\db_1\rdbms\trace\orcl_ora_0.trc for preloading .sym file messages
----- Call Stack Trace -----
...
_kwqpuspse0
...
_kwqppollack
...
_kwqjlisten
...
_kwqjaq

Changes

Setup Streams propagation.

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