Install Oracle TimesTen In-Memory Database 11g (11.2.1.6.1) 32bit on Windows

Oracle TimesTen In-Memory Database is a memory resident relational database management system that allows applications to access capture or modify information faster than traditional database products.

This document will detail the installation steps for Oracle TimesTen In-Memory Database on Windows systems.

Windows Requirements

Visual Studio 2003, 2005 or 2008 needs to be install prior to TimesTen if you intend to use the TimesTen debug libraries.

If the install is on Vista, Windows 7 or Windows 2008 the install needs to be performed by either the local administrator or by a user who is a member of the Administrator group and uses “Run as administrator” to perform the setup.

Downloading and Installing TimesTen

TimesTen can be downloaded from the Oracle Technology Network (OTN) in the TimesTen section of the Database Downloads. Once you uncompress the file double click setup.exe to start the installation.

Click the Next button to continue.

The default location is C:\TimesTen\tt1121_32. You can browse to another location if needed. Once you have provided the installation location click the OK button to continue.

For this install we are going to install all of the components with the exception of the TimeTen Data Manager Debug Libraries.

After selecting the option to install click the Next button to continue.

The installation process will create a Demo data store. By default its location is set to the installation user’s Application Data directory. You can change this location using the Browse button.

Once you have set the location click the Next button to continue.

Next we set the TNS_ADMIN location. The TNS_ADMIN is required when using TimeTen In-Memory Database Cache for Oracle Databases. You can leave this blank for now and set it later using the ttModInstall utility.

After setting the location click the Next button to continue.

Select the location in which to create shortcuts for the TimesTen utilities. Click the Next button to continue.

By default TimesTen databases and shared memory can only be read and written to by members of the TimesTen installation (Administrators group) group. This can be changed to allow anyone that is logged into the host machine but it is not recommended. Click the Next button continue.

PL/SQL can be enabled during the install (default). Enabling PL/SQL can be deferred until after install if needed by using the ttModInstall utility. Click the Next button to continue.

The following environment variables will be altered if you choose to allow the installer to modify the environment variables: CLASSPATH, LIB, INCLUDE and PATH. NOTE: TimesTen does include the Oracle Instant Client and allowing the installer to modify the PATH environment variable can be a source of problems if you have the either Oracle Database or Oracle Client software installed as the instant client for TimesTen will be first in the PATH.

Click the Next button to continue.

Oracle TimesTen 11g includes JDBC drivers for JDK 5 and 6. You have the option to add one of the versions to the CLASSPATH environment variable.

Click the Next button to continue.

You can review the installation options prior to installing TimesTen. If you find that you need to make changes click the Back button to go back the configuration page in which you need to change. Click the Next button to continue.

An installation progress screen will appear next detailing the installation of the selection components.

Once the install is complete you can have the installer launch the Quick Start guide and or display the release notes. Click the Finish button to complete the install and exit the installer.

Verify the installation

Once the install is complete you should have a TimesTen Data Manager 11.2.1 service and it should be running.

On the command line you can use the ttstatus utility to verify the status of the Data Manager.

In the ODBC Data Source Administrator you should find both a TimesTen Client 11.2.1 and Data Manager Driver.