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 30, 2021
Applies to:
Oracle Database Cloud Schema Service - Version N/A and laterGen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
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 worker processes can report ORA-00600: [kwqitnmptme:wait/done/exp], [0]. This error can be worked around using the manual update method mentioned in internal Note 361089.1.
- Messages can be dequeued out of order.
Changes
Databases had been upgraded from 9.2 to 10.2.
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 |