So can someone explain this to me.
I can connect via this to postgres DB on AWs.
dblogin sourcedb sbpgdb useridalias pg_postgresdb
GGSCI (db-ksh-x01.austin.utexas.edu as postgres@sbpgdb) 43> dblogin sourcedb sbpgdb useridalias pg_postgresdb
2021-06-21 15:49:16 INFO OGG-03036 Database character set identified as UTF-8. Locale: en_US.UTF-8.
2021-06-21 15:49:16 INFO OGG-03037 Session character set identified as UTF-8.
Successfully logged into database.
When I try to start my replicat to connect I get a SSL error.
2021-06-21T15:43:14.112-0500 INFO OGG-00995 Oracle GoldenGate Delivery for PostgreSQL, reporapg.prm: REPLICAT REPORAPG starting.
2021-06-21T15:43:14.112-0500 INFO OGG-03059 Oracle GoldenGate Delivery for PostgreSQL, reporapg.prm: Operating system character set identified as UTF-8.
2021-06-21T15:43:14.112-0500 INFO OGG-02695 Oracle GoldenGate Delivery for PostgreSQL, reporapg.prm: ANSI SQL parameter syntax is used for parameter parsing.
2021-06-21T15:43:14.112-0500 INFO OGG-02095 Oracle GoldenGate Delivery for PostgreSQL, reporapg.prm: Successfully set environment variable PGCLIENTENCODING=UTF8.
2021-06-21T15:43:14.112-0500 INFO OGG-02095 Oracle GoldenGate Delivery for PostgreSQL, reporapg.prm: Successfully set environment variable ODBCINI=/u01/app/oracle/product/ggpgsdb/odbc.ini.
2021-06-21T15:43:14.112-0500 INFO OGG-02095 Oracle GoldenGate Delivery for PostgreSQL, reporapg.prm: Successfully set environment variable NLS_LANG=AMERICAN_AMERICA.AL32UTF8.
2021-06-21T15:43:18.784-0500 INFO OGG-00987 Oracle GoldenGate Command Interpreter for PostgreSQL: GGSCI command (oracle): info all.
2021-06-21T15:45:16.039-0500 ERROR OGG-00551 Oracle GoldenGate Delivery for PostgreSQL, reporapg.prm: Database operation failed: Couldn't connect to sbpgdb. ODBC error: SQLSTATE 08001 native database error 7570. [Oracle][ODBC PostgreSQL Wire Protocol driver]SSL Handshake Failure reason [EOF observed which violates protocol].
2021-06-21T15:45:16.039-0500 ERROR OGG-01668 Oracle GoldenGate Delivery for PostgreSQL, reporapg.prm: PROCESS ABENDING.
2021-06-21T15:49:15.559-0500 INFO OGG-00987 Oracle GoldenGate Command Interpreter for PostgreSQL: GGSCI command (oracle): dblogin sourcedb sbpgdb useridalias pg_postgresdb.
2021-06-21T15:49:16.344-0500 INFO OGG-03036 Oracle GoldenGate Command Interpreter for PostgreSQL: Database character set identified as UTF-8. Locale: en_US.UTF-8.
2021-06-21T15:49:16.344-0500 INFO OGG-03037 Oracle GoldenGate Command Interpreter for PostgreSQL: Session character set identified as UTF-8.
Here is the contents of my $ODBCINI
[ODBC Data Sources]
sbpgdb=PostgreSQL on sbpgdb
[ODBC]
IANAAppCodePage=4
InstallDir=/u01/app/oracle/product/ggpgsdb
[sbpgdb]
Driver=/u01/app/oracle/product/ggpgsdb/lib/GGpsql25.so
Description=Postgres driver
Database=hillkir_test
HostName=mydb_on_aws.us-east-1.rds.amazonaws.com
PortNumber=5432
TransactionErrorBehavior=2
EncryptionMethod=1
ValidateServerCertificate=1
TrustStore=/home/oracle/certs/us-east-1-bundle.pem
Here are my replicat settings
replicat reporapg
SETENV ( PGCLIENTENCODING = "UTF8" )
SETENV (ODBCINI="/u01/app/oracle/product/ggpgsdb/odbc.ini" )
SETENV (NLS\_LANG="AMERICAN\_AMERICA.AL32UTF8")
targetdb sbpgdb, USERIDALIAS pg\_postgresdb
HANDLECOLLISIONS
discardfile ./dirrpt/hillkir.dsc, purge
map oaasdev.hillkir.\*, target hillkir\_test.\*;