4 Replies Latest reply: Jan 25, 2013 2:24 AM by AMSI RSS

    Unable to Start Extract Process

    AMSI
      hi,

      I am just start the extract process command & then i see the status. then the process is in STOP mode. i can't understand that why.
      I have also check the ggerror file. in which i can the extract process is runnig.
      but whn i run the command

      1.START EXTRACT EOLTP1
      starting...
      stats EOLTP01
      ERROR: EXTRACT EOLTP1 not currently running.


      2. GGSCI (s34klj69) 22> info extract EOLTP1

      EXTRACT EOLTP1 Initialized 2013-01-23 11:29 Status STOPPED
      Checkpoint Lag 00:00:00 (updated 52:16:51 ago)
      Log Read Checkpoint Oracle Redo Logs
      2013-01-23 11:29:21 Thread 1, Seqno 0, RBA 0

      waiting...thanks,AMSII

      Edited by: AMSI on Jan 24, 2013 11:48 PM
        • 1. Re: Unable to Start Extract Process
          Kamal_Sharma
          Please check the report file available in dirrpt folder or through view report <extract-name> on OGG prompt to see the cause of the issue.


          Thanks,
          Kamal.
          • 2. Re: Unable to Start Extract Process
            AMSI
            thanks Kamal. According to you i have just run the report.Kindly see the attached output report of extract process
            GGSCI (serv1) 26> view report EOLTP1
            ***********************************************************************
            Oracle GoldenGate Capture for Oracle
            Version 10.4.0.19 Build 002
            HP/UX, pa-risc, 64bit (optimized), Oracle 9 on Sep 20 2009 11:21:53
            Copyright (C) 1995, 2009, Oracle and/or its affiliates. All rights reserved.
            Starting at 2013-01-25 15:45:56
            ***********************************************************************
            Operating System Version:
            HP-UX
            Version U, Release B.11.00
            Node: serv1
            Machine: 9000/800
            soft limit hard limit
            Address Space Size : unlimited unlimited
            Heap Size : 17179869184 17179869184
            File Size : unlimited unlimited
            CPU Time : unlimited unlimited

            Process id: 21173
            Kindly need of your assistance. realy :)

            Thanks
            • 3. Re: Unable to Start Extract Process
              Kamal_Sharma
              Please post the error information that you see when you do view report EOLTP1. I believe you just pasted only part of the report file. You can also see the error information by opening the EOLTP1.rpt in the dirrpt folder.

              Thanks,
              Kamal.
              • 4. Re: Unable to Start Extract Process
                AMSI
                Thanks Kamal,
                I have followed your instruction & just get the logs. Kindly will you like to tell me where is problem. because there is only one warning??? wht you suggest??

                Machine: 9000/800
                soft limit hard limit
                Address Space Size : unlimited unlimited
                Heap Size : 17179869184 17179869184
                File Size : unlimited unlimited
                CPU Time : unlimited unlimited

                Process id: 4400

                Description:

                ***********************************************************************
                ** Running with the following parameters **
                ***********************************************************************
                EXTRACT EOLTP1
                EXTTRAIL ./dirdat/sa
                ---SETENV (ORACLE_SID=SID_T)
                USERID OGG, PASSWORD *******
                DBOPTIONS ALLOWUNUSEDCOLUMN
                TABLE crispadm.TEST_OGG;
                CACHEMGR virtual memory values (may have been adjusted)
                CACHEBUFFERSIZE: 64K
                CACHESIZE: 8G
                CACHEBUFFERSIZE (soft max): 4M
                CACHEPAGEOUTSIZE (normal): 4M
                PROCESS VM AVAIL FROM OS (min): 15.74G
                CACHESIZEMAX (strict force to disk): 13.79G

                Database Version:
                Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production
                PL/SQL Release 9.2.0.7.0 - Production
                CORE     9.2.0.7.0     Production
                TNS for HPUX: Version 9.2.0.7.0 - Production
                NLSRTL Version 9.2.0.7.0 - Production

                Database Language and Character Set:
                NLS_LANG environment variable not set, using default value AMERICAN_AMERICA.US7ASCII.
                NLS_LANGUAGE = "AMERICAN"
                NLS_TERRITORY = "AMERICA"
                NLS_CHARACTERSET = "WE8ISO8859P1"

                Warning: NLS_LANG is not set. Please refer to user manual for more information.


                Regards,
                AMSII