B31679-01
Oracle TimesTen In-Memory Database Installation Guide Release
February Printed in the United States of America
Copyright 1996, 2007, Oracle. All rights reserved
1 Access Control
Contents
2 TimesTen Installation
About this Guide
iv Oracle TimesTen In-Memory Database Installation Guide
Contents
vi Oracle TimesTen In-Memory Database Installation Guide
3 Data Store Upgrades
Contents
Index
viii Oracle TimesTen In-Memory Database Installation Guide
TimesTen documentation
About this Guide
Book Titles
Description
Background reading
If you see
Conventions used in this guide
It means
4 Oracle TimesTen In-Memory Database Installation Guide
Technical Support
6 Oracle TimesTen In-Memory Database Installation Guide
Limitations of Access Control and non-root installs
Access Control
Access Control
Introduction
Cache Connect
Instance access
Replication
Client/Server
TimesTen users
TimesTen instance administrator
Instance data store
Internal user
TimesTen instance users
External user
TimesTen administrators group
Before installation
Instance registry directory
Installation directories
Installation directories, files and the daemon port
Password file
Instance home directory
Daemon port
Authenticating users and privileges
Privileges
GroupRestrict
Maintaining users and privileges
Enabling Access Control after installation on UNIX
Listing of defined users and privileges
39 and “ORACLEHOME environment variable” on page
16 Oracle TimesTen In-Memory Database Installation Guide
Platforms and configurations Installation instances
TimesTen Installation
Installation prerequisites Operating system security considerations
Prerequisites for non-root installations on UNIX systems
Building and running the demo applications
Installation problems
Viewing the online documentation
18 Oracle TimesTen In-Memory Database Installation Guide
Platform support
Platforms and configurations
20 Oracle TimesTen In-Memory Database Installation Guide
JDK support
Cache Connect to Oracle
Client/Server configurations
22 Oracle TimesTen In-Memory Database Installation Guide
Replication configurations
Instance names
Installation instances
Instance port numbers
Components available on Windows
Choosing the appropriate TimesTen components
Components available on UNIX
UNIX requirements
Installation prerequisites
HP-UX
Other Client Server Settings Replication
Semaphores
Shared
Large data stores
Linux
To see the number and size of the allocated large pages use
Semaphores Shared memory IPC Client/ Server Client/Server and Cache
Administrator
Cache Connect
30 Oracle TimesTen In-Memory Database Installation Guide
Solaris
Operating
Shared memory IPC client connections
Increase number of semaphores
Other changes Large data stores
sysconfig -q ipc
# /sbin/sysconfig -q ipc
Tru64 UNIX
Shared memory
Shared memory IPC client connections Replication
Default installation directories
Cache Connect
Operating system security considerations
36 Oracle TimesTen In-Memory Database Installation Guide
Installation prerequisites for non-root installs
Prerequisites for non-root installations on UNIX systems
Create the TimesTen instance administrators group
Create the TimesTen registry
Post-installation requirements
Changing the daemon port number on UNIX
Configure the syslog messages
UNIX libraries
Installing TimesTen
Installing TimesTen on Windows systems
See “Components available on Windows” on page
Installing TimesTen in silent mode
Verifying TimesTen Client and Server installation
Verifying installation
2. Click System DSN
2. Select TimesTen Data Manager
Working with the Data Manager Service and the Server
Uninstalling TimesTen
Installing TimesTen on Solaris systems
2. Select TimesTen Data Manager
To install TimesTen on your Solaris system, follow these steps
Installing TimesTen
In addition, setup.sh also accepts these options
32-bit default 64-bit Prompts you to Install a new instance
Working with the daemon and Server
To stop the daemon manually, use the utility command
Installing TimesTen on HP-UX systems
To start the daemon manually, use the utility command
Uninstalling TimesTen
# cd mountdir # ./setup.sh
50 Oracle TimesTen In-Memory Database Installation Guide
# mkdir /cdrom
# /etc/mount /cdrom
Installs or uninstalls TimesTen and records responses
52 Oracle TimesTen In-Memory Database Installation Guide
Working with the TimesTen daemon and Server
Use a separate instance for each memory window
Installing TimesTen on HP-UX Memory Windows
Uninstalling TimesTen
To stop the daemon manually, use the utility command
Address Space Considerations
Using TimesTen in a memory window
Troubleshooting
Installing TimesTen
Installing TimesTen on AIX systems
# crfs -v cdrfs -p ro -d cd0 -m /usr/cdrom/ TimesTen7.0
58 Oracle TimesTen In-Memory Database Installation Guide
# mount /usr/cdrom/TimesTen7.0
Installs documentation
60 Oracle TimesTen In-Memory Database Installation Guide
Uninstalling TimesTen
Working with the TimesTen daemon and server
To stop the daemon manually, use the utility command
To start the daemon manually, use the utility command
Installing TimesTen
Installing TimesTen on Linux systems
62 Oracle TimesTen In-Memory Database Installation Guide
Installs or uninstalls TimesTen and records responses
64 Oracle TimesTen In-Memory Database Installation Guide
To stop the daemon manually, use the utility command
Uninstalling TimesTen
To start the daemon manually, use the utility command
Working with the TimesTen daemon and Server
Installing TimesTen
Installing TimesTen on Tru64 UNIX systems
66 Oracle TimesTen In-Memory Database Installation Guide
In addition, setup.sh also accepts these options
68 Oracle TimesTen In-Memory Database Installation Guide
Working with the TimesTen daemon and Server
To stop the daemon manually, use the utility command
Uninstalling TimesTen
Using the Cache Administrator
To start the daemon manually, use the utility command
70 Oracle TimesTen In-Memory Database Installation Guide
Informational messages on Windows systems
Informational messages on UNIX systems
ODBC installation
Incremental install and uninstall of Cache Connect
“Shared library path environment variable” on page
Environment modifications
“ODBCINI environment
variable” on page
PATH environment variable
“Default installation
ODBCINI environment variable
“SYSODBCINI environment
SYSTTCONNECTINI environment variable
SYSODBCINI environment variable
76 Oracle TimesTen In-Memory Database Installation Guide
ORACLEHOME environment variable
CLASSPATH environment variable
Shared library path environment variable
78 Oracle TimesTen In-Memory Database Installation Guide
On HP-UX 64-bit systems, add installdir/lib to the
Web server configuration
Migrating data stores to TimesTen
Using the ttMigrate utility
C\ ”C\TimesTen\tt70\bin\ttMigrate” -r DSN=Salestt70 sales.dat
opt/tt60/32/bin/ttMigrate -c DSN=Sales600 sales.dat
C\ ”C\TimesTen\tt60\bin\ttMigrate” -c DSN=Sales600 sales.dat
Using the ttBulkCp utility
Defining data sources for the demo applications
Building and running the demo applications
Building the demo applications
Problems running the demo programs
Problems running the C demo programs on UNIX
Problems running the C demo programs on Windows
Building and running the JDBC demo applications
Viewing the online documentation
Installation problems
Data store compatibility
Data Store Upgrades
Data type compatibility
Introduction
88 Oracle TimesTen In-Memory Database Installation Guide
Data store character set
Data Store Upgrades
Data type conversion
Upgrading data types as TimesTen data types
Converting data types to Oracle data types
90 Oracle TimesTen In-Memory Database Installation Guide
Converting from the TIMESTEN8 character set
Data store character set conversion
92 Oracle TimesTen In-Memory Database Installation Guide
Converting from a character set other than TIMESTEN8
In-place upgrades
Upgrade modes
Offline upgrades
Online upgrades with Client/Server
Online upgrades with replication
94 Oracle TimesTen In-Memory Database Installation Guide
Unloading a data store
Performing an in-place data store upgrade
Moving to a new patch release of TimesTen
Performing an offline upgrade
Moving to a different machine
Moving to a different directory
On the destination system
On the source system
Reducing data store size
Moving to a different major release of TimesTen
Moving between 32-bit and 64-bit data stores
c DSN=salesdata32 -noRepUpgrade /tmp/salesbackup
1. /opt/TimesTen/giraffe32/bin/ttMigrate
ttAdmin -repStop master1
102 Oracle TimesTen In-Memory Database Installation Guide
ttMigrate -c DSN=master1 master1.bak
ttDestroy /datastorepath/master1
The data stores are now upgraded and replicating to each other
Overview
Performing an online upgrade with replication
Active System
Step Upgrade System
Connect all applications to the active
Requirements
Limitations
108 Oracle TimesTen In-Memory Database Installation Guide
Online upgrade example
ttRepAdmin -connStr DSN=active -receiver -name upgrade -state pause
ttAdmin
ttAdmin
110 Oracle TimesTen In-Memory Database Installation Guide
ttAdmin -repStop upgrade
To destroy a permanent data store Temporary=0, use ttDestroy
If the data store is temporary Temporary=1, first use ttAdmin
being replicated correctly, you can
Overview
Limitations
Client/Server online upgrade example
For this example, the hostname for the server machine is myserver
The TTCONNECTINI file at the TimesTen 5.1.x client machine contains
116 Oracle TimesTen In-Memory Database Installation Guide
Client/Server online upgrade
Client/Server online upgrade with continuous access to the data store
Record of Upgrades
118 Oracle TimesTen In-Memory Database Installation Guide
Numerics
Index
120 Oracle TimesTen In-Memory Database Installation Guide
Solaris 19, 20
122 Oracle TimesTen In-Memory Database Installation Guide
