ORA-01866 reported on enqueue and ORA-00600: [KWQITNMPTME:WAIT/DONE/EXP] reported by the Queue Monitor processes when enqueing into a TRANSACTIONAL queue
Last updated on OCTOBER 02, 2014
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.1 to 188.8.131.52 [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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms