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:

Symptoms

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

Error
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

Steps
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.

Cause

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