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

Last updated on JANUARY 14, 2020

Applies to:

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

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