Oracle Golden Gate updation Issue.
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Oracle Golden Gate updation Issue.

Hybrid View

  1. #1
    Join Date
    May 2010
    Posts
    4

    Oracle Golden Gate updation Issue.

    Hi All,

    I have planned to use Oracle Golden Gate for schema/selected tables replication. I done installation successful.
    The manager, extraction & replication process get started. Before that my team, read major GG related docs.
    After all installation, we started testing and found that updation to the tables replication does not work. While
    testing DDL, Inserts, deletion worked fine (replication to other schema happened).


    We have done setting on Linux & windows and to both db updation replication does not works. The setting is - one DB
    having one schem as source and other schema as target. DLL/insert/deletion/trucation happens correctly but while update
    follwoing error to ggserr.log

    2010-05-27 10:43:52 GGS INFO 320 Oracle GoldenGate Delivery for Oracle, REP1.prm: REPLICAT REP1 starting.
    2010-05-27 10:43:52 GGS INFO 320 Oracle GoldenGate Delivery for Oracle, REP1.prm: REPLICAT REP1 started.
    2010-05-27 10:46:03 GGS INFO Z0-05E Oracle GoldenGate Delivery for Oracle, REP1.prm: Setting current schema for DDL operation to [RECEIVER].
    2010-05-27 10:46:03 GGS INFO Z0-05F Oracle GoldenGate Delivery for Oracle,
    REP1.prm: Restoring current schema for DDL operation to [GGATE].
    2010-05-27 10:47:07 GGS WARNING 218 Oracle GoldenGate Delivery for Oracle, REP1.prm: Aborted grouped transaction on 'RECEIVER.TEST_TAB_1', Database error 100 (retrieving bind info for query).
    2010-05-27 10:47:07 GGS WARNING 218 Oracle GoldenGate Delivery for Oracle, REP1.prm: Repositioning to rba 2637 in seqno 0.
    2010-05-27 10:47:07 GGS WARNING 218 Oracle GoldenGate Delivery for Oracle, REP1.prm: SQL error 1403 mapping SENDER.TEST_TAB_1 to RECEIVER.TEST_TAB_1.
    2010-05-27 10:47:07 GGS WARNING 218 Oracle GoldenGate Delivery for Oracle, REP1.prm: Repositioning to rba 2637 in seqno 0.
    2010-05-27 10:47:07 GGS ERROR 218 Oracle GoldenGate Delivery for Oracle, REP1.prm: Error mapping from SENDER.TEST_TAB_1 to RECEIVER.TEST_TAB_1.
    2010-05-27 10:47:07 GGS ERROR 190 Oracle GoldenGate Delivery for Oracle,

    Kindly help me to resolve above issue.


    The following are the process setups:

    --extract group--
    extract ext1
    --connection to database--
    userid ggate, password qwerty
    --hostname and port for trail--
    rmthost 10.1.1.117, mgrport 7809
    --path and name for trail--
    rmttrail 'd:\ogg10g\dirdat\lt'
    --DDL support
    ddl include mapped objname sender.*;
    --DML
    table sender.*


    --Replicat group --
    replicat rep1
    --source and target definitions
    ASSUMETARGETDEFS
    --target database login --
    userid ggate, password ggate
    --file for dicarded transaction --
    discardfile d:\ogg10g\dirdat\rep1_discard.txt, append, megabytes 10
    --ddl support
    DDL
    --Specify table mapping ---
    map sender.*, target receiver.*;


    create table sender.test_tab_1 (id number,rnd_str varchar2(12));

    DECLARE
    BEGIN
    FOR i IN 1 .. 10 LOOP
    INSERT INTO test_tab_1 VALUES (i, 'INDUS' );

    END LOOP;
    COMMIT;

    END;
    /

    update test_tab_1
    set rnd_str = ' RSYS'
    where id = 5;

  2. #2
    Join Date
    May 2010
    Posts
    4
    Hi All,

    Last four days, I have observed the issue. Can anybody provide immediate soultion to for it. Where I am wrong? Any more inputs req ? Pl help me.

    Regards,

    Kiran

  3. #3
    Join Date
    May 2010
    Posts
    4
    Hi All,

    To the below issue, I got the solution. Its working now.

    Thanks

    Kiran

  4. #4
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    Kiran,

    Would you mind to share the solution?

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  5. #5
    Join Date
    May 2010
    Posts
    4
    Hi vnktummala,

    I login as ggate and executed following:

    GGSCI 2> dblogin userid ggate
    Password:
    Successfully logged into database.

    GGSCI 3> ADD TRANDATA sender.test_tab_1, COLS (rnd_str)

    Logging of supplemental redo data enabled for table sender.test_tab_1

    This information is also available in GG troubleshooting guide.

    After this updation started happening. Really, GG is good and can be used for replication.

    Thanks

    Kiran

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width