Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

upgrade to 12c - problem with AQ tables

Michael_MMWDBAFeb 3 2016 — edited Feb 3 2016

Hi all,

i'm trying to upgrade a 11.2.0.3 database to 12.1.0.2 (PSU 5) on Solaris-64.

The upgrade process throws an error as following:

Oracle Server

   ORA-24005: Inappropriate utilities used to perform DDL on AQ table

   SYSTEM.DEF$_AQCALL

   ORA-06512: at line 30

   ORA-24002: QUEUE_TABLE SYSTEM.DEF$_AQCALL does not exist

   ORA-06512: at line 19

   ORA-00942: table or view does not exist

   ORA-24005: Inappropriate utilities used to perform DDL on AQ table

   SYSTEM.DEF$_AQERROR

   ORA-06512: at line 30

   ORA-24002: QUEUE_TABLE SYSTEM.DEF$_AQERROR does not exist

   ORA-06512: at line 19

I've tried to run the statements manually in the database with the same result.

Any helpful ideas?

Thanks

Michael
This post has been answered by Krishna-Oracle on Feb 3 2016
Jump to Answer

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 2 2016
Added on Feb 3 2016
#database-upgrade
2 comments
1,667 views