ORA-24001: cannot create QUEUE_TABLE


Error:

12:23:05:252 WARNING: Old e_DEM_CONN_s was removed from ENGINE_STARTER_LIST
12:23:05:449 ERROR: Failed to initialize notification queue for Engine Starter ID: e_DEM_CONN_s, Status: FAILURE: -24001 ORA-24001: cannot create QUEUE_TABLE, DEMANTRA.E_DEM_CONN_S_OUT already exists, Exiting...
12:23:05:449 Got std::runtime_error in main loop: ERROR: Failed to initialize notification queue
12:23:05:449 Unregistering listener...
12:23:05:452 e_DEM_CONN_s was removed from ENGINE_STARTER_LIST


Reason:

After cloning the demantra database from production starting Engine Starter give queue table error.

Solution:

Drop AQ table
Connect Demantra schema

SQL> exec DBMS_AQADM.DROP_QUEUE_TABLE(queue_table => 'E_DEM_CONN_S_OUT', force => TRUE);
SQL> exec DBMS_AQADM.DROP_QUEUE_TABLE(queue_table => 'E_DEM_CONN_S_IN', force => TRUE);




If you like please follow and comment