ORACLENERD twitter/oraclenerd view chet justice's profile on LinkedIn feed oraclenerd t-shirts

  Asynchronous Distributed HotLog - Change Data Capture
Thursday, December 27, 2007
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.

Labels: , , , ,

 
Comments:
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
 
@clhoste

I 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...

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
 
Post a Comment

Subscribe to Post Comments [Atom]



Links to this post:

Create a Link



<<Home

Register for Kscope 13!

The Sherpa



Guest Authors

How To

Previous Posts

Archives



Aggregated by OraNA OraDBPedia