Forum Stats

  • 3,875,213 Users
  • 2,266,888 Discussions
  • 7,912,114 Comments

Discussions

GOLDEN GATE:Extract is not running and hold with ABENDED MODE

user8900216
user8900216 Member Posts: 3
edited Mar 30, 2011 2:09PM in GoldenGate
Hi,
I am trying to simple initial load from oracle to oracle on Linux machin for 11g

the extract porcess is showing abended message when i try to start it


GGSCI (illin198) 2> info extract load1

EXTRACT LOAD1 Last Started 2011-02-22 16:45 Status ABENDED
Checkpoint Lag Not Available
Log Read Checkpoint Table SCOTT.EXTRACT_EMP
2011-02-22 16:45:02 Record 1
Task SOURCEISTABLE

my source prm is :
EXTRACT load1
USERID ggs_owner, PASSWORD ggs_owner
RMTHOST illin390, MGRPORT 7809
RMTTASK replicat, GROUP load2
TABLE scott.extract_emp;

The target prm is :

REPLICAT load2
USERID ggs_owner, PASSWORD ggs_owner
ASSUMETARGETDEFS
MAP scott.extract_emp,TARGET scott.extract_emp;



@ the target ,the replication is showing following messages.
GGSCI (illin390) 11> INFO REPLICAT load2,DETAIL

REPLICAT LOAD2 Initialized 2011-02-22 15:51 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:59:36 ago)
Log Read Checkpoint Not Available
Task SPECIALRUN

Extract Source Begin End

Not Available * Initialized * First Record


Current directory /oravl01/oracle/ggs

Report file /oravl01/oracle/ggs/dirrpt/LOAD2.rpt
Parameter file /oravl01/oracle/ggs/dirprm/load2.prm
Checkpoint file /oravl01/oracle/ggs/dirchk/LOAD2.cpr
Process file /oravl01/oracle/ggs/dirpcs/LOAD2.pcr
Stdout file /oravl01/oracle/ggs/dirout/LOAD2.out
Error log /oravl01/oracle/ggs/ggserr.log



Please let me know , when do we use sourcedb and targetdb in the parameter files of replication and extract?
And how to resolve the above extract error?

Thanks,
Surbhi

Answers

  • User152973
    User152973 Member Posts: 148
    Hi,

    Can you post the output for the following commands

    at extract
    ggsci> view report load1
    at replicat
    ggsci> view report load2

    ggsci> view ggsevt


    Sourcedb and Targetdb are used when your source and target databases are different than Oracle database.

    In your case there is no need to use as you are doing from Oracle to Oracle.
  • stevencallan
    stevencallan Member Posts: 3,459
    What you are doing is no different (other than the schema) than what is detailed in the tutorial. Follow the steps in the tutorial, make changes for your schema as necessary.

    http://www.oracle.com/technetwork/middleware/goldengate/learnmore/ogg-tutorial-ora-to-ora-10-4-177139.pdf
  • user8900216
    user8900216 Member Posts: 3
    edited Feb 22, 2011 12:45PM
    @extract

    GGSCI (illin198) 2> info extract load1

    EXTRACT LOAD1 Last Started 2011-02-22 16:45 Status ABENDED
    Checkpoint Lag Not Available
    Log Read Checkpoint Table SCOTT.EXTRACT_EMP
    2011-02-22 16:45:02 Record 1
    Task SOURCEISTABLE


    GGSCI (illin198) 3> view report load1


    2011-02-22 16:51:50 INFO OGG-01017 Wildcard resolution set to IMMEDIATE because SOURCEISTABLE is used.

    ***********************************************************************
    Oracle GoldenGate Capture for Oracle
    Version 11.1.1.0.0 Build 078
    Linux, x64, 64bit (optimized), Oracle 11 on Jul 28 2010 14:58:37

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


    Starting at 2011-02-22 16:51:50
    ***********************************************************************

    Operating System Version:
    Linux
    Version #1 SMP Wed Dec 30 18:35:28 EST 2009, Release 2.6.18-164.10.1.el5
    Node: illin198
    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: 32354

    Description:

    ***********************************************************************
    ** Running with the following parameters **
    ***********************************************************************
    EXTRACT load1
    USERID ggs_owner, PASSWORD *********
    RMTHOST illin390, MGRPORT 7809
    RMTTASK replicat, GROUP load2
    TABLE scott.extract_emp;

    2011-02-22 16:51:50 WARNING OGG-00869 No unique key is defined for table EXTRACT_EMP. All viable columns will be used to represent the key, but may not guarantee uniqueness.
    KEYCOLS may be used to define the key.

    Using the following key columns for source table SCOTT.EXTRACT_EMP: ID, NAME, ADDRESS.

    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): 16G
    CACHESIZEMAX (strict force to disk): 13.99G

    Database Version:
    Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
    PL/SQL Release 11.1.0.7.0 - Production
    CORE 11.1.0.7.0 Production
    TNS for Linux: Version 11.1.0.7.0 - Production
    NLSRTL Version 11.1.0.7.0 - Production

    Database Language and Character Set:
    NLS_LANG = "AMERICAN_AMERICA.AL32UTF8"
    NLS_LANGUAGE = "AMERICAN"
    NLS_TERRITORY = "AMERICA"
    NLS_CHARACTERSET = "AL32UTF8"

    2011-02-22 16:51:55 WARNING OGG-01194 EXTRACT task LOAD2 abended : Unrecognized parameter: TARGETDB. Parameter could be misspelled or unsupported.

    Source Context :
    SourceModule : [er.idlx]
    SourceID : [home/ecloud/workspace/Build_FBO_OpenSys_r11.1.1.0.0_078_[34086]/perforce/src/app/er/idlx.c]
    SourceFunction : [IDLX_complete_tcp_msg]
    SourceLine : [378]
    ThreadBacktrace : [8] elements
    : [oravl01/oracle/extract(CMessageContext::AddThreadContext()+0x26) [0x62ab66]]
    : [oravl01/oracle/extract(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x7b2) [0x621602]]
    : [oravl01/oracle/extract(_MSG_ERR_IDLX_EXTRACT_ABENDING(CSourceContext*, CMessageFactory::MessageDisposition)+0x87) [0x5ca457]]
    : [oravl01/oracle/extract(IDLX_complete_tcp_msg+0x305) [0x81a125]]
    : [oravl01/oracle/extract [0x8321bd]]
    : [oravl01/oracle/extract(main+0x1796) [0x519366]]
    : [lib64/libc.so.6(__libc_start_main+0xf4) [0x386961d994]]
    : [oravl01/oracle/extract(__gxx_personality_v0+0x1ea) [0x4e62aa]]

    2011-02-22 16:51:55 ERROR OGG-01203 EXTRACT abending.

    2011-02-22 16:51:55 ERROR OGG-01668 PROCESS ABENDING.


    GGSCI (illin198) 4>

    GGSCI (illin198) 4>

    GGSCI (illin198) 4>
    GGSCI (illin198) 2> info extract load1

    EXTRACT LOAD1 Last Started 2011-02-22 16:45 Status ABENDED
    Checkpoint Lag Not Available
    Log Read Checkpoint Table SCOTT.EXTRACT_EMP
    2011-02-22 16:45:02 Record 1
    Task SOURCEISTABLE


    GGSCI (illin198) 3> view report load1


    2011-02-22 16:51:50 INFO OGG-01017 Wildcard resolution set to IMMEDIATE because SOURCEISTABLE is used.

    ***********************************************************************
    Oracle GoldenGate Capture for Oracle
    Version 11.1.1.0.0 Build 078
    Linux, x64, 64bit (optimized), Oracle 11 on Jul 28 2010 14:58:37

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


    Starting at 2011-02-22 16:51:50
    ***********************************************************************

    Operating System Version:
    Linux
    Version #1 SMP Wed Dec 30 18:35:28 EST 2009, Release 2.6.18-164.10.1.el5
    Node: illin198
    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: 32354

    Description:

    ***********************************************************************
    ** Running with the following parameters **
    ***********************************************************************
    EXTRACT load1
    USERID ggs_owner, PASSWORD *********
    RMTHOST illin390, MGRPORT 7809
    RMTTASK replicat, GROUP load2
    TABLE scott.extract_emp;

    2011-02-22 16:51:50 WARNING OGG-00869 No unique key is defined for table EXTRACT_EMP. All viable columns will be used to represent the key, but may not guarantee uniqueness.
    KEYCOLS may be used to define the key.

    Using the following key columns for source table SCOTT.EXTRACT_EMP: ID, NAME, ADDRESS.

    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): 16G
    CACHESIZEMAX (strict force to disk): 13.99G

    Database Version:
    Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
    PL/SQL Release 11.1.0.7.0 - Production
    CORE 11.1.0.7.0 Production
    TNS for Linux: Version 11.1.0.7.0 - Production
    NLSRTL Version 11.1.0.7.0 - Production

    Database Language and Character Set:
    NLS_LANG = "AMERICAN_AMERICA.AL32UTF8"
    NLS_LANGUAGE = "AMERICAN"
    NLS_TERRITORY = "AMERICA"
    NLS_CHARACTERSET = "AL32UTF8"

    2011-02-22 16:51:55 WARNING OGG-01194 EXTRACT task LOAD2 abended : Unrecognized parameter: TARGETDB. Parameter could be misspelled or unsupported.

    Source Context :
    SourceModule : [er.idlx]
    SourceID : [home/ecloud/workspace/Build_FBO_OpenSys_r11.1.1.0.0_078_[34086]/perforce/src/app/er/idlx.c]
    SourceFunction : [IDLX_complete_tcp_msg]
    SourceLine : [378]
    ThreadBacktrace : [8] elements
    : [oravl01/oracle/extract(CMessageContext::AddThreadContext()+0x26) [0x62ab66]]
    : [oravl01/oracle/extract(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x7b2) [0x621602]]
    : [oravl01/oracle/extract(_MSG_ERR_IDLX_EXTRACT_ABENDING(CSourceContext*, CMessageFactory::MessageDisposition)+0x87) [0x5ca457]]
    : [oravl01/oracle/extract(IDLX_complete_tcp_msg+0x305) [0x81a125]]
    : [oravl01/oracle/extract [0x8321bd]]
    : [oravl01/oracle/extract(main+0x1796) [0x519366]]
    : [lib64/libc.so.6(__libc_start_main+0xf4) [0x386961d994]]
    : [oravl01/oracle/extract(__gxx_personality_v0+0x1ea) [0x4e62aa]]

    2011-02-22 16:51:55 ERROR OGG-01203 EXTRACT abending.

    2011-02-22 16:51:55 ERROR OGG-01668 PROCESS ABENDING.



    @replication

    GGSCI (illin390) 19> view report load2


    ***********************************************************************
    Oracle GoldenGate Delivery for Oracle
    Version 11.1.1.0.0 Build 078
    Linux, x64, 64bit (optimized), Oracle 11 on Jul 28 2010 15:35:17

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


    Starting at 2011-02-22 19:30:37
    ***********************************************************************

    Operating System Version:
    Linux
    Version #1 SMP Wed Jan 27 18:11:22 EST 2010, Release 2.6.18-186.el5
    Node: illin390
    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: 19861

    Description:

    ***********************************************************************
    ** Running with the following parameters **
    ***********************************************************************
    REPLICAT load2
    USERID ggs_owner,PASSWORD *********
    ASSUMETARGETDEFS
    MAP scott.extract_emp,TARGET scott.extract_emp;

    CACHEMGR virtual memory values (may have been adjusted)
    CACHEBUFFERSIZE: 64K
    CACHESIZE: 512M
    CACHEBUFFERSIZE (soft max): 4M
    CACHEPAGEOUTSIZE (normal): 4M
    PROCESS VM AVAIL FROM OS (min): 1G
    CACHESIZEMAX (strict force to disk): 881M

    Database Version:
    Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
    PL/SQL Release 11.1.0.7.0 - Production
    CORE 11.1.0.7.0 Production
    TNS for Linux: Version 11.1.0.7.0 - Production
    NLSRTL Version 11.1.0.7.0 - Production

    Database Language and Character Set:
    NLS_LANG = "AMERICAN_AMERICA.WE8ISO8859P15"
    NLS_LANGUAGE = "AMERICAN"
    NLS_TERRITORY = "AMERICA"
    NLS_CHARACTERSET = "WE8ISO8859P15"

    For further information on character set settings, please refer to user manual.

    Source Context :
    SourceModule : [er.main]
    SourceID : [home/ecloud/workspace/Build_FBO_OpenSys_r11.1.1.0.0_078_[34086]/perforce/src/app/er/rep.c]
    SourceFunction : [extract_start_point]
    SourceLine : [12689]
    ThreadBacktrace : [7] elements
    : [oravl01/oracle/ggs/replicat(CMessageContext::AddThreadContext()+0x26) [0x5da0b6]]
    : [oravl01/oracle/ggs/replicat(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x7b2) [0x5d0b52]]
    : [oravl01/oracle/ggs/replicat(_MSG_ERR_CHECKPOINT_GENERIC(CSourceContext*, char const*, CMessageFactory::MessageDisposition)+0x92) [0x568fd2]]
    : [oravl01/oracle/ggs/replicat [0x4e87d0]]
    : [oravl01/oracle/ggs/replicat(main+0x1b9e) [0x4f51ce]]
    : [lib64/libc.so.6(__libc_start_main+0xf4) [0x388f61d994]]
    : [oravl01/oracle/ggs/replicat(__gxx_personality_v0+0x1da) [0x4d8e8a]]

    2011-02-22 19:30:37 ERROR OGG-00446 Invalid data source -1 in checkpoint file /oravl01/oracle/ggs/dirchk/LOAD2.cpr.

    2011-02-22 19:30:37 ERROR OGG-01668 PROCESS ABENDING.


    GGSCI (illin390) 20>

    @ replication

    GGSCI (illin390) 20>
    GGSCI (illin390) 20>view ggsevt

    2011-02-22 16:51:50 INFO OGG-00973 Oracle GoldenGate Manager for Oracle, mgr.prm: Manager started replicat task process (Port 7840).
    2011-02-22 16:51:50 INFO OGG-01025 Oracle GoldenGate Delivery for Oracle: REPLICAT task started by manager (port 7840).
    2011-02-22 16:51:55 INFO OGG-01229 Oracle GoldenGate Delivery for Oracle: Connected to illin198.corp.amdocs.com:59082.
    2011-02-22 16:51:55 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, load2.prm: REPLICAT LOAD2 starting.
    2011-02-22 16:51:55 ERROR OGG-00014 Oracle GoldenGate Delivery for Oracle, load2.prm: Unrecognized parameter: TARGETDB. Parameter could be misspelled or unsupported.
    2011-02-22 16:52:00 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, load2.prm: PROCESS ABENDING.
    2011-02-22 19:30:16 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): edit params load2.
    2011-02-22 19:30:37 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): START REPLICAT load2.
    2011-02-22 19:30:37 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host 10.232.200.131 (START REPLICAT LOAD2 ).
    2011-02-22 19:30:37 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: REPLICAT LOAD2 starting.
    2011-02-22 19:30:37 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, load2.prm: REPLICAT LOAD2 starting.
    2011-02-22 19:30:37 ERROR OGG-00446 Oracle GoldenGate Delivery for Oracle, load2.prm: Invalid data source -1 in checkpoint file /oravl01/oracle/ggs/dirchk/LOAD2.cpr.
    2011-02-22 19:30:37 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, load2.prm: PROCESS ABENDING.


    GGSCI (illin390) 21>



    why it is giving exception for invalid data source -1 in chekcpoint file ..

    thanks
    surbhi

    Edited by: user8900216 on Feb 22, 2011 9:44 AM
  • User152973
    User152973 Member Posts: 148
    I think the problem is with your character set which is different in source and target.


    Check this Metalink Doc. for your issue.

    How To Set NLS_LANG When You Run GoldenGate On The Superset Character Sets Database? [ID 969551.1]

    Applies to:
    Oracle GoldenGate - Version: 4.0.0 and later [Release: 4.0.0 and later ]
    Information in this document applies to any platform.

    Solution
    Issue:
    How to set NLS_LANG when you run GoldenGate on the superset character sets database?

    Solution Overview:
    You need to set NLS_LANG when you run GoldenGate on the superset character sets database. That is the character setting in the unix environment should be the same as (or similar to) the one in the source. To be specific, for redo log reading Extract, NLS_LANG needs match to the source database characterset; for Replicat, NLS_LANG needs match to the characterset in the trail file it is reading from. For regular Datapump Extract, NLS_LANG doesn't have any effect.

    Solution Details:
    These superset character sets include WE8ISO8859P1 / UTF8 / ALT24UTFFSS, etc. If NLS_LANG is not set, the default becomes US7ASCII. And some special characters (for example, a two-bytes Western European Character) will not show correctly or cause data corruption.

    Display NLS_LANG in the Replicat profile to see what is set:

    echo $NLS_LANG

    Here is an example of setting NLS_LANG.

    Example: export

    NLS_LANG="AMERICAN_AMERICA.AL32UTF8"

    You can use the following commands to check the database character sets.
    SQL> SHOW PARAMETER NLS_LANGUAGE;


    SQL> SELECT name, value$ from SYS.PROPS$ WHERE name='NLS_CHARACTERSET';



    SQL> SELECT * from NLS_DATABASE_PARAMETERS;



    SQL> SELECT * FROM NLS_INSTANCE_PARAMETERS;



    If the change is at OS level, GG manager needs to be restarted, as well as all GG groups (extract/replicat). If the change is inside GG groups with SETENV parameter, it must be BEFORE the USERID parameter.

    The Replicat report file will also display the settings as listed below so checking this will determine what the Replicat is using:

    ..............


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

    .............


    Potential Effects of Wrong NLS_LANG setting:

    1. data loss or data corruption
    for example, source db is UTF8 and target is WE8ISO8859P1.
    if UTF8 and WE8ISO8859P1 are used as NLS_LANG, in extract and replicat respectively (same as connecting DB), one 2-byte UTF8 character in source may become 2 characters in target.

    2. ORA-12705: invalid or unknown NLS parameter value specified.
    An example is shown in KM DOC ID 969651.1

    3. ORA-01461 error
    See KM Doc ID 966156.1

    4. Ora-00600, [kole_t2u], [34]
    This was reported when source data is single byte LATIN-1 of Sybase, and target oracle DB is 11.1.0.7 with AL32UTF8 characterset. The replication was for a LOB data. The solution was to set replicat NLS_LANG to AMERICAN_AMERICA.WE8ISO8859P1.
  • stevencallan
    stevencallan Member Posts: 3,459
    edited Feb 22, 2011 1:48PM
    The NLS stuff is background noise. Linux, Oracle, Scott schema, that does not matter and is not going to cause any errors.

    Basic troubleshooting - instead of going from source to replicat, see if you can at least extract to a local trail. If that works, then work on data pump to replicat. Then once the remote trails are created okay, work on replicat. Running without a secondary extract (data pump) violates a best practice. It's not even worth doing. Even for an initial load. Use initial load via file to replicat instead of direct load.

    Again, simply follow the tutorial. Just replace the tables/schema with the Scott EMP table.


    1.Add the initial load capture batch task group
    --On SORUCE
    ADD EXTRACT EINI01, SOURCEISTABLE

    Verify
    info extract *, tasks

    2. Configure the initial load capture parameter file
    --On SOURCE
    EDIT PARAMS EINI01
    --
    -- GoldenGate Initial Data Capture
    -- for TCUSTMER and TCUSTORD
    --
    EXTRACT EINI01
    USERID ggs, PASSWORD ggs
    RMTHOST otn.localdomain, MGRPORT 7809
    RMTTASK REPLICAT, GROUP RINI01
    TABLE SRC.TCUSTMER;
    TABLE SRC.TCUSTORD;

    3. Add the initial load delivery batch task
    --On the TARGET

    ADD REPLICAT RINI01, specialrun
    info replicat *, tasks

    4. Configure the initial load delivery parameter file
    --On TARGET
    edit params rini01

    --
    -- Initial Load Delivery
    --
    --replace "star" with an asterisk because of crappy OTN web site
    REPLICAT RINI01
    ASSUMETARGETDEFS
    USERID ggs, PASSWORD ggs
    DISCARDFILE ./dirrpt/RINI01.dsc, PURGE
    MAP SRC.star, TARGET TGT.star;

    5. Execute the initial load process
    --On SOURCE
    start extract eini01
    view report eini01
    --on the target system if using one, local otherwise
    view report rini01

    --On TARGET
    Verify
    select * from tgt.tcustmer;
    select * from tgt.tcustord;
  • Hi ,

    thanks !!
    it is working now...


    surbhi
  • 851679
    851679 Member Posts: 1
    edited Mar 30, 2011 2:09PM
    Hi to all!!!

    i haved the same problem... but i am working only in 1 server with 1 Oracle database (lab machine, educational). was the same problem, and i fixed watching your post.

    Many thanks! :)

    Edited by: user13529591 on 30-mar-2011 11:08
This discussion has been closed.