Step by Step Oracle TimesTen In-Memory Database Installation On Linux

In this article, we will see the step by step installation of Oracle TimesTen In-Memory Database 11.2.2 and TimesTen Applications Database Cache 11.2.2 on RHEL 6.8.

Download the Oracle TimesTen Database Software from here.

Create an operating system group for the TimesTen instance administrators
group.

Create ttadmin group:-

$ /usr/sbin/groupadd -g 54331 ttadmin

Create /etc/TimesTen directory:-

$ mkdir /etc/TimesTen

Assign ownship permission to group ttadmin to directory /etc/TimesTen:-

$ chgrp -R ttadmin /etc/TimesTen
$ chmod -R 775 /etc/TimesTen
$ ls -ltrhd /etc/TimesTen/ls -ltrhd /etc/TimesTen/
drwxrwxr-x. 2 root ttadmin 4.0K Dec 23 13:21 /etc/TimesTen/

Create user oratta with group ttadmin:-

$ /usr/sbin/useradd -u 54331 -g ttadmin oratta
$ id oratta
uid=54331(oratta) gid=54331(ttadmin) groups=54331(ttadmin)

Create and change ownership to the directories to oratta as owner and group ttadmin:-

$ mkdir -p /oradb/app/oratta/TimesTen
$ chown -R oratta:ttadmin /oradb/app/oratta

Login as oratta user and start installation:-

$ su – oratta
$ unzip the TimesTen software
$ tar -zxvf timesten112280.linux8664.tar.gz
$ cd linux8664
$ ./setup.sh

NOTE: Each TimesTen installation is identified by a unique instance name.
The instance name must be a non-null alphanumeric string, not longer
than 255 characters.

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] /home/oratta
[2] /mnt/hgfs/shared/Softwares/oracle/Timesten
[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? [ /home/oratta ] /oradb/app/oratta/TimesTen
Where would you like to create the daemon home directory? [ /oradb/app/oratta/TimesTen/tt1122/info ]

The daemon logs will be located in /oradb/app/oratta/TimesTen/tt1122/info
Would you like to specify a different location for the daemon logs? [ no ]
Installing into /oradb/app/oratta/TimesTen/tt1122 …
Uncompressing …

NOTE: If you are configuring TimesTen for use with Oracle Clusterware, the
daemon port number must be the same across all TimesTen installations
managed within the same Oracle Clusterware cluster.

NOTE: All installations that replicate to each other must use the same daemon
port number that is set at installation time. The daemon port number can
be verified by running ‘ttVersion’.

The default port number is 53396.

Do you want to use the default port number for the TimesTen daemon? [ yes ]
The daemon will run on the default port number (53396).

NOTE: For security, we recommend that you restrict access to the
TimesTen installation to members of a single OS group. Only members of
that OS group will be allowed to perform direct mode connections to
TimesTen, and only members of that OS group will be allowed to perform
operations that access TimesTen data stores, TimesTen files and shared
memory. The OS group defaults to the primary group of the instance
administrator. You can default to this group, choose another OS group
or you can make this instance world-accessible. If you choose to make
this instance world-accessible, all database files and shared memory
are readable and writable by all users.

Restrict access to the the TimesTen installation to the group ‘ttadmin’? [ yes ]

NOTE: Enabling PL/SQL will increase the size of some TimesTen libraries.

Would you like to enable PL/SQL for this instance? [ yes ]

In order to use the ‘Oracle TimesTen Application-Tier 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)? [ ] /oradb/app/oracle/product/11.2.0.4/db_1/network/admin

TNS_ADMIN will be set to /oradb/app/oracle/product/11.2.0.4/db_1/network/admin
You can change TNS_ADMIN later by running <install_dir>/bin/ttmodinstall.

NOTE: It appears that you are running version 4 or higher of the g++
compiler. TimesTen ships with multiple sets of client libraries and server
binaries : one built for compatibility with g++ 3.4.6 and one with
g++ 4.1.0. The installer has created links to the 4.1.0 library in the
<install_dir>/lib directory and to the 4.1.0 server binary in the
<install_dir>/bin directory. If you want to use a different compiler,
please modify the links to point to the desired library and server binary.

Installing server components …
What is the TCP/IP port number that you want the TimesTen Server to listen on? [ 53397 ]
Do you want to install the Quick Start Sample Programs and the TimesTen Documentation? [ no ] yes
Where would you like to install the Quick Start and doc directories (s=skip)? [ /oradb/app/oratta/TimesTen/tt1122 ]
The TimesTen documentation has been installed in /oradb/app/oratta/TimesTen/tt1122.

The TimesTen Quick Start applications can take up to 64 Mbytes of disk space.
Depending on how your system is configured, you may not want to create the
Quick Start DemoDataStore directory in the default location,
/oradb/app/oratta/TimesTen/tt1122/info/DemoDataStore

Where would you like to create the DemoDataStore directory? [ /oradb/app/oratta/TimesTen/tt1122/info ]
Creating /oradb/app/oratta/TimesTen/tt1122/info/DemoDataStore …

Installing client components …

Would you like to use TimesTen Replication with Oracle Clusterware? [ no ]

NOTE: The TimesTen daemon startup/shutdown scripts have not been installed.

Run the ‘setuproot’ script :
$ cd /oradb/app/oratta/TimesTen/tt1122/bin
$ ./setuproot -install
This will move the TimesTen startup script into its appropriate location.

The startup script is currently located here :
‘/oradb/app/oratta/TimesTen/tt1122/startup/tt_tt1122’.

The Quickstart home page can be accessed here :
‘/oradb/app/oratta/TimesTen/tt1122/quickstart/index.html’

The 11.2.2.8 Release Notes are located here :
‘/oradb/app/oratta/TimesTen/tt1122/README.html’

Starting the daemon …
TimesTen Daemon startup OK.
End of TimesTen installation.

Set the Timeten Environment like below:-

$ cd /oradb/app/oratta/TimesTen/tt1122/bin
$ . ttenv.sh

LD_LIBRARY_PATH set to /oradb/app/oratta/TimesTen/tt1122/lib:/oradb/app/oratta/TimesTen/tt1122/ttoracle_home/instantclient_11_2

PATH set to /oradb/app/oratta/TimesTen/tt1122/bin:/oradb/app/oratta/TimesTen/tt1122/quickstart/sample_code/oci:/oradb/app/oratta/TimesTen/tt1122/quickstart/sample_code/odbc:/oradb/app/oratta/TimesTen/tt1122/quickstart/sample_code/odbc/xla:/oradb/app/oratta/TimesTen/tt1122/quickstart/sample_code/jdbc:/oradb/app/oratta/TimesTen/tt1122/quickstart/sample_code/odbc_drivermgr:/oradb/app/oratta/TimesTen/tt1122/quickstart/sample_code/proc:/oradb/app/oratta/TimesTen/tt1122/quickstart/sample_code/ttclasses:/oradb/app/oratta/TimesTen/tt1122/quickstart/sample_code/ttclasses/xla:/oradb/app/oratta/TimesTen/tt1122/ttoracle_home/instantclient_11_2:/oradb/app/oratta/TimesTen/tt1122/ttoracle_home/instantclient_11_2/sdk:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/oratta/bin

CLASSPATH set to /oradb/app/oratta/TimesTen/tt1122/lib/ttjdbc6.jar:/oradb/app/oratta/TimesTen/tt1122/lib/orai18n.jar:/oradb/app/oratta/TimesTen/tt1122/lib/timestenjmsxla.jar:/oradb/app/oratta/TimesTen/tt1122/3rdparty/jms1.1/lib/jms.jar:.

TNS_ADMIN set to /oradb/app/oracle/product/11.2.0.4/db_1/network/admin

Verify the version:-

$ ttversion
TimesTen Release 11.2.2.8.0 (64 bit Linux/x86_64) (tt1122:53396) 2015-01-20T08:36:31Z
Instance admin: oratta
Instance home directory: /oradb/app/oratta/TimesTen/tt1122
Group owner: ttadmin
Daemon home directory: /oradb/app/oratta/TimesTen/tt1122/info
PL/SQL enabled.

$ ttstatus
TimesTen status report as of Sun Dec 23 14:10:09 2018

Daemon pid 16248 port 53396 instance tt1122
TimesTen server pid 16257 started on port 53397
————————————————————————
Accessible by group ttadmin
End of report

 

 

 

 

 

 

 

Catch Me On:- Hariprasath Rajaram

Telegram:https://t.me/joinchat/I_f4DhGF_Zifr9YZvvMkRg
LinkedIn:https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page: https://www.facebook.com/dbahariprasath/?
Twitter: https://twitter.com/hariprasathdba

Leave a Reply

Your email address will not be published. Required fields are marked *