Windows SQL server 2017 (target)
OS: Windows Server 2019
OGG 12.2.0.2.2
Oracle Database 12.1.0.2 (source)
RHEL 7.4
Hello Team,
I am doing a table replication from the source to a target SQL server.
TARGET MGR
PORT 7809
ACCESSRULE, PROG REPLICAT, IPADDR *, ALLOW
REPLICATION PARAMETER FILE
REPLICAT RINIBI
TARGETDB BIREPORT, USERID BIREPORT, PASSWORD BIREPORT
SOURCEDEFS ./dirdef/source_defs.def
DISCARDFILE ./dirrpt/RINIBI.dsc, PURGE
MAP BIREPORT.INSBILL_GROUPMTH, TARGET BIREPORT.INSBILL_GROUPMTH;
Source parameter file(extract)
EXTRACT EXBIMS
--- User login
USERIDALIAS oraggs
RMTHOST <sql SERVER IP>, MGRPORT 7809
RMTTASK REPLICAT, GROUP RINIBI
TABLE BIREPORT.INSBILL_GROUPMTH;
Please find error from ggserr.log
2019-04-11 21:23:31 INFO OGG-03059 Oracle GoldenGate Delivery for SQL Server, RINIBI.prm: Operating system character set identified as windows-1252.
2019-04-11 21:23:31 INFO OGG-02695 Oracle GoldenGate Delivery for SQL Server, RINIBI.prm: ANSI SQL parameter syntax is used for parameter parsing.
2019-04-11 21:23:31 INFO OGG-03528 Oracle GoldenGate Delivery for SQL Server, RINIBI.prm: The source database character set, as determined from the table definition file, is we8iso8859p15.
2019-04-12 11:48:57 ERROR OGG-00551 Oracle GoldenGate Delivery for SQL Server, RINIBI.prm: Database operation failed: Couldn't connect to BIREPORT. ODBC error: SQLSTATE IM003 native database error 160. Specified driver could not be loaded due to system error 1114: A dynamic link library (DLL) initialization routine failed. (Oracle in OraClient12Home1, C:\app\roshanbi\product\12.1.0\client_1\SQORA32.DLL).
2019-04-12 11:49:02 ERROR OGG-01668 Oracle GoldenGate Delivery for SQL Server, RINIBI.prm: PROCESS ABENDING.
I tested ODBC connection, it is successful
ORACLE_HOME: C:\app\roshanbi\product\12.1.0\client_1
PATH: C:\app\roshanbi\product\12.1.0\client_1\bin
In fact i installed ODAC 12.1.0 64-bit on the server.
I see the SQORA32 is missing in the path.
Please advise why initial replication is not working
Thanks!
Joe