Oracle TimesTen - WindyHana's Solanara




타임스텐을 설치할 timesten계정을 만들고 설정을 저장할 디렉토리를 만든다.
root@wl ~ # ndd -set /dev/tcp tcp_xmit_hiwat 524288
root@wl ~ # ndd -set /dev/tcp tcp_recv_hiwat 524288
root@wl ~ # projadd -p 101 -c "Resources for Oracle" group.dba
root@wl ~ # projmod -sK "project.max-shm-memory=(privileged,4G,deny)" group.dba
root@wl ~ # projmod -sK "project.max-sem-ids=(privileged,100,deny)" group.dba
root@wl ~ # projmod -sK "project.max-shm-ids=(privileged,100,deny)" group.dba
root@wl ~ # projmod -sK "project.max-sem-nsems=(privileged,256,deny)" group.dba
root@wl ~ # projmod -sK "process.max-file-descriptor=(priv,65536,deny)" group.dba
root@wl ~ # projects -l group.dba 1)
        projid : 101
        comment: "Resources for Oracle"
        users  : (none)
        groups : (none)
        attribs: process.max-file-descriptor=(priv,65536,deny)
root@wl ~ # groupadd -g 207 timesten
root@wl ~ # groupadd -g 208 ttadmin
root@wl ~ # useradd -d /export/home/timesten -g timesten -G ttadmin -m -u 204 -s /bin/bash -K project=group.dba timesten
root@wl ~ # mkdir /etc/TimesTen
root@wl ~ # touch /etc/TimesTen/instance_info
root@wl ~ # chgrp -R ttadmin /etc/TimesTen
root@wl ~ # chmod 770 /etc/TimesTen/
root@wl ~ # chmod 660 /etc/TimesTen/*
root@wl ~ # vi ~timesten/.profile
PATH=/export/home/timesten/TimesTen/tt1121/bin:/export/home/timesten/TimesTen/tt1121/ttoracle_home/instantclient_10_2:$PATH; export PATH;
LD_LIBRARY_PATH=/export/home/timesten/TimesTen/tt1121/lib:/export/home/timesten/TimesTen/tt1121/ttoracle_home/instantclient_10_2:$LD_LIBRARY_PATH; export LD_LIBRARY_PATH;
1) 이 설정은 윈디하나의 솔라나라: Oracle 11g R2, Grid Infrastructure - 오라클 계정에 나와있는 오라클 계정 설정과 동일하다. 따라서 타임스텐에는 필요 없는 설정도 포함되어있다.


Oracle TimesTen Downloads에서 타임스텐 설치파일을 받은 후, 아래와 같이 설치한다.
timesten@wl ~/src # tar xvfz timesten112180.solx8664.tar.gz
timesten@wl ~/src # cd solx8664
timesten@wl ~/src/solx8664 # ./

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? [ tt1121 ]
Instance name will be 'tt1121'.
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/home/timesten
  [2] /export/home/timesten/src
  [3] Specify a location
  [q] Quit the installation

Where would you like to install the tt1121 instance of TimesTen? [ 1 ]
Where would you like to create the daemon home directory? [ /export/home/timesten/TimesTen/tt1121/info ]

The daemon logs will be located in /export/home/timesten/TimesTen/tt1121/info
Would you like to specify a different location for the daemon logs? [ no ]
Installing into /export/home/timesten/TimesTen/tt1121 ...
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 53388.

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

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 'timesten'? [ 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)? [  ] s

Installing server components ...
What is the TCP/IP port number that you want the TimesTen Server to listen on? [ 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)? [ /export/home/timesten/TimesTen/tt1121/doc ]
The TimesTen documentation has been installed in /export/home/timesten/TimesTen/tt1121/doc.
Installing client components ...

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

Run the 'setuproot' script :
        cd /export/home/timesten/TimesTen/tt1121/bin
        ./setuproot -install
This will move the TimesTen startup script into its appropriate location.

The startup script is currently located here :

The Release Notes are located here :

Starting the daemon ...
TimesTen Daemon startup OK.
End of TimesTen installation.
timesten@wl ~/src/solx8664 $
여기까지 하면 Times Ten은 설치되었다. 시스템이 재시작될 때 자동으로 설치되도록 하려면 아래와 같이 한다.
root@wl ~ # cd ~timesten/TimesTen/tt1121/bin
root@wl /export/home/timesten/TimesTen/tt1121/bin # ./setuproot -install
Would you like to install the TimesTen daemon startup scripts into /etc/init.d? [ yes ]
Copying /export/home/timesten/TimesTen/tt1121/startup/tt_tt1121 to /etc/init.d

Successfully installed the following scripts :

root@wl /export/home/timesten/TimesTen/tt1121/bin #