3 Installation and Management of TimesTen on Windows

This chapter discusses how to install a TimesTen client on Windows. Review Chapter 1, "Overview of the Installation Process in TimesTen Classic" before beginning the installation.

Topics include:

Overview of the installation process on Windows

The TimesTen installer on Windows creates a single TimesTen client-only installation (and instance). No additional installations (or instances) can be created without first uninstalling the existing one.

Once installed, a Windows host can be used as a TimesTen client that connects to either a database in TimesTen Scaleout or a database in TimesTen Classic.

A Windows host cannot have multiple installations from the same TimesTen major release, such as 18.1. For example, it cannot have both a 18.1.3.x and a 18.1.4.x installation. But it can have TimesTen installations from different major releases, such as an installation and a 18.1.x installation.

You cannot modify the installation or the instance.


TimesTen does not support copying a Windows installation or sharing a Windows installation between hosts. TimesTen must be installed separately on each host.

Creating an installation on Windows

You can install TimesTen in any directory where the user performing the installation has sufficient permission. The user who installs TimesTen must be a member of the TimesTen users group, and the TimesTen files and the directories must be accessible to only members of that group. Installing TimesTen requires Administrator privileges.

Information about the TimesTen installation is contained in the Windows operating system registry.

Do not install TimesTen for Windows on a mapped network drive.

The default top-level directory of the installation is C:\TimesTen\tt181_64. The instance name is simply instance.

These sections describe how to create the installation and then verify it.

After you create and verify the installation, you can connect to the server from the Windows client and set up your DSN. See "Working with the TimesTen Client and Server" in the Oracle TimesTen In-Memory Database Operations Guide for details.

Create an installation on Windows

The procedure for the installation is:

  1. Download the appropriate TimesTen client distribution ZIP file. For example, download timesten.181410.win64.zip.

  2. Extract the contents of the file.

  3. From the Win64 directory, run the setup.exe executable (the TimesTen installer).

  4. In the initial TimesTen Setup dialog, choose Next.

  5. In the Choose Installation Folder dialog, select or specify the desired folder. The default is C:\TimesTen\tt181_64. Then choose OK.

  6. In the Select Program Folder dialog, select or specify the desired folder. The default is TimesTen 18.1 (64-bit). Then choose Next.

  7. In the TimesTen Configuration Options dialog, there is a check mark in the check box for Register TimesTen environment variables. If you choose to register the TimesTen environment variables, leave this box checked. Then choose Next.


    • Settings made by registering environment variables are reflected in the System control panel and persist across sessions. It is advisable to reboot the system after the installation to ensure that Windows re-reads the registry and propagates the environment settings.

    • If you do not register environment variables during installation, you can run ttenv.bat from the TimesTen bin directory (in a DOS window) for each session. This sets PATH, CLASSPATH, and TIMESTEN_HOME (but not LIB and INCLUDE).

    • Registering environment variables is not advisable if you are installing multiple releases of TimesTen, in which case the path could cause unexpected behavior. Multiple installations must be from different major releases, such as 11.2.2.w.x and 18.1.y.z.

  8. In the "Select which version of Java to add to the CLASSPATH " dialog, select one of the options: JDK 8, JDK 9, JDK 10, JDK 11, or None. Then choose Next.

  9. In the Installation Information dialog, confirm settings. Choose Back to make changes. Otherwise, choose Next.

    The Setup Status dialog displays with a message indicating your new installation is being configured.

    Additional dialogs and windows display, indicating that timesten.conf is updated and TimesTen is configured.

  10. In the InstallShield Wizard Complete dialog, choose Finish (optionally choosing to display the TimesTen release notes).

Verify the installation on Windows

Verifying the installation on Windows includes:

Verify proper installation on Windows

To verify that the TimesTen client has been properly installed:

  1. Confirm that the TimesTen 18.1 shortcut (for example, "TimesTen 18.1 (64-bit)") appears under Apps & features (or the equivalent).

  2. From Administrative Tools, select ODBC Data Sources (64-bit). This opens the ODBC Data Source Administrator (64-bit) menu. Choose the Drivers tab.

  3. Confirm that the TimesTen Client 18.1 driver is installed. Click OK.

Review the installation directories on Windows

This is a sample directory structure after a successful installation. Not all directories are included in this sample.

      bin [contains TimesTen utilities and executables]
      doc [contains Help files only]
      include [contains TimesTen include files]
         bin                [link to tt181_64\bin]
         install            [link to tt181_64]
            utl_file_temp   [for PL/SQL UTL_FILE package]

Review the timesten.conf file on Windows

You may also review the timesten.conf file located in the instance\conf directory of the installation folder (for example, C:\TimesTen\tt181_64\instance\conf). The daemon_port value and the server_port value can be ignored. The hostname indicates the host name on which you performed the installation.

# TimesTen Instance Configuration File
# Commented values are default values
# By default, turn verbose logging on

Deleting an installation on Windows

This section discusses the steps to delete the installation and also the steps to verify the uninstallation was successful:

Steps to delete the installation on Windows

Uninstall TimesTen on Windows through the Apps & features menu list, much as you would other Windows programs.


Uninstallation will delete the TimesTen installation as well as the TimesTen instance that was created as part of the installation.
  1. From the Apps & features menu list, locate Oracle TimesTen In-Memory Database 18.1 (64-bit).

  2. Choose Uninstall.

  3. The "This app and its related info will be uninstalled" dialog displays. Choose Uninstall.

  4. In the Question dialog, the "Are you sure you want to uninstall TimesTen In-Memory Database Client 18.1?" question displays. Choose Yes.

  5. In the Confirm Uninstall dialog, the "Do you want to completely remove the selected application and all its features?" question displays. Choose OK.

  6. In the Question dialog, the "Would you like to delete all DSNs associated with TimesTen 18.1?" question displays. If you choose Yes, you will not be able to access your existing databases. Choose Yes or No.


    The uninistallation process begins. Even for uninstallation, there is a dialog that says, "Configuring your new software installation."
  7. The Maintenance Complete dialog displays indicating the uninstallation is complete. Choose Finish.

Verify the uninstallation is successful on Windows

To verify that uninstallation was successful, confirm that:

  1. TimesTen 18.1 has been removed from Apps & features.

  2. The TimesTen Client 18.1 driver is not listed in the Drivers tab in the ODBC Data Source Administrator.

  3. The installation directory has been deleted (by default, C:\TimesTen\tt181_64). If not, delete it and any remaining contents manually.

    If this is the only TimesTen installation, you can delete the TimesTen directory. If there are other installations (such as an 11.2.2 installation), then delete only the tt181_64 directory.


    If any files are open to Windows Explorer, you may have to use the Task Manager to end the explorer process before you can delete the installation directory and its contents.