Monday, 18 April 2011




Table of Contents: 

v Platforms and configurations          à                                   1

v Software Download Link               à                                   2

v Introduction                                    à                                   3

v General Requirements                    à                                   4

v Pre-Install requirements                 à                                    5

v Times Ten USER & GROUPS
and Directories                               à                                    6

v Installing Times Ten on LINUX    à                                   7

1. Platforms and configurations
Platform support

Times Ten Data Manager and Times Ten Client/Server are supported in
the following environments:.

            Environment                                                                                   32-bit                                64-bit

Microsoft Windows 2000, Windows
XP and Windows Server 2003 for
Intel CPUs.
Solaris 10 for AMD64 CPUs.                                                                     
Solaris 8, 9 and 10 for UltraSparc                                                             YES                                  YES
Architecture CPUs.

SUSE LINUX Enterprise Server 9
For Intel IA-32 and EM64T and                                                                YES                                 YES
AMD64 CPUs.                       

Red Hat Enterprise Linux ES, AS
And WS 3 and 4 for Intel Itanium2                                                           YES                                 YES

Oracle TimesTen In-Memory Database Installation and Configuration Guide
Red Hat Enterprise Linux AS, ES
and WS 3 and 4 for Intel IA-32 and                                                           YES                                 YES            
EM64T and AMD64 CPUs.                   

MontaVista Linux Carrier Grade
Edition Release 3.1 for Intel IA-32                                                            YES                                  YES
and EM64T CPUs.                                 

2.  Download the ORACLE TIMES TEN software from:
TIMES TEN - for LINUX x86(64-bit),

Oracle Times Ten In-Memory Database is a memory resident relational database management system that allows applications to access capture or modify information FASTER than traditional database products.
This document will detail the installation steps for Oracle Times Ten In-Memory Database on Linux (64-bit)


Linux prerequisites

For Linux, TimesTen has been tested with Asianux 2.0 and 3.0, Red Hat Enterprise Linux 4 and 5, the MontaVista Linux Carrier Grade Edition Release 4.0 and 5.0 and SuSE LINUX Enterprise Server 10 minimal configurations. The C development tools are required if you intend to do native development on the machine.
TimesTen does not support SELinux. When installing Linux for use with TimesTen, make sure that the SELinux option is disabled.
On Linux, before installation, the following sections describe steps you can perform to improve the performance of TimesTen on your system:
·         Large pages
·         Semaphores
·         Shared memory
·         IPC Client/Server
·         Replication
·         IMDB Cache

Large pages :

Large pages can be enabled only if the running Linux kernel supports large pages (also called "huge pages" in the Linux community).If large pages are supported by the kernel, there should be special files in the /proc directory that indicate the number and size of the large pages.
On Linux 2.4.x systems, the /proc/sys/vm/hugetlb_pool indicates the total size of the large pages. On 2.6.x systems, the /proc/sys/vm/nr_hugepages file indicates the total number of large pages.
You can change the total number and size of the large pages by changing the contents of those files. For example, you can use:
echo 32 > /proc/sys/vm/nr_hugepages
To see the number and size of the allocated large pages use:
cat /proc/meminfo
The following output from this command would indicate that you have 16 large pages, each of the size 256MB for a total of 4GB:
HugePages_Total: 16
HugePages_Free: 16
Hugepagesize: 262144 kB
Since large pages must be allocated on a contiguous memory space, the actual large page size allocated may be smaller than requested. Also, the large page size itself is not configurable. The value of Hugepagesize in /proc/meminfo indicates the system's fixed large page size.
If PAM (Pluggable Authentication Modules) is enabled, you may need to change the /etc/security/limits.conf file.
You must also set /proc/sys/vm/hugetlb_shm_group to the group ID of the user that is running the main TimesTen daemon.
The operating system now is ready for the large page support. To enable this feature on TimesTen, simply set -linuxLargePageAlignment Size_in_MB in the daemon options file (ttendaemon.options).
You should specify the large page alignment size in MB, which is the Hugepagesize value in /proc/meminfo.
Once you set up large pages, TimesTen uses as many large pages as possible. If there are not enough pages, TimesTen uses the normal pages after consuming all available large pages. When TimesTen uses large pages, the HugePages_Free file in /proc/meminfo changes.

Semaphores: To view existing kernel parameter settings, log in as root and use:

# /sbin/sysctl –a 
On Linux systems, the first parameter of kernel.sem must be a minimum of 128. We recommend that you add the line:
kernel.sem = 250 32000 100 128
to the /etc/sysctl.conf file and either reboot or run the command:
# /sbin/sysctl -p


Shared memory:

To increase the shared memory size to 2048 MB, login as root and edit the /etc/sysctl.conf file by adding the line:
If your configuration is greater than 8GB, you should also increase the value of the shmall parameter. The value is in KB and should be equal to ceil(SHMMAX/PAGE_SIZE). Page size is generally 4K on x86 systems and 16K on Itanium. For example, for a 64GB data store on Itanium, you should specify the following parameters values:
To increase the shared memory size without rebooting, use:
% /sbin/sysctl -w kernel.shmmax=2147483648
If you have your kernel configured with the /proc file system and it is mounted, then the current maximum shared memory segment size (in bytes) can be viewed by the following command:
% cat /proc/sys/kernel/shmmax
You can also change this value by the following command:
% echo 2147483648 > /proc/sys/kernel/shmmax
This command has the same effect as the sysctl command.

IPC Client/Server:

On Red Hat Linux systems, to enable more than 6 ShmIpc Client/Server connections, add the line:
kernel.sem = 250 32000 128 100
to the /etc/sysctl.conf file and either reboot or run the command:
# /sbin/sysctl -p


For replication, TCP send and receive buffers should be increased to a minimum of 512KB. To increase the buffers to 4 MB, add the lines:
net.ipv4.tcp_rmem=4096 4194304 4194304
net.ipv4.tcp_wmem=98304 4194304 4194304
to the /etc/sysctl.conf file and either reboot or run the command:
# /sbin/sysctl -p

IMDB Cache:

For IMDB Cache, TCP send and receive buffers should be increased to even greater values. To make these changes, add the lines:
net.ipv4.tcp_rmem=4096 4194304 4194304
net.ipv4.tcp_wmem=98304 4194304 4194304
net.ipv4.ip_local_port_range="1024 65000"
to the /etc/sysctl.conf file and either reboot or run the command:
# /sbin/sysctl -p

Default installation directories

The TimesTen default installation directories for release 11.2.1 are as follows:
·         On Windows, C:\TimesTen
·         On UNIX, $HOME/TimesTen (Here I use /opt/TimesTen)
TimesTen creates temporary files when a transaction fees a large amount of space in a data store. In addition, other TimesTen operations, such as large deletes, use the temporary directory when copying files.
The temporary directory is operating system-dependent. Usually it is located in these directories:
·         On Windows, C:\Documents and Settings\%USERNAME%\Local Settings\Temp
·         On Solaris and Linux, /tmp


5. Pre-Install requirements for operating system group and file permissions :

TimesTen instance administrators and TimesTen users groups :

·         On UNIX, the TimesTen instance administrators group and the TimesTen users group can be the same or different operating system groups:
o    TimesTen instance administrator group. Any user installing TimesTen must be a member of this group. This group must be granted read and write access to /etc/TimesTen, which contains information about all TimesTen instances installed on the machine.
o    TimesTen users group. The instance administrator must also be a member of this group to install TimesTen. After installation, only members of this operating system group are allowed to make direct driver connections to TimesTen and perform operations on TimesTen data stores.
The details on how to create both operating system groups on UNIX are included in "Creating UNIX TimesTen administrator and users groups".



  During installation, you must specify the TimesTen users group. By default, the TimesTen users group for the instance is the primary operating system group of the user installing TimesTen. If you want the TimesTen users group to be other than the installer's primary group, you must specify the name of the group during installation.
Alternatively, you can make the TimesTen instance world accessible. However, this is not recommended.

The only way to change the TimesTen user group is to uninstall and reinstall the TimesTen instance, providing the new group name during reinstall.

1.      Login as root.
2.      If the directory /etc/TimesTen does not already exist, create it.
3.      # mkdir /etc/TimesTen
The disk space required for the files in this directory is at least 100 KB.
4.      Create an operating system group for the TimesTen instance administrators group. You can name this group as you wish. For our examples, we use the name ttadmin.
5.      # groupadd ttadmin
6.      Assign ownership permissions on the /etc/TimesTen directory to the TimesTen instance administrators group so that only the instance administrator may access and execute. At install time, the instance_info file is added to the /etc/TimesTen directory. This file must be readable and writable by the instance administrators group.
Before installing TimesTen, set the permission mode for /etc/TimesTen to 770, and permissions for all files under /etc/TimesTen to 660.
The following commands modify the group ownership of the TimesTen directory to be the ttadmin group and changes the permissions for all files in this directory to read and write for members of the ttadmin group:
# chgrp -R ttadmin /etc/TimesTen
# chmod 770 /etc/TimesTen/
# chmod 660 /etc/TimesTen/*  
7.      You can now install TimesTen on UNIX systems. The installer verifies the existence and permissions of /etc/TimesTen and fails if the permissions are not correct.

7. Installing TimesTen on UNIX systems :

Installing TimesTen

To install TimesTen on your LNIX system, follow these steps:
1.      Download TimesTen to your system. The download consists of a gzipped tar file that is named timesten_112170.tar.gz, for example.
2.      Log in as the TimesTen instance administrator and copy the gzip file to the location from which you wish to install.
3.      Unzip the installation file:
$  gunzip timestenrelease.platform.tar.gz
4.      Extract the TimesTen files:
$  tar -xvf timestenrelease.platform.tar
5.      Change to the platform directory:
$  cd linux8664
6.      Run the TimesTen setup script:
linux86> $   ./
If a user installs TimesTen as root, the installer gives the following warning: "You are about to install TimesTen as root. TimesTen daemon processes run with root privileges."
If you click OK to install as root, then the instance administrator is root, and any actions or applications that must be performed by the instance administrator must be run as root.

·         Choose the default instance name by  PRESS ENTER  or choose an instance name for your TimesTen instance :

You can install the TimesTen Client, Server and Data Manger.
·         The TimesTen Client Only install is used when you want  to be able to access a TimesTen server on another installation.
·         Use the Data Manager only install to install the TimesTen Data Manager Locally.
·         The Client/Server and Data Manager install option installs all components of TimesTen.


By default TimesTen is installed in $HOME/TimesTen. The installer gives the option to install into another directory. For this installation we have chosen /opt/TimesTen

PRESS 3 and specify a location  (/opt/TimesTen)

PRESS ENTER to select DEFAULT location :
·         You can choose the location in which logs will be written. The default location is TimesTenIinstall/TimesTenInstance/info.
·         PRESS NO for default location .

·         The default port number for the TimesTen daemon ins 53384 for 32bit systems and 53388 for 64bit systems. Note the notices concerning Clusterware and replication below.


·         Select the PORT number for TIMES TEN DEAMON  (PRESS YES for DEFAULT)

·         We created the group timesten earlier so we could restrict access to TimesTen databases files and shared memory to this group.
·         PRESS YES

·         Next we are given the option of enabling PL/SQL in TimesTen. PL/SQL can be enabled after install using the ttmodinstall utility.
·         The path used for the TNS_ADMIN can be set during the install or later with ttmodinstall.
·         In order to use the 'In-Memory Database Cache' feature in any databases
·         created within this installation, you must set a value for the TNS_ADMIN environment variable. It can be left blank, and a value can be supplied later using <install_dir>/bin/ttModInstall.Please enter a value for
          TNS_ADMIN (s=skip)? [  ] /u01/app/oracle/product/11.2.0/dbhome_1/network/admin


·         installing CLINET COMPONENTS:
·         If you are not using clusterware PRESS  NO

·         Below are notes on how configure startup/shutdown scripts to start and stop the TimesTen instance on server start/stop.
·         RUN the following script AS ROOT in particular location  :

·         Now that we have installed TimesTen and have a running instance we can now connect to the sample database created during the installation using  ttisql.
·         And check the size of DATASTORE  using following command .
To  stop the daemon manually, use the utility command:
$  cd TT-HOME DIR/TimesTen/Inattancename/bin
$ ttDaemonAdmin -stop
To start the daemon manually, use the utility command:
$ ttDaemonAdmin -start

*********************************  EOF *************************************

No comments:

Post a Comment