Oracle-L: Migrating Advanced Queue from 8i (8.1.6.3.0) to 9i (9.0.1.3.0)

From: Orlando Martins <orlando.martins_at_sky.tv.br>
Date: Sat, 03 Aug 2002 07:38:18 -0800
Message-ID: <F001.004AABE0.20020803073818@fatcity.com>

Hello all,
We have here some advanced queues running under Oracle 8.1.6.3.0. There is no problem with production.

Now, we're trying Oracle9i (9.0.1.3.0), so we'd installed the Oracle software and we'd migrated this instance to new version. Then, this problem arise, because we could not start/stop the queues, all the commands give the same error below:

The error occur in SQL*Plus (version 8.1.7.0.0) and Oracle manual tell me to DROP / RECREATE the queue, something impossible in production enviroment.

SQL> EXECUTE DBMS_AQADM.STOP_QUEUE('JSIC.ERROR'); BEGIN DBMS_AQADM.STOP_QUEUE('JSIC.ERROR'); END; *
ERROR at line 1:

ORA-24026: operation failed, queue JSIC.ERROR has errors 
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 3121 
ORA-06512: at "SYS.DBMS_AQADM", line 237 
ORA-06512: at line 1

If you'd already experienced this problem please let me know. You can mail me at olmartins_at_terra.com.br <mailto:olmartins_at_terra.com.br> as well.

Thank you.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Orlando Martins
INET: orlando.martins_at_sky.tv.br

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Sat Aug 03 2002 - 10:38:18 CDT