Oracle 10.2.0.1 --> 10.2.0.4 patchset errors on Advanced Queuing tables. Serious or not?

Posted by hurfdurf on Server Fault See other posts from Server Fault or by hurfdurf
Published on 2010-04-08T19:24:36Z Indexed on 2010/04/08 19:33 UTC
Read the original article Hit count: 364

Filed under:
|
|
|
|

We're running Oracle on RHEL 5.4 64-bit. We recently did an upgrade from 10.2.0.1 to 10.2.0.4. Many errors were generated during the upgrade (sample listed below from trace.log) but during application testing afterward everything seemed fine (clean EXP, inserts, updates, deletes, etc.). The errors look like they are all related to Advanced Queuing tables and views. We are not using replication at all, this is a simple single instance db.

ORA-24002: QUEUE_TABLE SYS.AQ_EVENT_TABLE does not exist
ORA-24032: object AQ$_AQ_SRVNTFN_TABLE_T exists, index could not be created
ORA-24032: object AQ$_ALERT_QT_S exists, index could not be created for queue
ORA-06512: at "SYS.DBMS_AQADM_SYSCALLS", line 117
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 5116

Is this worth worrying about, and if so, how do I go about cleaning up/recreating the corrupted and/or missing objects?

© Server Fault or respective owner

Related posts about Oracle

Related posts about upgrade