GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

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

edited Feb 17, 2015 10:02AM in GoldenGate, Streams and Distributed Database (MOSC) 2 commentsAnswered

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center