Run script auque2.sql after DB import got ORA-24010: QUEUE SYS.AQ_SRVNTFN_TABLE_Q_1 does not exists

Dear all,

We are doing platform migration for EBS 12.1.3 on AIX Power 7.1 and DB 12.1.0.2 to Oracle Linux 7.6 follow note 1377213.1.

We used import/export (datapump) as adviced in the above note, and followed guide in the note "Export/Import Process for Oracle E-Business Suite Release 12.0 or 12.1 Database Instances Using Oracle Database 12c Release 1 Doc ID 1585256.1 ".

We checked all OS, DB prerequisites and all meet. All steps done without error.

When it came to step 1 "Reset Advanced Queues" of Section 5 "Update the imported Release 12 database instance" of 1585256.1 we encounted the error:

SQL> @auque2.sql

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