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 Oracle Solaris 11.1 Administration: Oracle Solaris Zones, Oracle Solaris 10 Zones, and Resource Management.

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

1. (Optional) Assume the root role and register the SUNW.HAStoragePlus resource type.

   # clresourcetype register SUNW.HAStoragePlus

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

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

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

5. Enable the resource groups.

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

How to Install and Configure TimesTen

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.

1. Assume the root role and create the home directory for the TimesTen user on each node or non-global zone that runs the instance in parallel.

   #  mkdir /tt

2. Add a group for TimesTen on every node or non-global zone.

   # groupadd -g 1000 timesten

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

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

5. Switch to the TimesTen user.

   # su - timesten
   $

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

7. (Optional) Add export statements for your LD_PRELOAD variables to your shells profile.
8. Install TimesTen software.

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

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

10. Create the directory to contain the data stores.

    $ mkdir /tt/data