Queue Table Ownership not Falling back to the Primary Instance
(Doc ID 2825731.1)
Last updated on APRIL 17, 2023
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
Queue table has primary_instance = 6 and secondary_instance = 7, but its owner_instance remains = 10 even after primary instance (6) is up and running:
ORA-27476: A database object was specified that does not exist.
The expected behavior is that once the primary instance is up in a RAC environment, queue ownership should fall back to the primary instance instead of getting ORA-27476 during re-partitioning.
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