Contents

Title and Copyright Information

Preface

• Audience
• Related documents
• Conventions
• Documentation Accessibility

What's New

• New features in Release 18.1.3.1.0
• New features in Release 18.1.2.1.0

1 Overview of the Installation Process in TimesTen Classic

• Overview of installations and instances
  • Distribution media and the distribution
  • Instance administrator
  • TimesTen installations
    • Installations on Linux or UNIX
    • Installations on macOS
    • Installations on Windows
  • TimesTen instances
  • Instance home
  • Instance configuration file (timesten.conf)
• Understanding the TimesTen users group
• Installation and instance management on Linux, UNIX or macOS
  • Installation creation on Linux, UNIX, or macOS
  • Installation deletion on Linux, UNIX, or macOS
  • Installation copying on Linux or UNIX
  • Instance creation on Linux, UNIX, or macOS
  • Instance modification on Linux, UNIX, or macOS
  • Upgrading or downgrading the instance on Linux, UNIX, or macOS
  • Instance removal on Linux, UNIX, or macOS
• Installation and instance management on Windows
  • Installation and instance creation on Windows
  • One installation on Windows
  • Installation and instance deletion on Windows
• Operating system prerequisites
  • Linux prerequisites
    • Create the TimesTen users group
    • Configure shmmax and shmall
    • Configure HugePages
    • Modify the memlock settings
    • Set the semaphore values
  • AIX prerequisites
  • Solaris prerequisites
    • File system options (Solaris)
    • Create a project (Solaris)
• Planning the installation and its deployment
  • Locations of database files and user files
  • Locations of the databases and the applications
• Environment variables
  • Setting environment variables for TimesTen
  • Environment variable descriptions
    • TIMESTEN_HOME environment variable
    • NLS_LANG environment variable
    • Shared library path environment variable
    • PATH environment variable
    • Temporary directory environment variable
    • TNS_ADMIN environment variable
    • Java environment variables
    • SYSODBCINI environment variable
    • ODBCINI environment variable
    • SYSTTCONNECTINI environment variable

2 Installation of TimesTen Classic on Linux or UNIX

• Creating an installation on Linux/UNIX
  • Create an installation accessible by the instance administrator's primary group
  • Create an installation accessible by the instance administrator's secondary group
  • Create an installation accessible by only the instance administrator
  • Verify an installation on Linux/UNIX
    • The ttInstallationCheck utility
    • The installation directory and subdirectories
• Creating an instance on Linux/UNIX: Basics
  • The ttInstanceCreate utility
  • Create a TimesTen full instance
  • Create a TimesTen client instance
  • Review the instance home directory and subdirectories
• Creating an instance on Linux/UNIX: Additional features
  • Create an instance by specifying options on the command line
  • Create an instance interactively with the -record option
  • Create an instance from information provided in a batch file
  • Create an instance interactively for Oracle Clusterware
  • Start an instance automatically at system startup
• Modifying an instance on Linux/UNIX
  • The ttInstanceModify utility
  • Modify an instance from information provided interactively
  • Change the daemon port for an instance
  • Set or change the path to tnsnames.ora for an instance
  • Change the Oracle Clusterware configuration for an instance
  • Associate an instance with a different installation (upgrade or downgrade)
• Destroying an instance on Linux/UNIX
  • The ttInstanceDestroy utility
  • Destroy an instance from information provided interactively
• Copying an installation on Linux/UNIX
• Deleting an installation on Linux/UNIX
  • Uninstall TimesTen
• Complete example for installing and uninstalling TimesTen Classic
  • Create the full installation
  • Create the full instance
  • Source the environment variables
  • Run the ttStatus utility
  • Create and connect to the database
  • Run ttStatus to show connections
  • Modify the full instance
  • Destroy the full instance
  • Delete the installation
• Installing Oracle Clusterware for use with TimesTen

3 Installation and Management of TimesTen on Windows

• Overview of the installation process on Windows
• Creating an installation on Windows
  • Create an installation on Windows
  • Verify the installation on Windows
    • Verify proper installation on Windows
    • Review the installation directories on Windows
    • Review the timesten.conf file on Windows
• Deleting an installation on Windows
  • Steps to delete the installation on Windows
  • Verify the uninstallation is successful on Windows

4 Client-only Installations and Instances

• Creating a TimesTen client installation
  • Create a client-only installation
  • Verify a client installation
• Creating a TimesTen client instance
  • Overview of the ttInstanceCreate utility
  • Examples creating TimesTen client instances
  • Review the instance home directory and subdirectories
  • Review the timesten.conf file
• Modifying a TimesTen client instance
• Destroying a TimesTen client instance
• Deleting a TimesTen client installation

5 Backup, Restore, and Migrate Data in TimesTen Classic

• Backing up and restoring a database
  • Backup features
  • Types of backups
  • Restoring a database
  • Backup and restore examples
    • Performing a simple backup and restore
    • Moving a database to a different directory
    • Moving a database to a different host (same platform)
• Migrating a database
  • Moving to a different major release of TimesTen Classic
  • Moving a database to a different platform

6 Upgrades in TimesTen Classic

• Overview of release numbers
• Types of upgrades
• Offline upgrade: Moving to a different patch or patch set: ttInstanceModify
  • Unloading a database from memory
  • Reloading a database into memory
• Offline upgrade: Moving to a different patch or patch set: ttBackup
• Offline upgrade: Moving to a different major release
• Online upgrade: Using TimesTen replication
• Performing an online upgrade with classic replication
  • Requirements
  • Upgrade steps
  • Online upgrade example
• Performing an upgrade with active standby pair replication
  • Online upgrades for an active standby pair with no cache groups
    • Online patch upgrade for standby master and subscriber
    • Online patch upgrade for active master
    • Online major upgrade for active standby pair
  • Online upgrades for an active standby pair with cache groups
    • Online patch upgrade for standby master and subscriber (cache groups)
    • Online patch upgrade for active master (cache groups)
    • Online major upgrade for active standby pair (read-only cache groups)
  • Offline upgrades for an active standby pair with cache groups
    • Offline major upgrade for active standby pair (cache groups)
• Performing an offline TimesTen upgrade when using Oracle Clusterware
• Performing an online TimesTen upgrade when using Oracle Clusterware
  • Supported configurations
  • Restrictions and assumptions
  • Upgrade tasks for one active standby pair
    • Verify that the active standby pair is operating properly
    • Shut down the standby database
    • Perform an upgrade for the standby database
    • Start the standby database
    • Switch the roles of the active and standby databases
    • Shut down the new standby database
    • Perform an upgrade of the new standby database
    • Start the new standby database
  • Upgrades for multiple active standby pairs on many pairs of hosts
  • Upgrades for multiple active standby pairs on a pair of hosts
    • Sample configuration files: multiple active standby pairs on one pair of hosts
    • Sample scripts: stopping and starting multiple standby processes on one host
• Upgrades when using parallel replication
  • Considerations regarding parallel replication
  • Scenarios that require an offline upgrade
• Performing an upgrade of your client instance

Index