One extract pump to multi target wih encrypt

Jun 10, 2021 1:16PM

Dear Community,

I have one primary extract change capture and one secondary extract pump as below :

EXTRACT EXTFINA2

-- primary extract

SOURCEDB mydb UserIDAlias gguser

ENCRYPTTRAIL AES256

EXTTRAIL ./dirdat/extfina2/f2

TABLE source_user.t1;

EXTRACT PUMFINA2

--secondary extract

SOURCEDB mydb UserIDAlias gguser

RMTHOST 192.168.1.10, MGRPORT 7600, ENCRYPT AES256, TCPBUFSIZE 100000, TCPFLUSHBYTES 300000, NOSTREAMING

RMTTRAIL ./dirdat/repfina2/f2

TABLE source_user.t1;

RMTHOST 192.168.1.20, MGRPORT 7600, ENCRYPT AES256, TCPBUFSIZE 100000, TCPFLUSHBYTES 300000, NOSTREAMING

RMTTRAIL ./dirdat/repfina2/f2

TABLE source_user.t1;

but I always get error ERROR OGG-01232 Receive TCP params error: TCP/IP error 104 (Connection reset by peer), endpoint: 192.168.1.10:7611

When I remove ENCRYPT in RMTHOST 192.168.1.20 as below, It is working fine.

GoldenGate, Streams and Distributed Database (MOSC)