ORACLE TIMES TEN
INSTALLATION
DOCUMENT
HARIHARAN.S
ORACLE SSI
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.
YES
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
CPUs.
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: http://www.oracle.com/technetwork/database/timesten/downloads/index.html
TIMES TEN - 11.2.1.7.0 for LINUX x86(64-bit),
3. INTRODUCTION:
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)
4. GENERAL REQUIREMENTS:
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.Note:
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 :
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
Note:
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
If PAM (Pluggable Authentication Modules) is enabled, you may need to change the Hugepagesize
in /proc/meminfo
indicates the system's fixed large page size./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 asroot
and edit the /etc/sysctl.conf
file by adding the line:kernel.shmmax=2147483648
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:kernel.shmmax=68719476736
kernel.shmall=4194304
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
Replication:
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
net.core.rmem_default=65535
net.core.wmem_default=65535
net.core.rmem_max=4194304
net.core.wmem_max=4194304
net.ipv4.tcp_window_scaling=1
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.core.rmem_default=262144
net.core.wmem_default=262144
net.core.rmem_max=4194304
net.core.wmem_max=4194304
net.ipv4.tcp_window_scaling=1
net.ipv4.ip_local_port_range="1024 65000"
to the /etc/sysctl.conf
file and either reboot or run the command:
# /sbin/sysctl -pDefault installation directories
The TimesTen default installation directories for release 11.2.1 are as follows:· On Windows,
C:\TimesTen
· On UNIX,
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.$HOME/TimesTen (Here I use /opt/TimesTen)
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".
6. CREATE THE TIMES TEN USER 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> $ ./setup.sh
Note:
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 .

UNCOMPRESSING ………..
· 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.
* FOLLOW THE PROCEDURE IF YOU ARE USING CLUSTERWARE:


· 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
FOLLOW the NOTE : for TCP/IP for TIMES TEN SERVER ……
INSTALLING SERVER components :

· 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 -stopTo start the daemon manually, use the utility command:
$ ttDaemonAdmin -start
********************************* EOF *************************************