Installing and Configuring TimesTen

This section explains only the special requirements for installing TimesTen for use with HA for TimesTen. For complete information about installing and configuring TimesTen, see TimesTen documentation. For complete information about installing and configuring a Solaris Container, see System Administration Guide: Oracle Solaris Containers-Resource Management and Oracle Solaris Zones.

To determine which TimesTen version is installed, run the following commands.

# su - non-root-user
$ ttIsql --version

For each TimesTen instance that you are installing and configuring, choose the following tasks depending on whether you will configure HA for TimesTen to run in a global zone or in a non-global zone:

To install and configure TimesTen in a global zone configuration, complete the following tasks:
- How to Enable a TimesTen Database to Run in a Global Zone Configuration
- How to Install and Configure TimesTen
To install and configure TimesTen in a non-global zone configuration, complete the following tasks:
- How to Enable TimesTen to Run in a Non-Global Zone Configuration
- How to Install and Configure TimesTen

How to Enable a TimesTen Database to Run in a Global Zone Configuration

This procedure creates the cluster infrastructure, such as resource groups, storage resources, and IP resources, according to your TimesTen configuration. 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.

Note - If you are deploying an active-standby configuration, do not perform this procedure. Instead, install TimesTen software and proceed to How to Create and Enable Resources for TimesTen in an Active-Standby Configuration.

(Optional) As superuser, register the SUNW.HAStoragePlus resource type.
```
# clresourcetype register SUNW.HAStoragePlus
```
Create a failover or multiple-master resource group.
- For a failover resource group, perform the following command:
```
# clresourcegroup create TimesTen-resource-group
```
- For a multiple-master resource group, perform the following command:
```
# clresourcegroup create -p maximum_primaries=2 \
-p desired_primaries=2 \
TimesTen-resource-group
```

(Optional) For a failover configuration, create a resource for the TimesTen disk storage.

# clresource create -t SUNW.HAStoragePlus \
-p FileSystemMountPoints=TimesTen-instance-mount-points \
TimesTen-has-resource

Create a logical-hostname or shared-address resource group.

To access the database from a logical host, perform the following command:

# clreslogicalhostname create -g TimesTen-resource-group \
TimesTen-logical-hostname-resource-name

To access the database from a shared address, perform the following commands:

# clresourcegroup create TimesTen-access-group
# clressharedaddress create -g TimesTen-access-group \
TimesTen-shared-address-resource-name

Enable the resource groups.

# clresourcegroup online -eM TimesTen-resource-group
# clresourcegroup online -eM TimesTen-access-group

How to Enable TimesTen to Run in a Non-Global Zone Configuration

Follow this procedure unless you are deploying an active-standby configuration. If you configure an active-standby configuration, install TimesTen and proceed with How to Create and Enable Resources for TimesTen in an Active-Standby Configuration

(Optional) As superuser, register the SUNW.HAStoragePlus resource type.
```
# clresourcetype register SUNW.HAStoragePlus
```

Create a failover or multiple-master resource group.

For a failover resource group, perform the following command:

# clresourcegroup create -n node:zone[…] TimesTen-resource-group

For a multiple-master resource group, perform the following command:

# clresourcegroup create -n node1:zone1,node2:zone2 \
-p maximum_primaries=2 \
-p desired_primaries=2 \
-n node1:zone1,node2:zone2 \
TimesTen-resource-group

(Optional) For a failover configuration, create a resource for the TimesTen disk storage.

# clresource create -t SUNW.HAStoragePlus \
-p FileSystemMountPoints=TimesTen-instance-mount-points \
TimesTen-has-resource

Create a logical-hostname or shared-address resource group.

To access the database from a logical host, perform the following command:

# clreslogicalhostname create -g TimesTen-resource-group \
TimesTen-logical-hostname-resource

To access the database from a shared address, perform the following commands:

# clresourcegroup create -nnode1:zone1,node2:zone2 TimesTen-access-group
# clressharedaddress create -g TimesTen-access-group \
TimesTen-shared-address-resource

Enable the resource groups.

# clresourcegroup online -eM TimesTen-resource-group
# clresourcegroup online -eM TimesTen-access-group

How to Install and Configure TimesTen

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 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.

As superuser, create the home directory for the TimesTen user on each node or non-global zone that runs the instance in parallel.
```
#  mkdir /tt
```
Add a group for TimesTen on every node or non-global zone.
```
# groupadd -g 1000 timesten
```

Add a user who owns the TimesTen installation on every node or non-global zone.

# 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 or non-global zone.

# 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
```

Skip Navigation Links
Exit Print View
	Oracle Solaris Cluster Data Service for Oracle TimesTen Guide Oracle Solaris Cluster