Configuring the GoldenGate Hub is done in the same way you would configure GoldenGate in a stand-alone system, with the exception that only the Oracle Client pieces need be installed. Once the Oracle Client software has been installed on the GoldenGate Hub, install GoldenGate as you would normally. Point the Oracle Home location to the GoldenGate Hub and the Oracle software location for the database software that you want (11g or 12c) and create the GoldenGate home with a descriptive location.
Once you have installed the GoldenGate Home it can be accessed and used as normal.
So, let’s review the configuration. Follow these steps to configure the GoldenGate Server Hub.
- Install the Oracle Client. This can be downloaded from the Oracle eDelivery site or the Oracle Technet site. If you are supporting multiple sources download and install multiple Oracle clients (i.e. 11g, 12c).
- Install GoldenGate multiple times using multiple Oracle Homes. It is good advice to include in the name of the GoldenGate home which environment it supports.
- Prepare tnsnames.ora. Put into the tnsnames.ora file all of the systems that you will be accessing via the GoldenGate Hub.
- Set up environment. Setup and environment script to set the environment for your GoldenGate homes so that you are able to connect to the right environment. It should include the GGHOME and ORACLE_HOME environment variables and proper paths.
- Test. From ggsci connect to a database using the syntax dblogin userid @.
Once everything is setup, you are ready to start using the Oracle GoldenGate Hub.