Thursday, December 27, 2007

Asynchronous Distributed HotLog - Change Data Capture

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.

3 comments:

clhoste said...

Hello,

Did 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

oraclenerd said...

@clhoste

I never did get it up and running.

I wish I could help, but I cannot.

Anonymous said...

HI, I have exact same problem and have found no solution...

executing 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