1 Reply Latest reply on Aug 1, 2019 12:38 PM by ORASCN

    MSSQL replication using OGG

    Robeen

      Oracle Database 12.1.0.2

      MSSQL server 2016

       

      Hello Team,

       

      I am getting error below whenever I am doing the initial load

       

      2019-08-01T11:58:24.548+0400  INFO    OGG-00995  Oracle GoldenGate Delivery for SQL Server, RINIBI.prm:  REPLICAT RINIBI starting.

      2019-08-01T11:58:24.642+0400  INFO    OGG-03059  Oracle GoldenGate Delivery for SQL Server, RINIBI.prm:  Operating system character set identified as windows-1252.

      2019-08-01T11:58:24.642+0400  INFO    OGG-02695  Oracle GoldenGate Delivery for SQL Server, RINIBI.prm:  ANSI SQL parameter syntax is used for parameter parsing.

      2019-08-01T11:58:24.892+0400  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-08-01T11:58:26.064+0400  INFO    OGG-01552  Oracle GoldenGate Delivery for SQL Server, RINIBI.prm:  Connection String: provider=SQLOLEDB.1;initial catalog=BIREPORT;data source=RHIS-BI-SQL01\BIMSSQL;persist security info=false;integrated security=sspi.

      2019-08-01T11:58:26.126+0400  INFO    OGG-03036  Oracle GoldenGate Delivery for SQL Server, RINIBI.prm:  Database character set identified as windows-1252. Locale: en_US.

      2019-08-01T11:58:26.126+0400  INFO    OGG-03037  Oracle GoldenGate Delivery for SQL Server, RINIBI.prm:  Session character set identified as windows-1252.

      2019-08-01T11:58:26.142+0400  INFO    OGG-01815  Oracle GoldenGate Delivery for SQL Server, RINIBI.prm:  Virtual Memory Facilities for: COM

                                        anon alloc: MapViewOfFile  anon free: UnmapViewOfFile

                                        file alloc: MapViewOfFile  file free: UnmapViewOfFile

                                        target directories:

                                        C:\Users\roshanbi\migration\GG\dirtmp.

      2019-08-01T11:58:26.408+0400  WARNING OGG-05673  Oracle GoldenGate Delivery for SQL Server, RINIBI.prm:  CSN-based duplicate suppression is disabled because there is no checkpoint table for this Replicat.

      2019-08-01T11:58:26.533+0400  ERROR   OGG-02161  Oracle GoldenGate Delivery for SQL Server, RINIBI.prm:  Failed to retrieve the trail file begin checkpoint position.

      2019-08-01T11:58:26.548+0400  ERROR   OGG-01668  Oracle GoldenGate Delivery for SQL Server, RINIBI.prm:  PROCESS ABENDING.

       

      on source:

      EXTRACT EBISQL01

      --- User login

      USERIDALIAS oraggs

      DISCARDFILE ./dirrpt/eapps.dsc, APPEND

      DISCARDROLLOVER AT 01:00 ON SUNDAY

      EXTTRAIL /data1/gg/dirdat/ms

      STATOPTIONS REPORTFETCH

      REPORTCOUNT every 10 minutes, RATE

      LOGALLSUPCOLS

      REPORTROLLOVER AT 01:00 ON SUNDAY

      --- DDL Parameters

      UPDATERECORDFORMAT COMPACT

      TRANLOGOPTIONS INCLUDEREGIONID

      DDL INCLUDE MAPPED

      DDLOPTIONS REPORT

      TABLE BIREPORT.testBIMSSQL;

      TABLE  BIREPORT.INSBILL_GROUPMTH ;

       

      EXTRACT PMPBISQL

      USERIDALIAS oraggs

      RMTHOST 10.124.0.90, MGRPORT 7809

      --TRANLOGOPTIONS INTEGRATEDPARAMS(_CKPT_RETENTION_CHECK_FREQ 300)

      RMTTRAIL C:\Users\roshanbi\migration\GG\dirdat\ms

      TABLE BIREPORT.testBIMSSQL;

      TABLE BIREPORT.INSBILL_GROUPMTH;

       

      on target:

      PARAMETER FILE FOR INCREMENTAL LOAD

      REPLICAT RBIMS

      TARGETDB BIMSQL, USERID BIREPORT, PASSWORD BIREPORT

      DDL INCLUDE ALL

      --HANDLECOLLISIONS

      --SOURCEDEFS C:\Users\roshanbi\migration\GG\dirdef\source.def

      DISCARDFILE C:\Users\roshanbi\migration\GG\dirrpt\RBIMSet.DSC, PURGE

      MAP BIREPORT.testBIMSSQL, TARGET BIREPORT.testBIMSSQL;

      MAP BIREPORT.INSBILL_GROUPMTH, TARGET BIREPORT.INSBILL_GROUPMTH;

       

      PARAMETER FILE FOR INITIAL LOAD:

      REPLICAT RINIBI

      TARGETDB BIMSQL, USERID BIREPORT, PASSWORD BIREPORT

      SOURCEDEFS ./dirdef/source.def

      DISCARDFILE ./dirrpt/RINIBI.txt, PURGE

      --MAP BIREPORT.testBIMSSQL, TARGET BIREPORT.testBIMSSQL;

      MAP BIREPORT.INSBILL_GROUPMTH, TARGET BIREPORT.INSBILL_GROUPMTH;

       

      Kindy advise why error occurs whenever I start RINIBI

       

      Thanks,

       

      Joe

        • 1. Re: MSSQL replication using OGG
          ORASCN

          Hi Joe,

           

          How did you create the replicat process? Did you add the replicat?

           

          The below 2 parameters should be used in the Initial Load replicat process.

           

          SPECIALRUN

          END RUNTIME

           

          Also, Please check the below Note ID which is for Oracle, but the similar to one which you are facing.

           

          Initial Load Abended With Error Replicat OGG-02161 Failed To Retrieve The Trail File Begin Checkpoint Position (Doc ID 2340877.1)

           

          Regards,

          Veera