Forum Stats

  • 3,769,805 Users
  • 2,253,023 Discussions
  • 7,875,211 Comments

Discussions

goldengate postgres to AWS

cptkirksh
cptkirksh Member Posts: 83 Red Ribbon

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 [email protected]) 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.*;