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)
  • Linux prerequisites
    • Large pages (Linux)
    • Required library packages
    • Semaphores (Linux)
    • Shared memory
    • IPC Client/Server
    • Replication
    • IMDB Cache
  • Solaris prerequisites
    • File system options
    • Create a project (Solaris)
  • 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 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

• Copying, migrating and restoring a database
• Backing up and restoring a database
  • Types of backup provided
• 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 version before 7.0
  • Database character set considerations
    • Database character set specification
    • Character set restrictions when upgrading from a TimesTen version before 7.0
    • Database character set conversion
  • Location of existing database files
  • Access control
• Utilities used when upgrading TimesTen
• 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 directory
  • Moving to a different computer
  • Reducing database size
  • Moving between 32-bit and 64-bit databases
  • Moving to a different major release of TimesTen
• 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 minor 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)
  • Offline major 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

• Oracle TimesTen In-Memory Database licensing options
  • Oracle TimesTen In-Memory Database
  • Oracle In-Memory Database Cache
  • In-Memory Database Cache for Oracle Applications
  • TimesTen In-Memory Database for Exalytics

Index