1 Reply Latest reply: Jan 16, 2013 12:38 AM by Kgronau-Oracle RSS

    Oracle goldengate configureation

    941319
      Souce:
      ----------
      MGR PARAMETER
      PORT 7809
      DYNAMICPORTLIST 7810-7820
      PURGEOLDEXTRACTS /exports/OGG10g_Home/dirdat

      dblogin userid adm1, password adm1


      SQLPLUS ORCL (SYS USER)
      =========
      @marker_setup.sql
      @ddl_setup.sql
      @role_setup.sql

      grant GGS_GGSUSER_ROLE to adm1;

      @ddl_enable.sql

      dblogin userid adm1, password adm1

      add trandata scott.*

      exteimple parameter

      EXTRACT extsimple
      EXTTRAIL /exports/OGG10g_Home/dirdat/ut
      DISCARDFILE /exports/OGG10g_Home/dirrpt/simple.dsc
      SETENV (ORACLE_SID = "ORCL")
      USERID adm1, PASSWORD adm1
      DBOPTIONS ALLOWUNUSEDCOLUMN
      TRANLOGOPTIONS EXCLUDEUSER adm1
      DDL INCLUDE MAPPED OBJNAME scott.*
      DDLOPTIONS ADDTRANDATA, REPORT
      TABLE scott.*;

      PMPSIMPLE PARAMETER

      EXTRACT pmpuat
      RMTHOST 183.82.143.49, MGRPORT 7809, COMPRESS
      RMTTRAIL /exports/OGG10g_Home/dirdat/ut
      SETENV (ORACLE_SID = "raja")
      TRANLOGOPTIONS EXCLUDEUSER adm1
      PASSTHRU
      TABLE scott.*;



      add extract extsimple, tranlog, begin now
      add exttrail /exports/OGG10g_Home/dirdat/ut, extract extsimple, megabytes 50
      add extract pmpsimple, exttrailsource /exports/OGG10g_Home/dirdat/ut
      add rmttrail /exports/OGG10g_Home/dirdat/ut, extract pmpsimple, megabytes 50

      start extract extsimple
      start extract pmpsimple

      add checkpointtable simple
      add replicat repsimple, exttrail /exports/OGG10g_Home/dirdat/tu, CHECKPOINTTABLE simple

      start replicat repsimple



      Target:
      -----------
      MGR PARAMETER
      PORT 7809
      DYNAMICPORTLIST 7810-7820
      PURGEOLDEXTRACTS /exports/OGG10g_Home/dirdat/*, USECHECKPOINTS


      dblogin userid adm2, password adm2


      RAJA AT SQLPLUS (SYS USER)
      ========
      @marker_setup.sql
      @ddl_setup.sql

      @role_setup.sql

      grant GGS_GGSUSER_ROLE to adm2;

      @ddl_enable.sql



      dblogin userid adm2, password adm2

      add trandata scott.*

      REPLICATION PARAMETER

      REPLICAT repsimple
      ASSUMETARGETDEFS
      APPLYNOOPUPDATES
      DISCARDFILE /exports/OGG10g_Home/dirrpt/repuat.dsc,
      SETENV (ORACLE_SID = "raja")
      USERID adm2 PASSWORD adm2
      MAP scottt.*, TARGET scott.*;

      add checkpointtable simple1
      add replicat repsimple1, exttrail /exports/OGG10g_Home/dirdat/ut, CHECKPOINTTABLE simple

      start replicat repuat

      add extract extsimple1, tranlog, begin now
      add exttrail /exports/OGG10g_Home/dirdat/tu, extract extsimple1, megabytes 50
      add extract pmpsimple1, exttrailsource /exports/OGG10g_Home/dirdat/tu
      add rmttrail /exports/OGG10g_Home/dirdat/tu, extract pmpsimple1, megabytes 50

      start extract extsimple1
      start extract pmpsimple1


      Thanks
      Rajasekhar