Database Software

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!

Component 'AQ$_QUEUES' must be declared

497395Nov 6 2006 — edited Nov 8 2006

Hi,
I am facing some issues during my upgrade from Oralce 9.2.0.7.0 to Oracle 10.2.
During this process I am getting lot errors in the SYS user packages like DBMS_AQADM_SYS and lot other. I did intial investigation and found the errors are due to the reason the Table AQ$_QUEUES. When i recompiled the DBMS_AQADM_SYS Package body it has thrown the error

PLS-00302: component 'AQ$_QUEUES' must be declared

But the particular table is existed in the SYSTEM tablespace. And also i rerun the script "catqueue.sql" manually. Still the problem exists. Becuase of this object lot of SYS packages are in the Invalid state.

I have seen the similar issue when i have upgraded my database from 9.2.0.1.0 to 9.2.0.7.0 eventhough i ran the CATPATCH.SQL after completion of the upgrade and after following the steps listed in the upgrade document.

What could be the reason for this. I have searched lot of sites but no clue. Please suggest me what to do. Because of this I am not able to upgrade my Oracle 9i database to Oracle 10g database.

Thanks
Rao

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 6 2006

Added on Nov 6 2006

#performance-availability, #xml-db

2 comments

827 views