9 Replies Latest reply: Nov 25, 2011 10:41 AM by stevencallan RSS

    Steps to install and setup Oracle GoldenGate 11g Release 1 (11.1.1)

    LazyOraDBA
      Hello Guys,

      Environment is as below:

      Primary site (source): This is production DB and up and running.

      RAC 2 nodes
      Oracle RAC 11gr2
      ASM
      Enterprise Linux Server release 5.5 (Carthage)

      target Site (destination): Software installed and instance has been created.

      Standalone single server - Non RAC
      Oracle 11gr2
      ASM
      Enterprise Linux Server release 5.5 (Carthage)

      I am new to GG and I need to install and setup Oracle GoldenGate 11g Release 1 (11.1.1).

      can anyone give me full steps from scratch ?

      Confusions:

      1.Do we need to install GG on all nodes?
      2.db_name and instance name can be different on source and destination ?
      3.Do we need to set any specific parameters in pfile/spfile for GG on source and destination?
      4.any specific entries in listener.ora and tnsnames.ora for connectivity between source and destination?
      5.Do we to configure anything on ASM for GG installation?
      6.Do we need to create Standby DB first before GG installation?

      responses will be highly appreciated.

      Reagrds,

      Edited by: LazyDBA11g on Apr 14, 2011 12:32 AM

      Edited by: LazyDBA11g on Apr 14, 2011 12:40 AM

      Edited by: LazyDBA11g on Apr 14, 2011 6:01 AM
        • 1. Re: Steps to install and setup Oracle GoldenGate 11g Release 1 (11.1.1)
          Srini Chavali-Oracle
          Have you checked the documentation ? http://www.oracle.com/technetwork/middleware/goldengate/documentation/index.html

          Srini
          • 2. Re: Steps to install and setup Oracle GoldenGate 11g Release 1 (11.1.1)
            LazyOraDBA
            Thanks Srini,

            I have documentation and have already gone through it.I want self-explainatory steps and clarifications as above.


            Regards,
            • 3. Re: Steps to install and setup Oracle GoldenGate 11g Release 1 (11.1.1)
              Srini Chavali-Oracle
              LazyDBA11g wrote:
              Thanks Srini,

              I have documentation and have already gone through it.I want self-explainatory steps and clarifications as above.


              Regards,
              So after reading the documentation, what have you determined to be the answers to your questions ?

              Srini
              • 4. Re: Steps to install and setup Oracle GoldenGate 11g Release 1 (11.1.1)
                LazyOraDBA
                Hello Srini,

                My queries still remain un-addressed.


                Regards,

                LazyDBA11g
                • 5. Re: Steps to install and setup Oracle GoldenGate 11g Release 1 (11.1.1)
                  851529
                  Oracle goldengate Administration guide for 11g is the best source to go......
                  • 6. Re: Steps to install and setup Oracle GoldenGate 11g Release 1 (11.1.1)
                    myra
                    1.Do we need to install GG on all nodes?---No, only on one node
                    2.db_name and instance name can be different on source and destination ?---yes can be different
                    3.Do we need to set any specific parameters in pfile/spfile for GG on source and destination?----Configure extract using THREAD option
                    4.any specific entries in listener.ora and tnsnames.ora for connectivity between source and destination?----ASM entry in tns file
                    5.Do we to configure anything on ASM for GG installation? NO
                    6.Do we need to create Standby DB first before GG installation? NO
                    • 7. Re: Steps to install and setup Oracle GoldenGate 11g Release 1 (11.1.1)
                      876431
                      Hi,

                      Please find answers to your queries.

                      1.Do we need to install GG on all nodes?
                      Ans: NO,Install OGG on one of the node

                      2.db_name and instance name can be different on source and destination ?
                      Ans: Yes, it can be different on source and target DB environments

                      3.Do we need to set any specific parameters in pfile/spfile for GG on source and destination?
                      Ans:NO, there is no specific parameters need to be introduced in pfile or spfile, all the configuration need to be done in OGG by specifying the SID to which it needs to connect and number of threads it needs to read/capture.

                      4.any specific entries in listener.ora and tnsnames.ora for connectivity between source and destination?
                      Ans: Entries related to DB instance and ASM instance need to be specified in tnsnames.ora. List the ASM instance in the tnsnames.ora file. The recommended method for connecting to an ASM instance when Oracle GoldenGate is running on the database host machine is to use a bequeath (BEQ) protocol. If using the TCP/IP protocol, verify that the Oracle listener is listening for new
                      connections to the ASM instance.

                      5.Do we to configure anything on ASM for GG installation?
                      Ans: NO, Need to use the TRANLOGOPTIONS parameter with the ASMUSER and ASMPASSWORD options for the ASM user in the OGG Extract parameter file to connect to the ASM.Oracle GoldenGate does not support using operating-system authentication for the ASM user. You can use SYS user or any user with SYSDBA privileges in the ASM instance.

                      6.Do we need to create Standby DB first before GG installation?
                      Ans: NO


                      Installation steps
                      ------------------------
                      1.Extract the build
                      $ tar -xvf <gg.build.tar>
                      2. Create sub-directories:
                      Source & Target environments
                      $ ./ggsci
                      GGSCI>create subdirs

                      3. Configure Source database
                      a. Switch the database to archivelog mode:
                      SQL> shutdown immediate
                      SQL> startup mount
                      SQL> alter database archivelog;
                      SQL> alter database open;

                      b. Enable minimal supplemental logging:
                      SQL> alter database add supplemental log data;

                      c. Prepare the database to support ddl replication
                      --Turn off recyclebin for the database . . .
                      SQL> alter system set recyclebin=off scope=both;

                      d.Create schema for ddl support replication
                      SQL>Create tablespace OGGDATA datafile '+ASM1/oggdata01.dbf' size 1000M autoextend ON;
                      SQL>create user ogg identified by ogg@321! default tablespace OGGDATA temporary tablespace TEMP profile DEFAULT;
                      SQL>alter user ogg QUOTA UNLIMITED ON OGGDATA;
                      SQL>grant RESOURCE,CONNECT to ogg;
                      SQL>grant CREATE SESSION,ALTER SESSION to ogg;
                      SQL>grant SELECT ANY TABLE to ogg;
                      SQL>grant CREATE TABLE to OGG;
                      SQL>grant FLASHBACK ANY TABLE to ogg;
                      SQL>grant SELECT ANY DICTIONARY to ogg;
                      SQL>grant execute on dbms_flashback to ogg;
                      SQL>grant execute on utl_file to ogg;

                      e.Run scripts for creating all necessary objects for support ddl replication:
                      SQL> @$ogg/marker_setup.sql
                      SQL> @$ogg/ddl_setup.sql
                      SQL> @$ogg/role_setup.sql
                      SQL> grant GGS_GGSUSER_ROLE to ogg;
                      SQL> @$ogg/ddl_enable.sql

                      4.Replication
                      a.Create and start manager on the source and the destination.
                      $ cd $ogg
                      $ ./ggsci

                      GGSCI> edit params mgr

                      PORT 7809
                      AUTORESTART ER *, RETRIES 3, WAITMINUTES 5, RESETMINUTES 30
                      PURGEOLDEXTRACTS ./dirdat/T*, USECHECKPOINTS, MINKEEPFILES 10

                      GGSCI> start manager
                      GGSCI>info all

                      GGSCI> edit params ./GLOBAL

                      GGSCHEMA ogg

                      GGSCI> dblogin userid ogg password ogg@321!
                      GGSCI> add trandata schema1.*

                      b. Create the extract group on the source side:
                      GGSCI>ADD EXTRACT EXT1, TRANLOG, BEGIN NOW, THREADS 2
                      GGSCI>ADD EXTTRAIL ./dirdat/T1, EXTRACT EXT1, MEGABYTES 100

                      GGSCI> edit params EXT1

                      EXTRACT EXT1
                      SETENV (ORACLE_HOME = "/oracle/orabin/product/10.2.4")
                      SETENV (ORACLE_SID = "prd")
                      SETENV (NLS_LANG = "AMERICAN_AMERICA.WE8ISO8859P1")
                      USERID ogg@prd, PASSWORD ogg@321!
                      TRANLOGOPTIONS ASMUSER sys@+ASM1, ASMPASSWORD asm321
                      EXTTRAIL ./dirdat/T1
                      DISCARDFILE ./dirrpt/EXT1.DSC, PURGE, MEGABYTES 100
                      DDL INCLUDE MAPPED OBJNAME "schema1.*"
                      DDLOPTIONS ADDTRANDATA RETRYOP RETRYDELAY 60 MAXRETRIES 10, REPORT
                      TABLE schema1.*;

                      Note: Make sure you add TNS entry for ASM instance

                      GGSCI> ADD EXTRACT PMP1, EXTTRAILSOURCE ./dirdat/T1
                      GGSCI> ADD EXTTRAIL ./dirdat/P1, EXTRACT PMP1, MEGABYTES 100
                      GGSCI> edit params PMP1

                      EXTRACT PMP1
                      SETENV (ORACLE_HOME = "/oracle/orabin/product/10.2.4")
                      SETENV (ORACLE_SID = "prd")
                      SETENV (NLS_LANG = "AMERICAN_AMERICA.WE8ISO8859P1")
                      USERID ogg@prd, PASSWORD ogg@321!
                      PASSTHRU
                      RMTHOST dr, MGRPORT 7810
                      RMTTRAIL ./dirdat/P1
                      TABLE schema1.*;

                      Target DB:
                      ===========
                      $ cd $ogg
                      $ ./ggsci

                      GGSCI> edit params mgr

                      PORT 7810
                      AUTORESTART ER *, RETRIES 3, WAITMINUTES 5, RESETMINUTES 30
                      PURGEOLDEXTRACTS ./dirdat/P*, USECHECKPOINTS, MINKEEPFILES 10

                      GGSCI> start manager
                      GGSCI>info all

                      GGSCI> edit params ./GLOBAL

                      GGSCHEMA ogg

                      GGSCI> dblogin userid ogg password ogg@321!
                      GGSCI> add checkpointtable ogg.checkpoint

                      GGSCI>ADD REPLICAT REP1, RMTTRAIL ./dirdat/P1, checkpointtable ogg.checkpoint

                      Create parameter file for replicat:
                      GGSCI> edit params REP1

                      REPLICAT REP1
                      SETENV (ORACLE_HOME = “/oracle/orabin/product/10.2.4”)
                      SETENV (ORACLE_SID = “dr”)
                      SETENV (NLS_LANG = “AMERICAN_AMERICA.WE8ISO8859P1”)
                      ASSUMETARGETDEFS
                      USERID ogg@DR, PASSWORD ogg@321!
                      DISCARDFILE ./dirrpt/REP1.DSC, append, megabytes 100
                      DDL INCLUDE MAPPED OBJNAME "schema1.*"
                      MAP schema1.*, TARGET schema1.*;

                      # Start extract and replicat on source and target OGG environments:

                      Source:
                      GGSCI> start er *

                      Destination:
                      GGSCI> start er *

                      Thanks & Regards
                      SK
                      • 8. Re: Steps to install and setup Oracle GoldenGate 11g Release 1 (11.1.1)
                        800158
                        I have configured GoldenGate with Oracle (non-rac) database on same machine.

                        Both Extract and Replicat are running fine. However if i create a table i do not see it appear in the other database (Replicat).

                        I also tried having same table with same structure in Source and Destination database. and then inserted values in Source database and commited it. Still no difference at Replicat side. Can you please help me understand what could be the issue?

                        below are the steps followed can you please correct if i have missed or needs modification?


                        1) created 2 databases a and b in same machine.
                        2) created ggate in database a and ggate1 in database b, with appropriate grants mentioned above in the post.
                        3) created dma66e user in DB a and dma66r user in DB b
                        4) below commands were executed (i have tried by executing only in a database and not in b, as well as in both databases (a and b))
                        shutdown immediate
                        startup mount
                        alter database archivelog;
                        alter database open;
                        alter database add supplemental log data;
                        alter system set recyclebin=off scope=spfile;

                        5) Scripts were executed (i have tried by executing only in a database and not in b, as well as in both databases (a and b))
                        @$GGATE/marker_setup.sql
                        @$GGATE/ddl_setup.sql
                        @$GGATE/role_setup.sql
                        grant GGS_GGSUSER_ROLE to ggate;
                        @$GGATE/ddl_enable.sql

                        6) both managers were started in source and destination GG

                        from GGSCI Source
                        4) add extract extcdm, tranlog, begin now

                        5) add exttrail E:\oracle\app\product\GoldenGates\Extract\dirdat\lt, extract extcdm

                        6) EXTRACT extcdm
                        SETENV (ORACLE_HOME = "E:\oracle\app\product\11.2.0\dbhome_1")
                        SETENV (ORACLE_SID = "CDMEXT")
                        USERID ggate, PASSWORD ggate
                        EXTTRAIL E:\oracle\app\product\GGate\Extract\dirdat\lt
                        rmttrail E:\oracle\app\product\GGate\Extract\dirdat\lt
                        rmthost PCRAGHPW7, mgrport 7809
                        DISCARDFILE E:\oracle\app\product\GGate\Extract\discard\discard.txt, PURGE, MEGABYTES 100
                        DDL INCLUDE MAPPED OBJNAME "dma66e.*"
                        DDLOPTIONS ADDTRANDATA RETRYOP RETRYDELAY 60 MAXRETRIES 10, REPORT
                        TABLE dma66e.*;

                        from GGSCI Destination
                        7) add replicat CDMREP, exttrail E:\oracle\app\product\GoldenGates\Extract\dirdat\lt,checkpointtable ggate1.checkpoint

                        8) REPLICAT CDMREP
                        SETENV (ORACLE_HOME = "E:\oracle\app\product\11.2.0\dbhome_1")
                        SETENV (ORACLE_SID = "CDMREP")
                        ASSUMETARGETDEFS
                        USERID ggate1, PASSWORD ggate1
                        DISCARDFILE E:\oracle\app\product\GGate\Rep\discard\discard.txt, append, megabytes 100
                        DDL INCLUDE MAPPED OBJNAME "dma66e.*"
                        MAP dma66e.*, TARGET dma66r.*;
                        • 9. Re: Steps to install and setup Oracle GoldenGate 11g Release 1 (11.1.1)
                          stevencallan
                          The GoldenGate forum is over here:
                          GoldenGate

                          Instead of hijacking an old thread with an unrelated issue (is yours about installing GoldenGate, or trying to get it to work?), start a new one.

                          See the tutorial here for an example:
                          http://apex.oracle.com/pls/apex/f?p=44785:24:6290898492675501::NO:24:P24_CONTENT_ID,P24_PREV_PAGE:5340,2