TimesTen 11.2 on linux 安装

官网下载安装包timesten112250.linux86.tar.gz
创建目录解压，开始安装
[code]mkdir /etc/TimesTen
chmod 775 /etc/TimesTen
chown oracle:dba /etc/TimesTen

mkdir /u01/TimesTen
chmod 775 /u01/TimesTen
chown oracle:dba /u01/TimesTen

[oracle@localhost TimesTen]$ cat ~/.bash_profile
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin
export ORACLE_BASE=/oracle
export ORACLE_HOME=/oracle/product/database
export PATH=$ORACLE_HOME/bin:/u01/TimesTen/tt11/bin:$PATH
export ORACLE_SID=orasql
export PATH
export CLASSPATH=/u01/TimesTen/tt11/lib/ttjdbc14.jar:$CLASSPATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/network/lib:/u01/TimesTen/tt11/lib

source ~/.bash_profile

[oracle@localhost TimesTen]$ tar zxvf timesten112250.linux86.tar.gz

[oracle@localhost TimesTen]$ cd linux86/
[oracle@localhost linux86]$ ls
3rdparty doc install.pl LINUX86 README.html setup.sh uninst.sh
[oracle@localhost linux86]$ ./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 ] tt11
Instance name will be 'tt11'.
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/oracle
[2] /u01/TimesTen
[3] Specify a location
[q] Quit the installation

Where would you like to install the tt11 instance of TimesTen? [ 1 ] 2
Where would you like to create the daemon home directory? [ /u01/TimesTen/tt11/info ]

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

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

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 'dba'? [ yes ]

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

Would you like to enable PL/SQL for this instance? [ yes ]
TNS_ADMIN was not set in your environment but there is a tnsnames.ora
file in /oracle/product/database/network/admin.
Would you like to use this TNS_ADMIN setting for the In-Memory Database Cache? [ yes ]

TNS_ADMIN will be set to /oracle/product/database/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? [ 53393 ] Do you want to install QuickStart and the TimesTen Documentation? [ no ] yes
Where would you like to install the quickstart and doc directories (s=skip)? [ /u01/TimesTen/tt11 ]

The TimesTen Quickstart applications can take up to 64 Mbytes of disk space.
Depending on how your system is configured, you may not want to create the
QuickStart DemoDataStore directory in the default location,
/u01/TimesTen/tt11/info/DemoDataStore

Where would you like to create the DemoDataStore directory? [ /u01/TimesTen/tt11/info ]
Creating /u01/TimesTen/tt11/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 /u01/TimesTen/tt11/bin
./setuproot -install
This will move the TimesTen startup script into its appropriate location.

The startup script is currently located here :
'/u01/TimesTen/tt11/startup/tt_tt11'.

The Quickstart home page can be accessed here :
'/u01/TimesTen/tt11/quickstart/index.html'

The 11.2.2.5 Release Notes are located here :
'/u01/TimesTen/tt11/README.html'

Starting the daemon ...
TimesTen Daemon startup OK.
End of TimesTen installation.[/code]
启动
[code][root@localhost ~]# cd /u01/TimesTen/tt11/bin
[root@localhost bin]# ./setuproot -install
Would you like to install the TimesTen daemon startup scripts into /etc/init.d? [ yes ]
Copying /u01/TimesTen/tt11/startup/tt_tt11 to /etc/init.d

Successfully installed the following scripts :
/etc/init.d/tt_tt11
/etc/rc.d/rc0.d/K45tt_tt11
/etc/rc.d/rc1.d/K45tt_tt11
/etc/rc.d/rc2.d/S90tt_tt11
/etc/rc.d/rc3.d/S90tt_tt11
/etc/rc.d/rc5.d/S90tt_tt11
/etc/rc.d/rc6.d/K45tt_tt11


[root@localhost bin]# ps -ef |grep times
oracle 13205 1 0 13:38 ? 00:00:00 /u01/TimesTen/tt11/bin/timestend -initfd 13
oracle 13209 13205 0 13:38 ? 00:00:00 /u01/TimesTen/tt11/bin/timestensubd -verbose -userlog tterrors.log -supportlog ttmesg.log -id 1000000 -facility user
oracle 13210 13205 0 13:38 ? 00:00:00 /u01/TimesTen/tt11/bin/timestensubd -verbose -userlog tterrors.log -supportlog ttmesg.log -id 1000001 -facility user
oracle 13211 13205 0 13:38 ? 00:00:00 /u01/TimesTen/tt11/bin/timestensubd -verbose -userlog tterrors.log -supportlog ttmesg.log -id 1000002 -facility user
oracle 13212 13205 0 13:38 ? 00:00:00 /u01/TimesTen/tt11/bin/timestensubd -verbose -userlog tterrors.log -supportlog ttmesg.log -id 1000003 -facility user
root 13308 13264 0 13:44 pts/2 00:00:00 grep times[/code]
简单测试：
DNS在sys.odbc.ini文件中
[code][oracle@localhost info]$ cat sys.odbc.ini

[ODBC Data Sources]
TT_1122=TimesTen 11.2.2 Driver
sampledb_1122=TimesTen 11.2.2 Driver
cachedb1_1122=TimesTen 11.2.2 Driver
repdb1_1122=TimesTen 11.2.2 Driver
repdb2_1122=TimesTen 11.2.2 Driver
sampledbCS_1122=TimesTen 11.2.2 Client Driver
cachedb1CS_1122=TimesTen 11.2.2 Client Driver

[oracle@localhost info]$ ttIsql TT_1122

Copyright (c) 1996, 2013, Oracle and/or its affiliates. All rights reserved.
Type ? or "help" for help, type "exit" to quit ttIsql.



connect "DSN=TT_1122";
Connection successful: DSN=TT_1122;UID=oracle;DataStore=/u01/TimesTen/tt11/info/TT_1122;DatabaseCharacterSet=US7ASCII;ConnectionCharacterSet=US7ASCII;DRIVER=/u01/TimesTen/tt11/lib/libtten.so;TypeMode=0;
(Default setting AutoCommit=1)
Command> tables
0 tables found.
Command> create table tt_test(id number(20));
Command> insert into tt_test values(12323456);
1 row inserted.
Command> commit;
Command> select * from tt_test;
< 12323456 >
1 row found.
Command> drop table tt_test;


[oracle@localhost info]$ ls -l
total 243696
-rw-r----- 1 oracle dba 3262 Aug 21 13:38 cluster.oracle.ini
-rw------- 1 oracle dba 3488 Aug 21 14:15 DBI52145ad7.0
drwxrwx--- 2 oracle dba 4096 Aug 21 13:38 DemoDataStore
-rw-rw---- 1 oracle dba 10178 Aug 21 13:38 sys.odbc.ini
-rw-rw---- 1 oracle dba 420 Aug 21 13:38 sys.ttconnect.ini
-rw-r--r-- 1 oracle dba 6 Aug 21 13:38 timestend.pid
-rw-rw---- 1 oracle dba 15493536 Aug 21 14:15 TT_1122.ds0
-rw-rw---- 1 oracle dba 20426752 Aug 21 14:15 TT_1122.ds1
-rw-rw---- 1 oracle dba 11900928 Aug 21 14:17 TT_1122.log0
-rw-rw---- 1 oracle dba 67108864 Aug 21 14:14 TT_1122.res0
-rw-rw---- 1 oracle dba 67108864 Aug 21 14:14 TT_1122.res1
-rw-rw---- 1 oracle dba 67108864 Aug 21 14:14 TT_1122.res2
-rw-r----- 1 oracle dba 308 Aug 21 13:37 ttendaemon.options
-rw------- 1 oracle dba 79 Aug 21 13:38 tterrors.log
-rw------- 1 oracle dba 52921 Aug 21 14:15 ttmesg.log[/code]