cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle 12c (with LogMiner) replication to ASE 15.7 setup

tloustv
Discoverer
0 Kudos

I think I am missing something really stupid within the configuration of RAO.

Oracle 12c Enteprise Edition 12.1.0.2.0 installed with LogMiner (checking existence of user transactions in V$LOGMNR_CONTENTS),

RAO 15.7.1 SP211 setup (test_connection = succeeded for both PDS and RS).

RS 15.7.1 SP306 with connection (REP AGENT=Awaiting Command) + replication definition + subscription, but when I use "syadmin dump_queue", I see only the same "activate subscription" operation in both inbound queue of RAO and outbound queue of ASE.

I think either RAO does not read the Oracle Log, or it does not pass transactions to SRS. Is there any way to check these two steps (to see that RAO knows about transactions from Oracle)? Something like "dump queue" in SRS?

Best regards,

Vojtech

tloustv
Discoverer
0 Kudos

Solved with help of Javier Martin -

the replication was prepared (checked using ra_statistics, ra_helpop), but was not send to RS (checked by admin stats, backlog and admin who, sqm and sysadmin dump_queue), but the transactions were filtered out as the transactions in Oracle were performed under maitenance user.

When corrected by ra_config filter_maint_userid, false, the replication started.

Best regards,

Vojtech

Accepted Solutions (0)

Answers (0)