AQ Propagation Failing With ORA-25329 After Upgraded From 8i or 9i to 10g or 11g. (Doc ID 1204080.1)

Last updated on OCTOBER 28, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.2.0.2 [Release 10.2 to 11.2]
Information in this document applies to any platform.

Symptoms

Streams Advanced Queue propagation does not work anymore after upgraded database and you see following error on alert log from the database where propagation is running:

[excerpted from alert log file]
Tue Aug 10 20:04:16 EDT 2010
Propagation Schedule for (SCOTT.TEST_QT, TEST.US.ORACLE.COM) encountered following error:
ORA-25329: AQ array operations not allowed on 8.0 queues
ORA-02063: preceding line from
TEST.US.ORACLE.COM

Changes

Upgraded database where propagation is running from 8i/9i versions to 10g or 11g.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms