My Oracle Support Banner

Oracle OAQ Propagation With Payload AQ$_JMS_BYTES_MESSAGE Not Working Between 11g / 12c and 18c (Doc ID 2496234.1)

Last updated on AUGUST 15, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

Oracle Advanced Queueing queue to queue propagation with payload SYS.AQ$_JMS_BYTES_MESSAGE not working from db version 11.2.0.4 to db version 12.2.0.1 (and from 12.2.0.1 to 11.2.0.4).
Propagation schedule fails with error "ORA-25215: user_data type and queue type do not match"

Verifying queue types it returns that type SYS.AQ$_JMS_BYTES_MESSAGE on db 12.2.0.1 has a different version than 11.2.0.4:

--> Source QUEUE 
v_rc: 0
v_toid: 00000000000000000000000000021025 ---------> same Type OID
v_version: 1 ---------> version differs from 12.2.0.1

--> Destination QUEUE 
v_rc: 0
v_toid: 00000000000000000000000000021025 ---------> same Type OID
v_version: 2 ---------> version differs from 11.2.0.4


Same error will occur  with combination of 11.2.0.4,12.1,12.2 and 18C database versions.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.