Installing TimeTen database as a test.

As the title says, I am installing Oracle TimesTen database on top of my Oracle 11G database.

Download

http://www.oracle.com/technetwork/database/database-technologies/timesten/downloads/index.html

Extract and Install

[oracle@Aigamenate downloads]$ tar -xvf timesten112260.linux8664
linux8664/
linux8664/uninst.sh
linux8664/install.pl
linux8664/README.html
linux8664/LINUX8664/
linux8664/LINUX8664/ttpatchinst
linux8664/LINUX8664/unzip
linux8664/LINUX8664/common.tar.bz2
linux8664/LINUX8664/ttclient.tar.bz2
linux8664/LINUX8664/perl
linux8664/LINUX8664/manifest
linux8664/LINUX8664/timesten.tar.bz2
linux8664/LINUX8664/bzip2
linux8664/LINUX8664/ttserver.tar.bz2
linux8664/3rdparty/
linux8664/3rdparty/ant-1.6.2-bin.tar.bz2
linux8664/3rdparty/jms-1_1-fr-apidocs.tar.bz2
linux8664/doc/
linux8664/doc/doc.zip
linux8664/setup.sh
[oracle@Aigamenate downloads]$

[oracle@Aigamenate downloads]$ cd linux8664
[oracle@Aigamenate linux8664]$ pwd
/home/oracle/downloads/linux8664

[oracle@Aigamenate linux8664]$ ls -lrt
total 464
-rwxr-xr-x 1 oracle oracle  34886 Nov 21 20:24 uninst.sh
-rwxr-xr-x 1 oracle oracle   5623 Nov 21 20:24 setup.sh
-rwxr--r-- 1 oracle oracle 128225 Nov 21 20:24 README.html
-rwxr-xr-x 1 oracle oracle 248855 Nov 21 20:24 install.pl
drwxrwxr-x 2 oracle oracle   4096 Nov 21 20:26 doc
drwxr-xr-x 2 oracle oracle   4096 Nov 21 20:26 3rdparty
drwxr-xr-x 2 oracle oracle   4096 Nov 21 20:26 LINUX8664

[oracle@Aigamenate linux8664]$ ./setup.sh

ERROR: The /etc/TimesTen directory needs to be created for the instance registry
       and its ownership and permissions set appropriately.
       Please refer to the installation guide for assistance.

http://docs.oracle.com/cd/E21901_01/doc/timesten.1122/e21632/install.htm [oracle@Aigamenate linux8664]$ su - Password: [root@Aigamenate ~]# groupadd ttadmin [root@Aigamenate ~]# groupadd ttadmin groupadd: group ttadmin exists [root@Aigamenate ~]# mkdir /etc/TimesTen [root@Aigamenate ~]# chgrp -R ttadmin /etc/TimesTen [root@Aigamenate ~]# chmod 770 /etc/TimesTen/ [root@Aigamenate ~]# chmod 660 /etc/TimesTen/* chmod: cannot access `/etc/TimesTen/*': No such file or directory

Better to just install as root. I am not sure if I suppose to install TimesTen with root. You should read the documentation. I was doing this as a quick validation test.

[root@Aigamenate linux8664]# ./setup.sh

WARNING: You are about to install TimesTen as root. TimesTen daemon processes will
         run with root privileges. See the TimesTen Installation Guide for additional
         information.

Are you sure that you want to install as root? [ no ] yes

Are you sure that you want to install as root? [ no ] yes

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] /opt
  [2] /home/oracle/downloads
  [3] Specify a location
  [q] Quit the installation

Where would you like to install the tt1122 instance of TimesTen? [ 1 ]

The daemon logs will be located in /opt/TimesTen/tt1122/info
Would you like to specify a different location for the daemon logs? [ no ]
Installing into /opt/TimesTen/tt1122 ...
Creating /opt/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 'root'? [ 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 '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)? [  ] /home/oracle/app/oracle/product/11.2.0/ora11204/network/admin/

TNS_ADMIN will be set to /home/oracle/app/oracle/product/11.2.0/ora11204/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 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)? [ /opt/TimesTen/tt1122/doc ]
The TimesTen documentation has been installed in /opt/TimesTen/tt1122/doc.
Installing client components ...

Would you like to use TimesTen Replication with Oracle Clusterware? [ no ]
The 11.2.2.6 Release Notes are located here :
  '/opt/TimesTen/tt1122/README.html'

Starting TimesTen Daemon : [  OK  ]
End of TimesTen installation.
[root@Aigamenate linux8664]#

[root@Aigamenate linux8664]# ps -ef|grep Times
root     24321     1  0 10:08 ?        00:00:00 /opt/TimesTen/tt1122/bin/timestend -initfd 13
root     24325 24321  0 10:08 ?        00:00:00 /opt/TimesTen/tt1122/bin/timestensubd -verbose -userlog /opt/TimesTen/tt1122/info/tterrors.log -supportlog /opt/TimesTen/tt1122/info/ttmesg.log -id 1000000 -facility user
root     24326 24321  0 10:08 ?        00:00:00 /opt/TimesTen/tt1122/bin/timestensubd -verbose -userlog /opt/TimesTen/tt1122/info/tterrors.log -supportlog /opt/TimesTen/tt1122/info/ttmesg.log -id 1000001 -facility user
root     24327 24321  0 10:08 ?        00:00:00 /opt/TimesTen/tt1122/bin/timestensubd -verbose -userlog /opt/TimesTen/tt1122/info/tterrors.log -supportlog /opt/TimesTen/tt1122/info/ttmesg.log -id 1000002 -facility user
root     24328 24321  0 10:08 ?        00:00:00 /opt/TimesTen/tt1122/bin/timestensubd -verbose -userlog /opt/TimesTen/tt1122/info/tterrors.log -supportlog /opt/TimesTen/tt1122/info/ttmesg.log -id 1000003 -facility user
root     24330 24321  0 10:08 ?        00:00:00 /opt/TimesTen/tt1122/bin/ttcserver -verbose -userlog /opt/TimesTen/tt1122/info/tterrors.log -supportlog /opt/TimesTen/tt1122/info/ttmesg.log -id 1000004 -p 53397 -facility user -group root
root     24412 20792  0 10:10 pts/1    00:00:00 grep Times

The installation itself was pretty easy aside from not quite sure if I should install this with root or grand a user to root.