8 Replies Latest reply: Jan 23, 2013 3:54 PM by stevencallan RSS

    Cannot start EXTRACT - OGG-01742 is reported

    vsvs
      Hi,
      I've configured, added and registered EXTRACT process, but when I try to start it i receive an error:

      GGSCI (TEST-SRV1) 6> START EXTRACT extr

      Sending START request to MANAGER ('GGSMGR') ...

      ERROR: Cannot create process 'extract'. Child process is no longer alive
      .

      2013-01-22 15:56:22 WARNING OGG-01742 Command sent to MGR MGR returned with an
      ERROR response.

      When i try

      GGSCI (TEST-SRV1) 8> view report extr
      ERROR: REPORT file EXTR does not exist.


      GGSCI (TEST-SRV1) 9>

      The mgr report contains the following:

      2013-01-22 15:53:59 INFO OGG-00983 Manager started (port 7809).

      2013-01-22 15:56:17 INFO OGG-00963 Command received from GGSCI on host TEST
      -SRV1 (START EXTRACT EXTR ).

      2013-01-22 15:56:22 INFO OGG-00975 client_start_er_prog failed.

      What could be the cause of the problem? I cannot find anything relevant both at support.oracle.com and google

      The extract process was successfully added with the command

      ADD EXTRACT extr , INTEGRATED TRANLOG, BEGIN NOW

      Then it was successfully registered:

      GGSCI (TEST-SRV1) 5> REGISTER EXTRACT extr DATABASE

      2013-01-22 15:55:48 INFO OGG-02003 Extract EXTR successfully registered wit
      h database at SCN 1004025.

      The exttrail was also created successfully

      ADD EXTTRAIL C:\Goldengate\dirdat\t*, EXTRACT extr

      The parameter file for extract is:

      EXTRACT extr
      USERID GGEXTRACT,
      PASSWORD AACAAAAAAAAAAAEANJEILEYAOIUJKDTA &
      BLOWFISH, ENCRYPTKEY GGKEY
      ENCRYPTTRAIL BLOWFISH, KEYNAME GGKEY
      EXTTRAIL C:\Goldengate\dirdat\t*
      DDL INCLUDE ALL
      TABLE DEPO.*;
      TABLE DEPO_ARCH.*;
      TABLE DEPO_RPT.*;
      TABLEEXCLUDE DEPO.TMP*;
      TABLEEXCLUDE DEPO.*_D;
      TABLEEXCLUDE DEPO.SQL*;
      SEQUENCE DEPO.VID;
      SEQUENCE DEPO.LOG_SEQ;
        • 1. Re: Cannot start EXTRACT - OGG-01742 is reported
          stevencallan
          1. Look at the trail naming requirements, which does not include using an asterisk.

          ADD EXTTRAIL C:\Goldengate\dirdat\t*, EXTRACT extr

          2. Look at where TABLEEXCLUDE is used - you exclude first before wildcarding.
          Use the TABLEEXCLUDE parameter with the TABLE and SEQUENCE parameters to explicitly
          exclude tables and sequences from a wildcard specification. *TABLEEXCLUDE must precede all
          TABLE and SEQUENCE statements that contain the objects that you want to exclude.*
          • 2. Re: Cannot start EXTRACT - OGG-01742 is reported
            vsvs
            Thank you for your help. I've corrected those issues

            Now the EXTRACT is added like this:

            ADD EXTRACT extr , INTEGRATED TRANLOG, BEGIN NOW
            EXTRACT added.


            GGSCI (TEST-SRV1) 23> ADD EXTTRAIL C:\Goldengate\dirdat\ts, EXTRACT extr
            EXTTRAIL added.

            GGSCI (TEST-SRV1) 29> REGISTER EXTRACT extr DATABASE

            2013-01-23 12:26:44 INFO OGG-02003 Extract EXTR successfully registered wit
            h database at SCN 1061811.

            The parameters file for extr is the following:EXTRACT extr
            USERID GGEXTRACT,
            PASSWORD AACAAAAAAAAAAAEANJEILEYAOIUJKDTA &
            BLOWFISH, ENCRYPTKEY GGKEY
            ENCRYPTTRAIL BLOWFISH, KEYNAME GGKEY
            EXTTRAIL C:\Goldengate\dirdat\ts
            DDL INCLUDE ALL
            TABLEEXCLUDE DEPO.TMP*;
            TABLEEXCLUDE DEPO.*_D;
            TABLEEXCLUDE DEPO.SQL*;
            TABLE DEPO.*;
            TABLE DEPO_ARCH.*;
            TABLE DEPO_RPT.*;
            SEQUENCE DEPO.VID;
            SEQUENCE DEPO.LOG_SEQ;

            The result is however the same:

            GGSCI (TEST-SRV1) 36> start extract extr

            Sending START request to MANAGER ('GGSMGR') ...

            ERROR: Cannot create process 'extract'. Child process is no longer alive
            .

            2013-01-23 12:32:23 WARNING OGG-01742 Command sent to MGR MGR returned with an
            ERROR response.

            and in the mgr report:

            2013-01-23 12:34:34 INFO OGG-00983 Manager started (port 7809).

            2013-01-23 12:35:00 INFO OGG-00963 Command received from GGSCI on host TEST
            -SRV1 (START EXTRACT EXTR ).

            2013-01-23 12:35:05 INFO OGG-00975 client_start_er_prog failed.

            And still no report for extr as if it even didn't try to start

            Any ideas?
            • 3. Re: Cannot start EXTRACT - OGG-01742 is reported
              vsvs
              The problem seems to be with the Golden Gate software which i downloaded from oracle.com. I've re-installed and re-configured the Golden Gate 11.2.0.3 version from edelivery - it seems to work. It means there is a buggy version at the Oracle official site!
              • 4. Re: Cannot start EXTRACT - OGG-01742 is reported
                982808
                It is always best to download software from MOS (myoraclesupport) and get the latest patches vs getting the builds from edelivery.
                • 5. Re: Cannot start EXTRACT - OGG-01742 is reported
                  stevencallan
                  Don't you mean download the latest builds from eDelivery and get patches from MOS?

                  "Welcome to the Oracle Software Delivery Cloud. Here you can find downloads for all licensable Oracle products."
                  • 6. Re: Cannot start EXTRACT - OGG-01742 is reported
                    982808
                    Steve,

                    I wish I meant that.

                    A patch in GoldenGate is a full build... And because patches don't go on edelivery they are often outdated.

                    For example the latest builds of OGG are:
                    v11.2.1.0.4 That is only on MOS NOT on edelivery.

                    Always best to go just to MOS for Oracle GoldenGate.
                    • 7. Re: Cannot start EXTRACT - OGG-01742 is reported
                      stevencallan
                      True - at least with the RDBMS software, starting in 11gR2, patches will be the complete software.
                      • 8. Re: Cannot start EXTRACT - OGG-01742 is reported
                        982808
                        Oracle GoldenGate builds have ALWAYS been full builds even before acquistion.