Contents

Title and Copyright Information

Preface

• Related documents
• Conventions
• Documentation Accessibility

What's New

• New features in Release 11.2.1.9.5
• New features in Release 11.2.1.0.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
    • File system options
    • Semaphores
    • Java
    • Other Client/Server settings
  • AIX prerequisites
    • Large pages
    • Asynchronous I/O
  • HP-UX prerequisites
    • Semaphores
    • Shared memory
    • Large databases
    • Replication
  • Linux prerequisites
    • Large pages
    • Semaphores
    • Shared memory
    • IPC Client/Server
    • Replication
    • IMDB Cache
  • Solaris prerequisites
    • File system options
    • IPC semaphores
    • Increase number of semaphores
    • Shared memory IPC client connections
    • Other changes
    • Large databases
    • Replication
  • 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 pre-requisites 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
• TimesTen on HP-UX Memory Windows
  • Installing TimesTen on HP-UX Memory Windows
  • Using TimesTen in a memory window
  • Address space considerations
  • HP-UX Memory Windows Troubleshooting
• Installation problems

2 Database 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
  • In-place upgrades
  • Offline upgrades
  • Online upgrades with replication
  • Online upgrades with Client/Server
• Performing an in-place database upgrade
  • Unloading a database
  • Moving to a new patch release of TimesTen
• 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 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
• Record of upgrades

Index