2 Replies Latest reply: Mar 20, 2014 8:32 PM by MikeN RSS

    Oracle to Sybase, Format Release

    Munchi

      Hi,

       

      I'm trying to replicate a table from Oracle to Sybase and I'm encoutering an error.

       

      Environment:

      Oracle 11.2

      Oracle GoldenGate Command Interpreter for Oracle

      Version 11.2.1.0.7 16934304 OGGCORE_11.2.1.0.7_PLATFORMS_130709.1600.1_FBO

       

      Sybase

      Oracle GoldenGate Command Interpreter for Sybase

      Version 11.1.1.1.5_07 16480139 OGGCORE_11.1.1.1.6_PLATFORMS_130317.0600

       

      I was trying to sync my Oracle database to my Sybase database when I got the following error:

      2014-03-20 09:15:51  ERROR   OGG-01332  Oracle GoldenGate Delivery for Sybase, rinimin.prm:  File InitialLoad, with compatibility level 3, is not compatible with the current software version's compatibility level of 2. Modify the file writer's parameter file to generate the appropriate format using the FORMAT LEVEL 2 option.

       

      I did some research and concluded that I needed to include the format release parameter in my defsfile when doing the defgen in orde to be reverse compatible for the Sybase GG.

      13 Associating Replicated Data with Metadata (12c (12.1.2))

      shows that I can just append FORMAT RELEASE 11.1 to the defsfile parameter:

      DEFSFILE ./dirdef/ora_min.def PURGE FORMAT RELEASE 11.1

      userid xxxx@xxxxxx, password xxxxxx

      table xxxxx.xxxx;

       

      But I get the following output when I do the defgen:

      [oracle@srv-oda-p-1 ggate]$ defgen paramfile dirprm/ora_min.prm

       

       

      ***********************************************************************

              Oracle GoldenGate Table Definition Generator for Oracle

      Version 11.2.1.0.7 16934304 OGGCORE_11.2.1.0.7_PLATFORMS_130709.1600.1

         Linux, x64, 64bit (optimized), Oracle 11g on Jul 18 2013 04:10:02

       

       

      Copyright (C) 1995, 2013, Oracle and/or its affiliates. All rights reserved.

       

       

       

       

                          Starting at 2014-03-20 11:23:47

      ***********************************************************************

       

       

      Operating System Version:

      Linux

      Version #1 SMP Fri Jun 7 18:53:16 PDT 2013, Release 2.6.39-400.111.1.el5uek

      Node: srv-oda-p-1

      Machine: x86_64

                               soft limit   hard limit

      Address Space Size   :    unlimited    unlimited

      Heap Size            :    unlimited    unlimited

      File Size            :    unlimited    unlimited

      CPU Time             :    unlimited    unlimited

       

       

      Process id: 17364

       

       

      ***********************************************************************

      **            Running with the following parameters                  **

      ***********************************************************************

      DEFSFILE ./dirdef/ora_min.def PURGE FORMAT RELEASE 11.1

       

       

      Source Context :

        SourceModule            : [defgen.main]

        SourceID                : [/scratch/aime1/adestore/views/aime1_adc4150267/oggcore/OpenSys/src/app/defgen/defgen.c]

        SourceFunction          : [create_defgen_file]

        SourceLine              : [820]

        ThreadBacktrace         : [8] elements

                                : [/dbfs/ggate/libgglog.so(CMessageContext::AddThreadContext()+0x1e) [0x7f0d55a9ac3e]]

                                : [/dbfs/ggate/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x2cc) [0x7f0d55a9398c]]

                                : [/dbfs/ggate/libgglog.so(_MSG_ERR_STARTUP_BADARG_FILENAME_INVALID_OPENMODE(CSourceContext*, CMessageFactory::MessageDisposition)+0x2c) [0x7f0d55a854e2]]

                                : [defgen(create_defgen_file(ggs::gglib::ggunicode::UString const&, ULibCharSet&, bool&)+0x2ee) [0x43001e]]

                                : [defgen(get_infile_params()+0x19c) [0x4321ac]]

                                : [defgen(main+0xd9) [0x4324b9]]

                                : [/lib64/libc.so.6(__libc_start_main+0xf4) [0x3837e1d9c4]]

                                : [defgen(__gxx_personality_v0+0x102) [0x42f6ea]]

       

       

      2014-03-20 11:23:47  ERROR   OGG-00411  Must be PURGE or APPEND.

       

       

      2014-03-20 11:23:47  ERROR   OGG-01668  PROCESS ABENDING.

       

       

      What am I missing here?

        • 1. Re: Oracle to Sybase, Format Release
          Munchi

          Apparently release format does not yet exist in 11.2

          http://docs.oracle.com/cd/E28323_01/doc.1121/e27274.pdf

          Only for the remote trail

           

          How can we setup initial load via GG then?

          • 2. Re: Oracle to Sybase, Format Release
            MikeN

            Munchi wrote:

             

            Apparently release format does not yet exist in 11.2

            http://docs.oracle.com/cd/E28323_01/>doc.1121/e27274.pdf

            Only for the remote trail

             

            How can we setup initial load via GG then?

             

            So, just to restate the original problem: when sending from 11.2 to 11.1, then (1) create trails using "format release 11.1" (or equivalent; e.g., "format level 2"), and (2) generate 11.1-compatible source-definitions.

             

            The first  issue is doing direct load (no trails), and the second is that in 12.1 the syntax for generating older source-def's was different.

             

            The parameters on the source extract to write out remote "trails" (maxfiles forces rmtFile to rollover like rmtTrail) would be like:

             

              extract foo
              ...etc...
              -- remote vs. local: ExtFile dirdat/xy  MaxFiles 9999  [size...]
              RmtFile dirdat/aa  MaxFiles 9999  MegaBytes 2048
              table schema.table100...;
              table ...
              RmtFile dirdat/bb  MaxFiles 9999  MegaBytes 2048
              table schema.table200 ...;
              ...
            

             

            And the gendef command (note this is the command line, not a parameter):

               $ defgen paramfile dirprm/my-defgen.prm [reportfile dirrpt/my-defgen.rpt]  noExtAttr
            

            As of v12.1, you can set the defgen "format" just like trails.  In v11.2, this "no extra attributes" just removes charset/encoding info from the def's file, which only works in v11.2+.