Oracle^® Solaris Cluster Data Service for Oracle TimesTen Guide

Example: Installing TimesTen Software on Shared Storage

These steps illustrate how to install TimesTen software on shared storage.

1. Create the home directory for the TimesTen user.

   phys-schost-1# mkdir /global/mnt3/timesten

2. Change the ownership of the timesten directory.

   phys-schost-1# chown -R timesten:timesten /global/mnt3/timesten

3. Create the /etc/TimesTen directory and set the permission for the timesten user.

   phys-schost-1# mkdir /etc/TimesTen
   phys-schost-1# chgrp -R timesten /etc/TimesTen
   phys-schost-1# chmod 775 /etc/TimesTen
   
   phys-schost-2# mkdir /etc/TimesTen
   phys-schost-2# chgrp -R timesten /etc/TimesTen
   phys-schost-2# chmod 775 /etc/TimesTen

4. Log in as the TimesTen user.

   phys-schost-1# su - timesten
   phys-schost-2# su - timesten

5. Create the data directory on shared storage.

   phys-schost-1$ mkdir /global/mnt3/timesten/data

6. Create a .profile file in the TimesTen user's home directory.

   Add the following lines to the .profile file to set the necessary environment for logical hostname ha-host-1.

   phys-schost-1# vi .profile
   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=ha-host-1

7. Check the setting.

   phys-schost-1# su - timesten
   phys-schost-1$ hostname

8. Change to your software directory and install the TimesTen software.

   phys-schost-1$ cd /global/mnt3/repository/
   phys-schost-1$ tar xf timesten1122.tar
   phys-schost-1$ cd ./solx8664
   phys-schost-1$ ./setup.sh

   Provide the following answers to the questions. Most prompts in this example accept the default.

   Please choose an instance name for this installation? [ tt1122 ]
   Instance name will be 'tt1122'. Is this correct? [ yes ]
   
   Of the three components:
   
   [1] Client/Server and Data Manager
   [2] Data Manager Only
   [3] Client Only
   Which would you like to install? [ 1 ]
   
   Of the following options :
   
   [1] /export/tt
   [2] /my-data/solx8664
   [3] Specify a location
   [q] Quit the installation
   
   Where would you like to install the tt1122 instance of TimesTen? [ 1 ] 3
   Please specify a directory to install TimesTen? [ /export/tt ] /global/mnt3/timesten
   Where would you like to create
   the daemon home directory? [ /global/mnt3/timesten/TimesTen/tt1122/info ]
   Would you like to specify a different location for the daemon logs? [ no ]
   Do you want to use the default port number for the TimesTen daemon? [ yes ]
   Restrict access to the  TimesTen installation to the group 'timesten'? [ yes ]
   Please enter a value for TNS_ADMIN (s=skip)? [  ] s
   What is the TCP/IP port number that you want
   the TimesTen Server to listen n? [ 53389 ]
   Do you want to install QuickStart and the TimesTen Documentation? [ no ]
   Would you like to install the documentation (without QuickStart)? [ yes ]
   Where would you like to create
   the doc directory (s=skip)? [ /global/mnt3/TimesTen/tt1122/doc ]

9. Adjust the PATH variable to contain the TimesTen binaries, for convenience.

   phys-schost-1$ PATH=$PATH:/global/mnt3/TimesTen/tt1122/bin
   phys-schost-1$ export PATH

10. Create a data store.

    Add the following lines to the /global/mnt3/TimesTen/tt1122/info sys.odbc.ini file.

    [test]
    DataStore=/global/mnt3/data/test
    PermSize=64
    DatabaseCharacterSet=WE8MSWIN1252

11. Connect to the data store.

    phys-schost-1$ ttIsql -e "exit;" test

12. Stop the TimesTen server.

    phys-schost-1$ /global/mnt3/TimesTen/tt1122/startup/tt_tt1122 stop

13. Leave the TimesTen user and exit the non-global zone.