DUPLICATE SYS_GUID generated on AIX can lead to ORA-1 errors during enqueue
(Doc ID 1371805.1)
Last updated on MARCH 04, 2019
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 to 184.108.40.206 [Release 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
IBM AIX on POWER Systems (64-bit)
Very intermittently enqueue operations on an Advanced Queue fail with the following error:
ORA-00001: unique constraint (<Schema>.SYS_C00397880) violated
The constraint referenced by the ORA-1 error corresponds to a unique index defined on the MSGID column of the queue_table within which the data associated with the queue is stored.
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