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

Search Scope:

- This Document
- Entire Library

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

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.

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

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

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

Copyright © 2010, 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices |