1. Home
  2. Knowledge Base
  3. GoldenGate
  4. Oracle GoldenGate Tutorials now available …..

Oracle GoldenGate Tutorials now available …..

  • GoldenGate Concepts and Architecture
  • Installation on Red Hat Linux with Oracle 11g
  • Configuring the Manager process
  • Performing an initial data load
  • Configuring online change synchronization
  • Configuring the Data Pump process
  • Configuring DDL Synchronization
  • Filtering and Mapping data
  • Monitoring Goldengate
  • Performing a zero downtime cross platform database upgrade
  • Installing the GoldenGate Director and Client
  • Using the GoldenGate Director and Client
  • GoldenGate Veridata Installation and Configuration
  • GoldenGate Veridata Agent Installation and Configuration
  • The following two tabs change content below.

    Gavin Soorma

    Latest posts by Gavin Soorma (see all)

    Updated on June 2, 2021

    Was this article helpful?

    Related Articles

    Comments

    1. Hi Gavin,

      i am planning to do below activities on my prod.

      1. Upgrade 10 2 0 4 to 10 2 0 5 (same linux 64 bit OS) with 0 downtime.

      2. application will be pointed to upgraded 10 20 5 db. then due to some issue. planning to rollback to 10 2 0 4 version.

      let me know if you have any material for this setup

      thanks
      raji

    2. Hi Raji – not sure what you mean … do you want to test how to downgrade the database from 10.2.0.5 to 10.2.0.4 in case you encounter some issue?

      Also – how are you doing the upgrade from 10.2.0.4 to 10.2.0.5 without any downtime?

    3. Hi Gavin,

      I had a doubt about the GoldenGate setup. We have seen that GG works at table/column level mapping too. Thanks for your posts. I would like to know, if the mapping can be done at schema level.
      I know we can create groups but this is still all tables.

      Please guide me.

      Thanks,
      Ramesh.

    4. Hi Ramesh – you can use wildcards to include all the tables in a schema – for example we can say TABLES=SCOTT.* – regards,
      Gavin

    5. I have this error in AIX 64 bit 6.1 oracle 10.2.0.5. It does not happend with 10.2.0.4, is 10.2.0.5 the problem?

      sbl-db-dr:/gg/goldengate $ ggsci
      exec(): 0509-036 Cannot load program ggsci because of the following errors:
      0509-150 Dependent module libclntsh.a(shr.o) could not be loaded.
      0509-022 Cannot load module libclntsh.a(shr.o).
      0509-026 System error: A file or directory in the path name does not exist.

    6. Hi Jose – can you check what the $LIBPATH is pointing to. It should be $ORACLE_HOME/lib:

      Also try and run ggsci like ./ggsci to make sure you picking the right executable in case you have multiple installations.

      Let me know if this works.

    7. Process id: 4104236

      Description:

      ***********************************************************************
      ** Running with the following parameters **
      ***********************************************************************
      –CHECKPARAMS
      EXTRACT etest
      USERID ggate_ct, PASSWORD ***********

      Source Context :
      SourceModule : [ggdb.ora.sess]
      SourceID : [$Id: //depot/releases/OpenSys/v10.4.0/src/gglib/ggdbora/ocisess.c#1 $]
      SourceFunction : [OCISESS_try(int, OCISESS_context_def *, char *, …)]
      SourceLine : [466]
      Hi ,
      i am trying to start my extract but i am getting below ,please let me know if any one has come across this kind of error
      2010-09-08 11:24:44 GGS ERROR 182 OCI Error creating temporary LOB to retrieve default LOB chunk size (status = 1116-ORA-01116: error in opening database file 201
      ORA-01110: data file 201: ‘/d03/oradata/isacdev2/temp01.dbf’
      ORA-27092: size of file exceeds file size limit of the process
      Additional information: 131071
      Additional information: 256001).

      2010-09-08 11:24:44 GGS ERROR 190 PROCESS ABENDING.

    8. Hi Gavin,
      Wonderful Tutorial.
      I have two questions:
      1. Before starting Initial Load do I have to create all the table structure at the Target side?
      2. I have heard that Initial Load on big Database takes long time, then is there any alternative for initial Load.

      Thanks a lot.

      Niha

    9. thx. for broadcasting your knowledge with point to point manner and contents …
      how it possible by you?
      it is amazing working to share knowledge.

      a lot thanks.

    10. Hi Gavin,

      I was looking for an introductory start for GoldenGate. You have written an awesome series of posts. Perfect for getting a super start with GoldenGate.

      Thanks much for all the stuff.

      Keep up the good work.

      Cheers !

      Regards,
      Amardeep Sidhu

    Leave a Comment