Contents

Title and Copyright Information

Preface

• Related documents
• Conventions
• Documentation Accessibility

What's New

• New features in Release 11.2.2.3.0
• New features in Release 11.2.2.1.0

1 TimesTen Installation

• Installation instances
  • Instance naming
  • Instance port numbers
• Choosing the appropriate TimesTen components
  • Components available on UNIX
  • Components available on Windows
• Installation prerequisites
  • General UNIX requirements
    • Veritas file system options
    • Semaphores (general UNIX)
    • Java
  • AIX prerequisites
    • Large pages (AIX)
  • HP-UX prerequisites
    • Semaphores (HP-UX)
    • Shared memory (HP-UX)
    • Large databases (HP-UX)
    • Replication (HP-UX)
  • Linux prerequisites
    • Shared memory (Linux)
    • Large pages (Linux)
    • Semaphores (Linux)
    • IPC Client/Server (Linux)
    • Required library packages (Monta Vista)
  • Solaris prerequisites
    • File system options
    • Create a project (Solaris)
  • Windows requirements
    • Large pages: grant lock pages in memory (Windows)
    • Additional Windows requirements
• Default installation directories
• Considerations for locations of database files and other user files
• Pre-Install requirements for operating system group and file permissions
  • TimesTen instance administrators and users groups
  • Directory and file permissions
    • Permissions and instance registry prerequisites for TimesTen
  • Creating UNIX TimesTen instance administrators and users groups
    • Create the TimesTen users group
    • Create the TimesTen instance registry and instance administrators group
• Installing TimesTen on UNIX systems
  • Installing TimesTen
  • Informational messages on UNIX systems
  • Changing the daemon port number on UNIX
  • Uninstalling TimesTen on UNIX systems
• Installing TimesTen on Windows systems
  • Installing TimesTen
  • Installing TimesTen in silent mode
  • Verifying installation
  • Verifying TimesTen Client and Server installation
  • Informational messages on Windows systems
  • Uninstalling TimesTen on Windows systems
• Installing TimesTen Client on Mac OS X systems
  • Installing TimesTen Client
  • Uninstalling TimesTen Client on Mac OS X systems
• Installing TimesTen on Exalogic systems
  • Installing Oracle Clusterware for use with TimesTen
• ODBC installation
• Environment variables
  • Setting environment variables for TimesTen
  • Environment variable descriptions
    • PATH environment variable
    • ODBCINI environment variable
    • SYSODBCINI environment variable
    • SYSTTCONNECTINI environment variable
    • TNS_ADMIN environment variable
    • Shared library path environment variable
    • Java environment variables
• TimesTen Quick Start
• Documentation installation
• Installation problems

2 Migration, Backup, and Restoration

• Overview: copying, migrating, and restoring a database
• Backing up and restoring a database
  • TimesTen backup features
  • Types of backup provided
• Migrating a database
  • Moving a database to a different computer (same platform)
  • Moving a database to a different platform
• Altering a database
  • Moving a database to a different directory
  • Reducing database size
• Globalization support during migration
  • Object migration and character sets
  • Migration and length semantics
  • Migrating linguistic indexes
  • Migrating cache group tables

3 TimesTen Upgrades

• Preliminary considerations
  • Data type considerations
    • Data type compatibility
    • Data type considerations when upgrading from a TimesTen release before 7.0
  • Database character set considerations
    • Database character set specification
    • Character set restrictions when upgrading from a TimesTen release before 7.0
    • Database character set conversion
  • Location of existing database files
  • Access control when upgrading from releases prior to 11.2.1
  • Replication considerations
• Upgrade modes
  • In-place upgrades
  • Offline upgrades
  • Online upgrades with replication
  • Online upgrades with Client/Server
• Performing an in-place upgrade
  • Unloading a database from memory
  • Performing the upgrade
  • Reloading a database into memory
• Performing an offline upgrade
  • Moving to a different major release of TimesTen
  • Moving to a different minor or patch release of TimesTen (offline upgrade)
• Performing an online upgrade with replication
  • Procedural overview
  • Limitations
  • 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 minor upgrade for standby master and subscriber
    • Online minor upgrade for active master
    • Online major upgrade for active standby pair
  • Online upgrades for an active standby pair with cache groups
    • Online minor upgrade for standby master and subscriber (cache groups)
    • Online minor 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 in-place 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 in-place 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
  • Sample in-place upgrade
• Upgrades when using parallel replication
  • Considerations regarding parallel replication
  • Scenarios that require an offline upgrade
• Record of upgrades with replication configured
• Performing a Client/Server online upgrade
  • Client/Server online upgrade
  • Client/Server online upgrade with continuous access to the database

A Oracle TimesTen In-Memory Database License Information

• Licensing Options
  • Oracle TimesTen In-Memory Database
  • Oracle TimesTen Application-Tier Database Cache
  • Oracle TimesTen Application-Tier Database Cache for Oracle Applications
  • Oracle TimesTen In-Memory Database for Exalytics
• Oracle TimesTen Product Components
  • TimesTen Base Functionality
  • TimesTen In-Memory Analytics
  • TimesTen Replication
  • TimesTen Caching from Oracle Database

Index