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
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 [EMAIL PROTECTED] as
well.
Thank
you.
