11 Installing Oracle GoldenGate for Oracle TimesTen Databases

Learn how to install Oracle GoldenGate for Oracle TimesTen databases.

Topics:

• System Requirements and Preinstallation Instructions
  This chapter contains the requirements for the system and database resources that support Oracle GoldenGate.
• Installing for Oracle TimesTen
  

System Requirements and Preinstallation Instructions

This chapter contains the requirements for the system and database resources that support Oracle GoldenGate.

Topics:

• Supported Database Architectures
  
• Supported Platforms and Database Versions
  
• Oracle TimesTen Client Libraries Installation
  
• Client-only Instance Installation
  
• Operating System Privileges
  
• Database Requirements
  

Supported Database Architectures

Oracle GoldenGate for Oracle TimesTen supports the Classic and Scaleout architectures of the TimesTen database.

Supported Platforms and Database Versions

Oracle GoldenGate Oracle TimesTen supports installing Oracle GoldenGate on Linux.

For supported platform and database version information, review the certification matrix:

https://www.oracle.com/technetwork/middleware/ias/downloads/fusion-certification-100350.html.

Oracle TimesTen Client Libraries Installation

The Oracle TimesTen client libraries need to be installed on the server where GoldenGate is to be installed. If Oracle GoldenGate is installed on the Oracle TimesTen database server, then the required libraries are already available. However, if you are installing Oracle GoldenGate on a non-database server, then you must separately install and configure the client libraries and ODBC connection information.

For Linux platforms, the full TimesTen installation is the only available option that also provides the client libraries. To download Oracle TimesTen, visit:

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

Before beginning to install Oracle GoldenGate with Oracle TimesTen, you must also set the LD_LIBRARY_PATH variable:

1. Download theTimesTen Scaleout and TimesTen Classic/Cache 18.x for Linux x86 (64-bit) build.

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

3. Set the LD_LIBARY_PATH system variable to include the TimesTen installation’s lib directory. This system variable must be set to install and run Oracle GoldenGate. Example:

   export LD_LIBRARY_PATH=/installpath/tt18.1.2.2.0/lib:$LD_LIBRARY_PATH

Client-only Instance Installation

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]$ ./tt18.1.2.1.0/bin/ttInstanceCreate -clientonly

2. Follow the instance installation prompts, taking note of where the TimesTen instance is installed. This information will be required when setting up a Replicat’s ODBC connection to TimesTen.

3. Set the TIMESTEN_HOME system variable to the TimesTen instance path.

   Example:

   export TIMESTEN_HOME=/instancepath/tt181

Operating System Privileges

The operating system privileges for using Oracle GoldenGate for Oracle TimesTen are:

• You need read and write privileges on the Oracle GoldenGate installation directory.

• Oracle GoldenGate Replicat and Manager processes must operate as an operating system user that has privileges to read, write, and delete files and subdirectories in the Oracle GoldenGate directory. In addition, the Manager process requires privileges to control all other Oracle GoldenGate processes.

• Dedicate the Replicat and Manager operating system users to Oracle GoldenGate to avoid access to sensitive information to other users who run Oracle GoldenGate processes.

Database Requirements

This section describes the database requirements for using Oracle GoldenGate for Oracle TimesTen.

• Database User for Oracle GoldenGate Processes
  

Database User for Oracle GoldenGate Processes

Follow these requirements for the database user for Oracle GoldenGate processes:

Note:

Times Ten is only supported as a target.

• Create a database user that is dedicated to Oracle GoldenGate. It can be the same user for all of the Oracle GoldenGate processes that must connect to a database:

  • Replicat (target database)

  • DEFGEN (target database)

• To preserve the security of your data, and to monitor Oracle GoldenGate processing accurately, do not permit other users, applications, or processes to log on as, or operate as, the Oracle GoldenGate database user.

• For Oracle GoldenGate to replicate to a target Oracle TimesTen database, grant SELECT, INSERT, UPDATE, and DELETE on all the target tables to the Replicat database user.

• For creating heartbeat and checkpoint tables, grant CREATE TABLE to the Replicat database user.

Installing for Oracle TimesTen

To install Oracle GoldenGate for Oracle TimesTen on a Linux platform, follow the instructions in the section Installing for all Platforms.