We are trying to replicate data from Amazon RDS for Oracle (source) to Oracle (target). As this Amazon RDS for oracle is on a private network, we tried to establish connection through ssh tunnel.
We tried the below command: ssh -o GatewayPorts=true -N -L 15521:dev-itmp-globi-gdw-db.aztecse-agcs-dev.ec1.aws.aztec.cloud.allianz:1521 ec2-user@dev-itmp-globi-staging.aztecse-agcs-dev.ec1.aws.aztec.cloud.allianz -i .ssh/dev.pem
when this command is active, our test connection (source end-point)using AEM works. But when it is timed out as below, end-point connection fails.
Connection to dev-itmp-globi-staging.aztecse-agcs-dev.ec1.aws.aztec.cloud.allianz closed by remote host.
Also used ssh -o GatewayPorts=true -o ServerAliveInterval=60 -N -L 15521:dev-itmp-globi-gdw-db.aztecse-agcs-dev.ec1.aws.aztec.cloud.allianz:1521 ec2-user@dev-itmp-globi-staging.aztecse-agcs-dev.ec1.aws.aztec.cloud.allianz -i .ssh/dev.pem
How can we we configure a ssh tunnel (a permanent configuration) when we use Amazon RDS for oracle as a source end-point?
Replicate version used: 6.6.0.426
AEM version used: 6.6.0.694
Ref: Qlik support case opened: 02181133 - CONNECTING TO SOURCE END-POINT- AMAZON RDS FOR ORACLE
Thanks, Adersh