0

I have 2 Sybase DB and 1 Oracle DB, I would like to replicate one of the tables in Sybase DB X (table name: customer_order) into my Sybase DB Y (table name: customer_order), and from the Sybase DB Y replicate into Oracle. The replication linking is like this:-

Sybase DB X --> Sybase DB Y --> Oracle

The replication from Sybase DB X to Sybase DB Y is working fine, but replication failed from Sybase DB Y to Oracle. When I tried to insert/delete/update some records on Sybase DB Y, it has been replicated to Oracle, but...when I tried to insert/delete/update some records on Sybase DB X, these transactions are able to replicate to Sybase DB Y, but it couldn't replicate into Oracle. WHY??

Appreciate if anyone could solve my doubts. Thanks a lot.

FYI:-

  • Replication Server version 15.7.1

  • Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

  • Adaptive Server Enterprise/15.5/EBF 19395 SMP ESD#5/P/Sun_svr4/OS 5.8/asear155/2568/64-bit/FBO/Fri Dec 9 09:16:52 2011

Improve this question
8
  • How are you doing this replication (from Y (Sybase) -> Oracle)?
    – Vérace
    Sep 21, 2017 at 8:21
  • create replication definition repdef_ABC with primary at testing.customers with primary table named dbo.customer_order with replicate table named PBO.'CUSTOMER_ORDER' ( customer_id bigint, customer_name varchar(500) ) PRIMARY KEY ( customer_id ) go create subscription sub_ABC for repdef_ABC with replicate at <oracle connection in repserver> without materialization subscribe to truncate table go
    – Tittus
    Sep 21, 2017 at 8:32
  • I'm doing the same thing like how I usually did the replication from Sybase ASE to Oracle, but it seems not working. I'm wondering whether it is because Replication Server does not support the linking? (Sybase DB X --> Sybase DB Y --> Oracle)
    – Tittus
    Sep 21, 2017 at 8:38
  • OK - two things: 1) put extra technical data in your question with a pointer back to it in comments (use @Vérace to let me know - i.e. @<+handle> in the comment) - that way, any new reader can see all of the relevant information without having to read through the comments and the person who asked for extra info knows you've put it in!
    – Vérace
    Sep 21, 2017 at 9:29
  • 2.) Are you using this product? It always helps (greatly) to include the name and version number of all products you are asking about. Take the site tour, read the help - also check this out! p.s. welcome to the forum!
    – Vérace
    Sep 21, 2017 at 9:29

1 Answer 1

Reset to default
1

By default the repagent (in Sybase DB Y) will not replicate maintenance user transactions (ie, transactions replicated from Sybase DB X to Sybase DB Y).

To get the repagent (Sybase DB Y) to also replicate maintenance transactions (ie, transactions from Sybase DB X, once applied in Sybase DB Y, are then re-replicated to Oracle), you'll need to configure the Sybase DB Y repagent:

use <Sybase_DB_Y>
go
sp_config_rep_agent <Sybase_DB_Y>,'send maint xacts to replicate',true
go
sp_stop_rep_agent <Sybase_DB_Y>
go
-- wait for repagent to go down and then ...
sp_start_rep_agent <Sybase_DB_Y>
go
Improve this answer
0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.