I am currently researching the feasibility of getting Asynchronous Distributed HotLog CDC working for a Proof of Concept in our organization. The source database is a 9.2.0.7 on Sun Solaris and our target database is a 10gR2 on the same OS.
I have been trying, since I arrived, to get them to use more features provided by Oracle. From what I have found so far, all of our Oracle databases are severely under utilized.
I will post my findings here along with a full How To when I have completed it and hopefully the results of whether it was implemented or not.
I did want to post some of the sources I have used so far though:
Oracle Documentation - This is where I started. Most of the other links reference the docs.
Mark Rittman - 10g to 10g. Great example but from what I can tell so far, it's almost identical to the documentation.
Oracle How To - I just found this one and am very interested in reading through it.
If you have any examples, feel free to post the link.
Hello,
ReplyDeleteDid you complete your setup?
I setup CDC Asynchronous Hotlog mode up on...
10gR2/HPUNIX - Source
10gR2/Windows- Target
My updates are not making it over to the tagret DB.
Any clues?
Thanks,
Chris
@clhoste
ReplyDeleteI never did get it up and running.
I wish I could help, but I cannot.
HI, I have exact same problem and have found no solution...
ReplyDeleteexecuting DBMS_CDC_PUBLISH.CREATE_HOTLOG_CHANGE_SOURCE errors with ...
ERROR at line 1:
ORA-01426: numeric overflow
ORA-06512: at "SYS.DBMS_CDC_IPUBLISH", line 133
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_CDC_PUBLISH", line 226ORA-06512: at line 2
Source DB is 9.2.0.8, Stage is 10.2.0.1 , both Solaris/SPARC.
Just FYI
Rgds,
david.gosbee@clarity.com