Advanced Queueing Propagation Fails when Timezone Files or Charactersets or Type Versions Are Different
Last updated on AUGUST 12, 2014
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 to 220.127.116.11 [Release 11.2 to 12.1]
Information in this document applies to any platform.
Advanced Queueing (AQ) propagation between two distributed databases fails with a variety of errors including but not limited to:
ORA-30757 when propagating a message between two databases when the databases involved have different timezone files as per <Bug 18047953>.
ORA-22337 when propagating messages between two database which have the same types but different type versions as per <Bug 17848897>.
ORA-30757 and ORA-21522 reported when the source and destination databases have different charactersets as per <Bug 14065876>.
ORA-00600 [kwqpfgttoid:node] as per <Bug 17870305> and <Note 1610059.1>.
ORA-00600 [kope2upic2954] on propagation of a transformed message as per <Bug 13830665>.
Issue may be observed after upgrade.
Also observed after updating the timezone files on one database in an AQ setup
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms