Oracle streams propagation issue ORA-22636

Issue

SQL> SELECT DESTINATION_DBLINK,

  2         STATUS,

  3         ERROR_DATE,

  4         ERROR_MESSAGE

  5    FROM DBA_PROPAGATION;

DESTINATION_DBLINK

----------------------------------------------------------------

ERROR_MESSAGE

----------------------------------------------------------------

TO_FORCL.COM

ORA-22636: Message 22636 not found;  product=RDBMS; facility=ORA

Diagnostic

Run on both sites

SQL> select * from v$timezone_file;

FILENAME                VERSION

-------------------- ----------

timezlrg_14.dat              14

--

SQL> select * from v$timezone_file;

FILENAME                VERSION

-------------------- ----------

timezlrg_11.dat              11

the versions must be the same

Workaround

Update DST file. Follow the document:

Updating the RDBMS DST version in 11g Release 2 (11.2.0.1 and up) using DBMS_DST (Doc ID 977512.1)