This discussion is archived
9 Replies Latest reply: Nov 25, 2011 8:41 AM by stevencallan RSS

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

LazyDBA11g Newbie
Currently Being Moderated
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 Oracle ACE Director
    Currently Being Moderated
    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)
    LazyDBA11g Newbie
    Currently Being Moderated
    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 Oracle ACE Director
    Currently Being Moderated
    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)
    LazyDBA11g Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points