streams propagation error: ORA-22636: Message 22636 not found; product=RDBMS; facility=ORA
I have an 11.2.0.3 database on linux x86-64 that is a streams source database. We set up table level replication to a new 12.1.0.2 database and it worked. We set up schema level replication to a 12.1.0.2 database and received a propagation error:
PRPGT_TO_RPTD02_DEV ENABLED ORA-22636: Message 22636 not found; product=RDBMS; facility=ORA 09-FEB-15:15:23:46
There is nothing in MOS about this error. I found a blog that states that the timezone versions in the two databases need to be the same.
11.2.0.3 source: select * from v$timezone_file;
FILENAME VERSION
-------------------- ----------
timezlrg_4.dat 4
12.1.0.2 target: select * from v$timezone_file;