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
2 TimesTen Installation
Contents
1 Access Control
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
Book Titles
About this Guide
TimesTen documentation
Description
Background reading
It means
Conventions used in this guide
If you see
4 Oracle TimesTen In-Memory Database Installation Guide
Technical Support
6 Oracle TimesTen In-Memory Database Installation Guide
Access Control
Access Control
Limitations of Access Control and non-root installs
Introduction
Replication
Instance access
Cache Connect
Client/Server
Instance data store
TimesTen instance administrator
TimesTen users
External user
TimesTen instance users
Internal user
Instance registry directory
Before installation
TimesTen administrators group
Password file
Installation directories, files and the daemon port
Installation directories
Instance home directory
Privileges
Authenticating users and privileges
Daemon port
GroupRestrict
Listing of defined users and privileges
Enabling Access Control after installation on UNIX
Maintaining users and privileges
39 and “ORACLEHOME environment variable” on page
16 Oracle TimesTen In-Memory Database Installation Guide
Installation prerequisites Operating system security considerations
TimesTen Installation
Platforms and configurations Installation instances
Prerequisites for non-root installations on UNIX systems
Viewing the online documentation
Installation problems
Building and running the demo applications
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 port numbers
Installation instances
Instance names
Components available on UNIX
Choosing the appropriate TimesTen components
Components available on Windows
Installation prerequisites
UNIX requirements
Semaphores
Other Client Server Settings Replication
HP-UX
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
Solaris
30 Oracle TimesTen In-Memory Database Installation Guide
Cache Connect
Operating
Increase number of semaphores
Shared memory IPC client connections
Other changes Large data stores
Tru64 UNIX
# /sbin/sysconfig -q ipc
sysconfig -q ipc
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
Create the TimesTen instance administrators group
Prerequisites for non-root installations on UNIX systems
Installation prerequisites for non-root installs
Post-installation requirements
Create the TimesTen registry
UNIX libraries
Configure the syslog messages
Changing the daemon port number on UNIX
See “Components available on Windows” on page
Installing TimesTen on Windows systems
Installing TimesTen
Installing TimesTen in silent mode
2. Click System DSN
Verifying installation
Verifying TimesTen Client and Server installation
Working with the Data Manager Service and the Server
2. Select TimesTen Data Manager
2. Select TimesTen Data Manager
Installing TimesTen on Solaris systems
Uninstalling TimesTen
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
To start the daemon manually, use the utility command
Installing TimesTen on HP-UX systems
To stop the daemon manually, use the utility command
Uninstalling TimesTen
# mkdir /cdrom
50 Oracle TimesTen In-Memory Database Installation Guide
# cd mountdir # ./setup.sh
# /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
Uninstalling TimesTen
Installing TimesTen on HP-UX Memory Windows
Use a separate instance for each memory window
To stop the daemon manually, use the utility command
Using TimesTen in a memory window
Address Space Considerations
Troubleshooting
# crfs -v cdrfs -p ro -d cd0 -m /usr/cdrom/ TimesTen7.0
Installing TimesTen on AIX systems
Installing TimesTen
# mount /usr/cdrom/TimesTen7.0
58 Oracle TimesTen In-Memory Database Installation Guide
Installs documentation
60 Oracle TimesTen In-Memory Database Installation Guide
To stop the daemon manually, use the utility command
Working with the TimesTen daemon and server
Uninstalling TimesTen
To start the daemon manually, use the utility command
62 Oracle TimesTen In-Memory Database Installation Guide
Installing TimesTen on Linux systems
Installing TimesTen
Installs or uninstalls TimesTen and records responses
64 Oracle TimesTen In-Memory Database Installation Guide
To start the daemon manually, use the utility command
Uninstalling TimesTen
To stop the daemon manually, use the utility command
Working with the TimesTen daemon and Server
66 Oracle TimesTen In-Memory Database Installation Guide
Installing TimesTen on Tru64 UNIX systems
Installing TimesTen
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
To start the daemon manually, use the utility command
Using the Cache Administrator
Uninstalling TimesTen
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
“ODBCINI environment
Environment modifications
“Shared library path environment variable” on page
variable” on page
ODBCINI environment variable
“Default installation
PATH environment variable
“SYSODBCINI environment
76 Oracle TimesTen In-Memory Database Installation Guide
SYSODBCINI environment variable
SYSTTCONNECTINI environment variable
Shared library path environment variable
CLASSPATH environment variable
ORACLEHOME 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\tt60\bin\ttMigrate” -c DSN=Sales600 sales.dat
opt/tt60/32/bin/ttMigrate -c DSN=Sales600 sales.dat
C\ ”C\TimesTen\tt70\bin\ttMigrate” -r DSN=Salestt70 sales.dat
Using the ttBulkCp utility
Building and running the demo applications
Defining data sources for the demo applications
Problems running the C demo programs on UNIX
Problems running the demo programs
Building the demo applications
Problems running the C demo programs on Windows
Viewing the online documentation
Building and running the JDBC demo applications
Installation problems
Data type compatibility
Data Store Upgrades
Data store compatibility
Introduction
Data store character set
88 Oracle TimesTen In-Memory Database Installation Guide
Data type conversion
Data Store Upgrades
90 Oracle TimesTen In-Memory Database Installation Guide
Converting data types to Oracle data types
Upgrading data types as TimesTen data types
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
Offline upgrades
Upgrade modes
In-place upgrades
94 Oracle TimesTen In-Memory Database Installation Guide
Online upgrades with replication
Online upgrades with Client/Server
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
c DSN=salesdata32 -noRepUpgrade /tmp/salesbackup
Moving between 32-bit and 64-bit data stores
Moving to a different major release of TimesTen
1. /opt/TimesTen/giraffe32/bin/ttMigrate
ttMigrate -c DSN=master1 master1.bak
102 Oracle TimesTen In-Memory Database Installation Guide
ttAdmin -repStop master1
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
110 Oracle TimesTen In-Memory Database Installation Guide
ttAdmin
ttAdmin
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
For this example, the hostname for the server machine is myserver
Client/Server online upgrade example
Limitations
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
