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:
Oracle Database - Enterprise Edition - Version 11.2.0.4 and laterInformation 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 |