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
    • Java
    • Other Client/Server settings
  • AIX prerequisites
    • Large pages
    • Asynchronous I/O
  • Linux prerequisites
    • Large pages
    • Required Library Packages
    • Semaphores
    • Shared memory
    • IPC Client/Server
    • Replication
    • IMDB Cache
  • Solaris prerequisites
    • File system options
    • Create a project
  • 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 TimesTen users groups
  • Directory and file permissions
    • Permissions and instance registry prerequisites for TimesTen
  • Creating UNIX TimesTen administrator and users groups
    • Create the TimesTen users group
    • Create the TimesTen instance registry and administrators group
• Installing TimesTen on UNIX systems
  • Installing TimesTen
  • Working with the TimesTen daemon and server on UNIX systems
  • 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
  • Working with the Data Manager Service and the Server on Windows
  • 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
  • PATH environment variable
  • ODBCINI environment variable
  • SYSODBCINI environment variable
  • SYSTTCONNECTINI environment variable
  • TNS_ADMIN environment variable
  • Shared library path environment variable
  • Java environment variables
    • Set the CLASSPATH variable
    • Set the shared library path variable
    • Set the THREADS_FLAG variable (UNIX only)
    • Set the PATH variable
• TimesTen Quick Start
• Viewing the online documentation
• Installation problems
• Licensing Information

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

• Introduction
  • Database compatibility
  • Data type compatibility
  • Database character set
• Utilities used when upgrading TimesTen databases
• Access control
• Data type conversion
  • Converting data types to Oracle data types
  • Upgrading data types as TimesTen data types
• Database character set conversion
  • Converting from the TIMESTEN8 character set
  • Converting from a character set other than TIMESTEN8
• Upgrade modes
  • Patch releases
  • 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
  • Overview
  • Limitations
  • Requirements
  • Online upgrade example
• Performing an online upgrade with active standby pair replication
  • Upgrading the databases in an active standby pair with no cache groups
    • Upgrades for TimesTen patch releases on the standby master database and subscriber databases
    • Upgrades for TimesTen patch releases on the active master database
    • Upgrades for major TimesTen releases, application software and hardware
  • Upgrading the databases in an active standby pair with cache groups
    • Upgrades for TimesTen patch releases on the standby master database and subscriber databases
    • Upgrades for TimesTen patch releases on the active master database
    • Upgrades for major TimesTen releases, application software and hardware
• 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 of 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
  • Upgrade multiple active standby pairs on many pairs of hosts
  • Upgrade multiple active standby pairs on a pair of hosts
    • Sample configuration files: multiple active standby pairs on the same pair of hosts
    • Sample scripts: stopping and starting multiple standby processes on one host
  • Sample in-place upgrade
• Performing an upgrade when using parallel replication
  • Parallel replication with an active standby pair
  • Scenarios that require an offline upgrade
  • Considerations regarding parallel replication
• Record of upgrades with replication configured
• Performing a Client/Server online upgrade from TimesTen release 6.0 and above
  • Client/Server online upgrade
  • Client/Server online upgrade with continuous access to the database

Index