1 Reply Latest reply: Sep 2, 2013 8:52 PM by stevencallan RSS

    GoldenGate Replication - Between Schemas On Same Host

    895876

      Guys - My requirement is fairly simple.I have two schemas, GG [Source] and GGR [Target] on the same host. Have one table called GG.SYNC_TABLE. I am having difficulties to push data from GG to GGR

       

      Below are the extract and replicat information

       

      EXTRACT EXT_AP1
      SETENV (ORACLE_SID=ERPA4)
      RMTHOST mdeagaix825, mgrport 7809
      USERID GG@ERPA4, PASSWORD goldengate1
      DISCARDFILE ./dirrpt/ext_ap1_discard.rpt, append, megabytes 50
      RMTTRAIL ./dirdata/sa
      TABLE GG.AP_AE_HEADERS_ALL;
      TABLE GG.AP_AE_LINES_ALL;
      TABLE GG.AP_BANK_ACCOUNTS_ALL;
      TABLE GG.AP_BANK_BRANCHES;
      TABLE GG.AP_CARDS_ALL;
      TABLE GG.AP_CHECKS_ALL;
      TABLE GG.AP_CREDIT_CARD_TRXNS_ALL;
      TABLE GG.AP_EXPENSE_REPORTS_ALL;
      TABLE GG.AP_EXPENSE_REPORT_HEADERS_ALL;
      TABLE GG.AP_EXPENSE_REPORT_LINES_ALL;
      TABLE GG.AP_EXPENSE_REPORT_PARAMS_ALL;
      TABLE GG.AP_EXP_REPORT_DISTS_ALL;
      TABLE GG.AP_HOLDS_ALL;
      TABLE GG.AP_HOLD_CODES;
      TABLE GG.AP_INVOICES_ALL;
      TABLE GG.AP_INVOICE_DISTRIBUTIONS_ALL;
      TABLE GG.AP_INVOICE_LINES_ALL;
      TABLE GG.AP_INVOICE_PAYMENTS_ALL;
      TABLE GG.AP_NOTES;
      TABLE GG.AP_PAYMENT_HISTORY_ALL;
      TABLE GG.AP_PAYMENT_HIST_DISTS;
      TABLE GG.AP_PAYMENT_SCHEDULES_ALL;
      TABLE GG.AP_POL_VIOLATIONS_ALL;
      TABLE GG.AP_SELF_ASSESSED_TAX_DIST_ALL;
      TABLE GG.AP_SUPPLIERS;
      TABLE GG.AP_SUPPLIER_SITES_ALL;
      TABLE GG.AP_SYSTEM_PARAMETERS_ALL;
      TABLE GG.AP_TERMS_LINES;
      TABLE GG.AP_TOLERANCE_TEMPLATES;
      TABLE GG.SYNC_TABLE;

       

      REPLICAT REP_AP1

      SETENV (ORACLE_SID=ERPA4)

      USERID GG@ERPA4, PASSWORD goldengate1

      ASSUMETARGETDEFS

      REPORTCOUNT EVERY 1 MINUTES, RATE

      DISCARDFILE ./dirrpt/rep_ap1.dsc, PURGE

      MAP GG.AP_AE_HEADERS_ALL, TARGET GGR.AP_AE_HEADERS_ALL;

      MAP GG.AP_AE_LINES_ALL, TARGET GGR.AP_AE_LINES_ALL;

      MAP GG.AP_BANK_ACCOUNTS_ALL, TARGET GGR.AP_BANK_ACCOUNTS_ALL;

      MAP GG.AP_BANK_BRANCHES, TARGET GGR.AP_BANK_BRANCHES;

      MAP GG.AP_CARDS_ALL, TARGET GGR.AP_CARDS_ALL;

      MAP GG.AP_CHECKS_ALL, TARGET GGR.AP_CHECKS_ALL;

      MAP GG.AP_CREDIT_CARD_TRXNS_ALL, TARGET GGR.AP_CREDIT_CARD_TRXNS_ALL;

      MAP GG.AP_EXPENSE_REPORTS_ALL, TARGET GGR.AP_EXPENSE_REPORTS_ALL;

      MAP GG.AP_EXPENSE_REPORT_HEADERS_ALL, TARGET GGR.AP_EXPENSE_REPORT_HEADERS_ALL;

      MAP GG.AP_EXPENSE_REPORT_LINES_ALL, TARGET GGR.AP_EXPENSE_REPORT_LINES_ALL;

      MAP GG.AP_EXPENSE_REPORT_PARAMS_ALL, TARGET GGR.AP_EXPENSE_REPORT_PARAMS_ALL;

      MAP GG.AP_EXP_REPORT_DISTS_ALL, TARGET GGR.AP_EXP_REPORT_DISTS_ALL;

      MAP GG.AP_HOLDS_ALL, TARGET GGR.AP_HOLDS_ALL;

      MAP GG.AP_HOLD_CODES, TARGET GGR.AP_HOLD_CODES;

      MAP GG.AP_INVOICES_ALL, TARGET GGR.AP_INVOICES_ALL;

      MAP GG.AP_INVOICE_DISTRIBUTIONS_ALL, TARGET GGR.AP_INVOICE_DISTRIBUTIONS_ALL;

      MAP GG.AP_INVOICE_LINES_ALL, TARGET GGR.AP_INVOICE_LINES_ALL;

      MAP GG.AP_INVOICE_PAYMENTS_ALL, TARGET GGR.AP_INVOICE_PAYMENTS_ALL;

      MAP GG.AP_NOTES, TARGET GGR.AP_NOTES;

      MAP GG.AP_PAYMENT_HISTORY_ALL, TARGET GGR.AP_PAYMENT_HISTORY_ALL;

      MAP GG.AP_PAYMENT_HIST_DISTS, TARGET GGR.AP_PAYMENT_HIST_DISTS;

      MAP GG.AP_PAYMENT_SCHEDULES_ALL, TARGET GGR.AP_PAYMENT_SCHEDULES_ALL;

      MAP GG.AP_POL_VIOLATIONS_ALL, TARGET GGR.AP_POL_VIOLATIONS_ALL;

      MAP GG.AP_SELF_ASSESSED_TAX_DIST_ALL, TARGET GGR.AP_SELF_ASSESSED_TAX_DIST_ALL;

      MAP GG.AP_SUPPLIERS, TARGET GGR.AP_SUPPLIERS;

      MAP GG.AP_SUPPLIER_SITES_ALL, TARGET GGR.AP_SUPPLIER_SITES_ALL;

      MAP GG.AP_SYSTEM_PARAMETERS_ALL, TARGET GGR.AP_SYSTEM_PARAMETERS_ALL;

      MAP GG.AP_TERMS_LINES, TARGET GGR.AP_TERMS_LINES;

      MAP GG.AP_TOLERANCE_TEMPLATES, TARGET GGR.AP_TOLERANCE_TEMPLATES;

      MAP GG.SYNC_TABLE, TARGET GGR.SYNC_TABLE;

       

      Extract, Replicat and Manager processes are running fine. But a commit on target is not propagating the data across to GGR schema. Supplemental logging is enabled. Archiving is not [I hope its not required]. What do you think I am missing here?

       

      I am fairly new to GoldenGate, Hence if you want me to run any commands, Please provide the commands. Thanks much in advance.