My Oracle Support Banner

auque2.sql Ends with "ORA-24010: QUEUE SYS.AQ_SRVNTFN_TABLE_Q_1 does not exist" Error (Doc ID 2822449.1)

Last updated on NOVEMBER 18, 2021

Applies to:

Oracle E-Business Suite Technology Stack - Version 12.1.3 and later
Information in this document applies to any platform.


When running auque2.sql script to reset Advanced Queue by reviewing below document, script end in below error.

Export/Import EBS release 12.0 or 12.1 with RDBMS 12c (<Document:1585256.1>)
Section 5: Update the imported Release 12 database instance
1. Reset Advanced Queues

BEGIN dbms_aqadm.start_queue(queue_name =>'SYS.AQ_SRVNTFN_TABLE_Q_1',ENQUEUE =>TRUE, DEQUEUE =>TRUE); END;

ERROR at line 1:
ORA-24010: QUEUE SYS.AQ_SRVNTFN_TABLE_Q_1 does not exist
ORA-06512: at "SYS.DBMS_AQADM", line 424
ORA-06512: at line 1

1. Proceed with overall steps in
Export/Import EBS release 12.0 or 12.1 with RDBMS 12c (<Document:1585256.1>)
 Section 1: Prepare the source system
 Section 2: Prepare a target Release 12 database instance
 Section 3: Export the source Release 12 database instance
 Section 4: Import the Release 12 database instance

2. Run auque2.sql on the target database server node like below.



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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.