ORA-01866 reported on enqueue and ORA-00600: [KWQITNMPTME:WAIT/DONE/EXP] reported by the Queue Monitor processes when enqueing into a TRANSACTIONAL queue
(Doc ID 1053752.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.1 to 18.104.22.168 [Release 10.2 to 11.1]
Information in this document applies to any platform.
Messages are being enqueued into a DBMS_AQADM.TRANSACTIONAL queue table either via propagation or a standalone enqueue session.
The groups of messages are enqueued with the message property delay set.
A variety of error messages may be reported or symptoms arise:
- On enqueue ORA-01866: the datetime class is invalid is reported. This error does not prevent the messages from being enqueued.
- After the messages have been enqueue the qmon slave processes can report ORA-00600: [kwqitnmptme:wait/done/exp], . This error can be worked around using the manual update method mentioned in internal Note 361089.1.
- Messages can be dequeued out of order.
Databases had been upgraded from 9.2 to 10.2.
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