Install Oracle TimesTen Classic on Linux

Introduction

This tutorial walks you through the steps to install the TimesTen 22.1.1.5.0 release on a Linux x86-64 system.

Objectives

Prerequisites

Task 1: Download and Create the Installation

The TimesTen product is packaged into distribution media that you download. A distribution consists of a single ZIP file. For this tutorial, the name of the ZIP file is timesten221150.server.linux8664.zip. When you unpack the timesten221150.server.linux8664.zip file, TimesTen creates the installation.

  1. From a directory of your choice, create the installation directory.

    mkdir -p installation_dir

    You download the TimesTen distribution into this directory.

  2. Download Oracle TimesTen to the installation_dir directory.

    This tutorial downloads Oracle TimesTen In-Memory Database Release 22.1.1.5.0 for (Linux x86-64).

  3. Create the installation.

    unzip ./installation_dir/timesten221150.server.linux8664.zip -d ./installation_dir

    The output is similar to the following:

    Archive:  ./installation_dir/timesten221150.server.linux8664.zip
   creating: ./installation_dir/tt22.1.1.5.0/
...
  ./installation_dir/tt22.1.1.5.0/bin/ttinstancecreate -> ttInstanceCreate
  ./installation_dir/tt22.1.1.5.0/bin/ttversion -> ttVersion
  ./installation_dir/tt22.1.1.5.0/bin/ttinstallationcheck -> ttInstallationCheck
  ./installation_dir/tt22.1.1.5.0/bin/ttgridadmin -> ttGridAdmin
  ./installation_dir/tt22.1.1.5.0/bin/ttcapture -> ttCapture
  ./installation_dir/tt22.1.1.5.0/PERL/perl -> bin/perl

    TimesTen creates the installation in the ./installation_dir/tt22.1.1.5.0 directory.

Task 2: Verify the Installation

Use the TimesTen ttInstallationCheck utility to verify the installation.

./installation_dir/tt22.1.1.5.0/bin/ttInstallationCheck

The ttInstallationCheck utility is located in the bin area of the installation.

If the installation is successful, the output is the following:

This installation has been verified.

Task 3: Create the TimesTen Instance

A TimesTen instance consists of the TimesTen processes and files that together let you create and manage TimesTen databases. You create a TimesTen instance by using the TimesTen ttInstanceCreate utility located in the bin area of the installation.

  1. From a directory of your choice, create the directory for the TimesTen instance.

    mkdir -p instance_dir

    This directory serves as the top level directory for the instance and is referred to as the instance home directory. Ensure to create this directory before creating the instance.

  2. Create the TimesTen instance.

    ./installation_dir/tt22.1.1.5.0/bin/ttInstanceCreate -name instance1 -location ./instance_dir

    Note the following:

    • The name of the instance is instance1. You can choose any name.
    • The location of the instance is ./instance_dir.

    The output is the following:

    Creating instance in /your_directory/instance_dir/instance1 ...

: The TimesTen daemon startup/shutdown scripts have not been installed.

The startup script is located here :
       '/your_directory/instance_dir/instance1/startup/tt_instance1'

Run the 'setuproot' script :
        /your_directory/instance_dir/instance1/bin/setuproot -install
This will move the TimesTen startup script into its appropriate location.

The 22.1 Release Notes are located here :
  '/your_directory/installation_dir/tt22.1.1.5.0/README.html'

Instance created successfully.

    The your_directory directory is the directory from which you created the installation_dir and instance_dir directories.

    Note: Running the TimesTen setuproot startup script is optional. This tutorial doesn’t require you to run this script.

Task 4: Source the Environment Variables

TimesTen requires you to set specific environment variables after you create the TimesTen instance. These environment variables include TIMESTEN_HOME,PATH, and LD_LIBRARY_PATH. On Linux, you set the environment variables by sourcing the ttenv.sh (for a Bourne or Bourne-compatible shell) or ttenv.csh (for a C shell).

From the /bin area of the instance directory, source the environment variables.

source ./instance_dir/instance1/bin/ttenv.sh

Note: This example sources the environment variables for a Bourne shell. To source for a C shell, replace ttenv.sh with ttenv.csh.

The output is similar to the following:

LD_LIBRARY_PATH set to /your_directory/instance_dir/instance1/install/lib:/your_directory/instance_dir/instance1/install/ttoracle_home/instantclient:/usr/lib

PATH set to /your_directory/instance_dir/instance1/bin:/your_directory/instance_dir/instance1/install/bin:/your_directory/instance_dir/instance1/install/ttoracle_home/instantclient:/...:.
			   
CLASSPATH set to /your_directory/instance_dir/instance1/install/lib/ttjdbc8.jar:/your_directory/instance_dir/instance1/install/lib/orai18n.jar:/...:.

TNS_ADMIN set to

TIMESTEN_HOME set to /your_directory/instance_dir/instance1

The your_directory directory is the directory from which you created the installation_dir and instance_dir directories.

Task 5: Verify the TimesTen Instance

Use these utilities to verify the TimesTen instance:

  1. Verify the release information by using the TimesTen ttVersion utility.

    ttVersion

    The output is the following:

    TimesTen Release 22.1.1.5.0 (64 bit Linux/x86_64) (instance1:6624) 2022-07-17T07:59:24Z
  Instance admin: instanceadmin
  Instance home directory: /your_directory/instance_dir/instance1
  Group owner: g900
  Daemon home directory: /your_directory/instance_dir/instance1/info
  PL/SQL enabled.

  2. Verify the status of the TimesTen instance by using the TimesTen ttStatus utility.

    ttStatus

    The output is the following:

    TimesTen status report as of Mon Aug 29 20:52:19 2022

Daemon pid 383308 port 6624 instance instance1
TimesTen server pid 383315 started on port 6625
------------------------------------------------------------------------
------------------------------------------------------------------------
Accessible by group g900
End of report

    The output shows the following:

    • The TimesTen daemon is started and runs on the default 6624 port number.
    • The name of the TimesTen instance is instance1.
    • The TimesTen Server listens on the default 6625 port number.

    Note: If you receive an error that the TimesTen daemon is not running, start it and run ttStatus again. For example, first run ttDaemonAdmin -start. Next, run ttStatus.

Congratulations! You successfully installed TimesTen Classic on Linux. You are now ready to configure Linux for TimesTen.

More Learning Resources

Explore other labs on docs.oracle.com/learn or access more free learning content on the Oracle Learning YouTube channel. Additionally, visit education.oracle.com/learning-explorer to become an Oracle Learning Explorer.

For product documentation, visit Oracle Help Center.