ORA-600 [kwqpuspse0-ack] In Streams Environment
(Doc ID 1165583.1)
Last updated on FEBRUARY 27, 2019
Applies to:
Oracle Database - 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 <trace_location>\db_name_ora_0.trc for preloading .sym file messages
----- Call Stack Trace -----
...
_kwqpuspse0
...
_kwqppollack
...
_kwqjlisten
...
_kwqjaq
Changes
Setup Streams propagation.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |