Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

goldengate postgres to AWS

cptkirkshJun 21 2021

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.\*;

Comments

Post Details

Added on Jun 21 2021
0 comments
290 views