2 Replies Latest reply: Jan 16, 2013 12:37 AM by Kgronau-Oracle RSS

    Configure

    941319
      Hi All,

      i have configured OGG like below but it is not replicating.

      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
        • 1. Re: Configure
          Annamalai A
          Hi,

          1. What is your requirement? are trying to configure uni directional(one way) or Bi - directional(two way) replication?

          2. as per your below setup from manager parameter file ,

          Source side manager prm file , the purgeoldextracts is not configured correctly , it should be with ext trail file name or '*' , like the below example

          PURGEOLDEXTRACTS ./dirdat/ut*, USECHECKPOINTS, MINKEEPHOURS 2


          3. the ext trail file and rmt trail file name should not be same , also the rmt trail file path must be your target environment directory path,

          here you have configured the both path name and file name are same,

          4. and if you are going to configure bi directional replication, better to first configure uni directional and test it then move to bi directional.

          5. see the below config steps,


          i. add supplemental log data on both database (if the requirment is two way)

          ii. Souce:

          --------------------------------------------------------------------------------
          MGR PARAMETER
          PORT 7809
          DYNAMICPORTLIST 7810-7820
          PURGEOLDEXTRACTS /exports/OGG10g_Home/dirdat/ut*, usecheckpoints


          ii. execute requird DDL scripts on source database connected as sys user or sysdba privileged user,


          iii, change the rmttrail path , give path name as available in target database,


          for ex,

          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 <this path should be target environment path and trail file name also different one from source exttrail >, extract pmpsimple, megabytes 50


          iv, updte the pmp parameter file with new rmt trail file name,


          finally recommend to go through the below link tutorial for Using Oracle GoldenGate for Oracle to Oracle Database Synchronization,

          http://apex.oracle.com/pls/apex/f?p=44785:24:8343116176167:::24:P24_CONTENT_ID,P24_PREV_PAGE:5340,24

          also refer the oracle goldengate admin guide,

          hopefully this will help you

          Annamalai
          • 2. Re: Configure
            Kgronau-Oracle
            on the source database side, can you please execute this select: SELECT supplemental_log_data_min FROM v$database; and provide the output?