1. Microservices Architecture Documentation
  2. Install and Patch
  3. Prerequisites for Installing Oracle GoldenGate for TimesTen

Prerequisites for Installing Oracle GoldenGate for TimesTen

Learn the prerequisites for installing Oracle GoldenGate for a TimesTen database.

To create an Oracle GoldenGate for Oracle TimesTen deployment requires installing the Oracle TimesTen Client on the server where Oracle GoldenGate is to be installed. If Oracle GoldenGate is installed on the Oracle TimesTen database server, then the required client components are already available. However, if you are installing Oracle GoldenGate on a hub server, then you must separately install the Oracle TimesTen Client.

Oracle TimesTen Software Installation

Download the Oracle TimesTen software from the following site, choosing a version and operating system platform of the software based on the platform where Oracle GoldenGate is to be installed, and the version of the Oracle TimesTen database.

https://www.oracle.com/database/technologies/timesten-downloads.html

For a list of supported Oracle GoldenGate platforms and supported versions of the Oracle TimesTen database, review the Certification Matrix for this release of Oracle GoldenGate.

  1. Download the In-Memory database for a supported version of the database.

  2. Extract the Oracle TimesTen installation files to a designated location, based on the instructions provided in Oracle TimesTen In-Memory Database Installation Guide.

  3. Follow the installation instructions provided by the TimesTen documentation for complete installation details.

Client-only Instance Creation

For non-database server environments where you plan to install Oracle GoldenGate, after installing the Oracle TimesTen client libraries, follow the TimesTen document instructions to create a client-only instance of TimesTen.

  1. Perform the following:

    [oracle@tt_installation_dir]$ ./bin/ttInstanceCreate -clientonly

  2. Follow the instance installation prompts, taking note of the instance name and the instance installation location. This information will be required when setting up a Replicat’s ODBC connection to Oracle TimesTen.

Setting the Environment Variables

Ensure that the required system environment variables are sourced before installing Oracle GoldenGate for TimesTen. The correct environment settings are needed for all sessions or processes that will interact with Oracle TimesTen. Every Oracle TimesTen instance (server and client) contains a script for setting the required environment variables. This script is located in the tt_instance_home/bin and is named ttenv.[c]sh. It should always be dotted or sourced and never executed directly.

Example of setting the bash shell environment for a TimesTen instance located in /home/oracle/tt221: 

source /home/oracle/tt221/bin/ttenv.sh

Although it is possible to set the required environment variables manually, it is not recommended.