Oracle TimesTen In-Memory Database Installation Guide Release
B31679-01
Copyright 1996, 2007, Oracle. All rights reserved
February Printed in the United States of America
Contents
1 Access Control
2 TimesTen Installation
About this Guide
iv Oracle TimesTen In-Memory Database Installation Guide
Contents
3 Data Store Upgrades
vi Oracle TimesTen In-Memory Database Installation Guide
Index
Contents
viii Oracle TimesTen In-Memory Database Installation Guide
About this Guide
TimesTen documentation
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
Access Control
Limitations of Access Control and non-root installs
Access Control
Introduction
Instance access
Cache Connect
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, files and the daemon port
Installation directories
Password file
Instance home directory
Authenticating users and privileges
Daemon port
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
TimesTen Installation
Platforms and configurations Installation instances
Installation prerequisites Operating system security considerations
Prerequisites for non-root installations on UNIX systems
Installation problems
Building and running the demo applications
Viewing the online documentation
18 Oracle TimesTen In-Memory Database Installation Guide
Platforms and configurations
Platform support
JDK support
20 Oracle TimesTen In-Memory Database Installation Guide
Client/Server configurations
Cache Connect to Oracle
Replication configurations
22 Oracle TimesTen In-Memory Database Installation Guide
Instance names
Installation instances
Instance port numbers
Components available on Windows
Choosing the appropriate TimesTen components
Components available on UNIX
Installation prerequisites
UNIX requirements
Other Client Server Settings Replication
HP-UX
Semaphores
Shared
Linux
Large data stores
To see the number and size of the allocated large pages use
Administrator
Semaphores Shared memory IPC Client/ Server Client/Server and Cache
30 Oracle TimesTen In-Memory Database Installation Guide
Cache Connect
Solaris
Operating
Increase number of semaphores
Shared memory IPC client connections
Other changes Large data stores
# /sbin/sysconfig -q ipc
sysconfig -q ipc
Tru64 UNIX
Shared memory
Default installation directories
Shared memory IPC client connections Replication
Operating system security considerations
Cache Connect
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
Post-installation requirements
Create the TimesTen registry
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
Working with the Data Manager Service and the Server
2. Select TimesTen Data Manager
Uninstalling TimesTen
Installing TimesTen on Solaris systems
2. Select TimesTen Data Manager
Installing TimesTen
To install TimesTen on your Solaris system, follow these steps
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
Installing TimesTen on HP-UX systems
To stop the daemon manually, use the utility command
To start the daemon manually, use the utility command
Uninstalling TimesTen
50 Oracle TimesTen In-Memory Database Installation Guide
# cd mountdir # ./setup.sh
# 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
Installing TimesTen on HP-UX Memory Windows
Use a separate instance for each memory window
Uninstalling TimesTen
To stop the daemon manually, use the utility command
Using TimesTen in a memory window
Address Space Considerations
Troubleshooting
Installing TimesTen
Installing TimesTen on AIX systems
# crfs -v cdrfs -p ro -d cd0 -m /usr/cdrom/ TimesTen7.0
# mount /usr/cdrom/TimesTen7.0
58 Oracle TimesTen In-Memory Database Installation Guide
Installs documentation
60 Oracle TimesTen In-Memory Database Installation Guide
Working with the TimesTen daemon and server
Uninstalling TimesTen
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
Uninstalling TimesTen
To stop the daemon manually, use the utility command
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
To stop the daemon manually, use the utility command
Working with the TimesTen daemon and Server
Using the Cache Administrator
Uninstalling TimesTen
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
Incremental install and uninstall of Cache Connect
ODBC installation
Environment modifications
“Shared library path environment variable” on page
“ODBCINI environment
variable” on page
“Default installation
PATH environment variable
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
On HP-UX 64-bit systems, add installdir/lib to the
78 Oracle TimesTen In-Memory Database Installation Guide
Web server configuration
Using the ttMigrate utility
Migrating data stores to TimesTen
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
Building and running the demo applications
Defining data sources for the demo applications
Problems running the demo programs
Building the demo applications
Problems running the C demo programs on UNIX
Problems running the C demo programs on Windows
Viewing the online documentation
Building and running the JDBC demo applications
Installation problems
Data Store Upgrades
Data store compatibility
Data type compatibility
Introduction
Data store character set
88 Oracle TimesTen In-Memory Database Installation Guide
Data type conversion
Data Store Upgrades
Upgrading data types as TimesTen data types
Converting data types to Oracle data types
90 Oracle TimesTen In-Memory Database Installation Guide
Data store character set conversion
Converting from the TIMESTEN8 character set
Converting from a character set other than TIMESTEN8
92 Oracle TimesTen In-Memory Database Installation Guide
In-place upgrades
Upgrade modes
Offline upgrades
Online upgrades with Client/Server
Online upgrades with replication
94 Oracle TimesTen In-Memory Database Installation Guide
Performing an in-place data store upgrade
Unloading a data store
Moving to a new patch release of TimesTen
Performing an offline upgrade
Moving to a different directory
Moving to a different machine
On the source system
On the destination system
Reducing data store size
Moving between 32-bit and 64-bit data stores
Moving to a different major release of TimesTen
c DSN=salesdata32 -noRepUpgrade /tmp/salesbackup
1. /opt/TimesTen/giraffe32/bin/ttMigrate
102 Oracle TimesTen In-Memory Database Installation Guide
ttAdmin -repStop master1
ttMigrate -c DSN=master1 master1.bak
ttDestroy /datastorepath/master1
The data stores are now upgraded and replicating to each other
Performing an online upgrade with replication
Overview
Step Upgrade System
Active System
Connect all applications to the active
Limitations
Requirements
Online upgrade example
108 Oracle TimesTen In-Memory Database Installation Guide
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
Overview
being replicated correctly, you can
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
Client/Server online upgrade
116 Oracle TimesTen In-Memory Database Installation Guide
Record of Upgrades
Client/Server online upgrade with continuous access to the data store
118 Oracle TimesTen In-Memory Database Installation Guide
Index
Numerics
120 Oracle TimesTen In-Memory Database Installation Guide
Solaris 19, 20
122 Oracle TimesTen In-Memory Database Installation Guide