How to Install and Configure TimesTen

Language:

Note - For complete information about installing TimesTen, go to http://www.oracle.com/technetwork/database/timesten/documentation/index.html.

For complete deployment examples, see Appendix B, Deployment Example: Installing HA for TimesTen in a Failover Configuration, Appendix C, Deployment Example: Installing HA for TimesTen in an Active-Active Configuration or Appendix D, Deployment Example: Installing HA for TimesTen in a Scalable Subscriber Configuration.

Before You Begin

Determine the following requirements for the deployment of TimesTen with Oracle Solaris Cluster:

Verify that the TimesTen version you need is already installed on each global-cluster or zone-cluster node. Search the most probable root paths where you find bin/ttIsql.

/your-path

Fully customized root path for TimesTen. This is where to place the binaries on the shared or local storage. A known convention is /path/TimesTen/instancename.
Determine the number of TimesTen instances to deploy.
Determine the number of TimesTen data stores to deploy.
Determine which local or cluster file systems will be used by each TimesTen resource.

The following assumptions are made:

The TimesTen database software will be installed on shared or local storage in the directory TimesTen in the file system /tt.
The TimesTen database content will be installed in the same file system as the database software, in the directory /tt/data.
The home directory of the timesten user is /tt.

Assume the root role and create the home directory for the TimesTen user on each node that runs the instance in parallel.
```
# mkdir /tt
```
Add a group for TimesTen on every node.
```
# groupadd -g 1000 timesten
```

Add a user who owns the TimesTen installation on every node.

# useradd -u 1000 -g timesten -d /tt -s /usr/bin/ksh tt
# chown -R timesten:timesten /tt

Create the /etc/TimesTen directory on every node.

# mkdir /etc/TimesTen
# chgrp -R timesten /etc/TimesTen
# chmod -R 775 /etc/TimesTen

Switch to the TimesTen user.
```
# su - timesten
$
```

If you are configuring a TimesTen failover service, set the LD_PRELOAD variable.

$ export LD_PRELOAD_32=$LD_PRELOAD_32:/usr/cluster/lib/libschost.so.1
$ export LD_PRELOAD_64=$LD_PRELOAD_64:/usr/cluster/lib/64/libschost.so.1
$ export SC_LHOSTNAME=logical host ip alias

(Optional) Add export statements for your LD_PRELOAD variables to your shells profile.

Install TimesTen software.

$ cd your-timesten-install-dir
$ ./setup.sh

Configure your data stores.

Add the following entries to your sys.odbc.ini file.

$ cat - > your-instance-dir/info/sys.odbc.ini
[test]
DataStore=/tt/data/test
PermSize=64
DatabaseCharacterSet=WE8MSWIN1252

Create the directory to contain the data stores.
```
$ mkdir /tt/data
```