ttIsql "DSN=ttwind;UID=cacheuser;PWD=cacheuser;OraclePWD=cacheuser;"

--1.查看当前版本

Command> version
TimesTen Release 11.2.2.7.0

Command> cachegroups;

Cache Group CACHEUSER.CACHETBLORDERS:

Cache Group Type: Read Only
Autorefresh: Yes
Autorefresh Mode: Incremental
Autorefresh State: On
Autorefresh Interval: 10 Seconds
Autorefresh Status: ok
Aging: No aging defined

Root Table: SCOTT.TBLORDERS
Table Type: Read Only

?

Command> select count(*) from scott.tblorders;
< 111001 >

?

--2.断开到TT的所有连接

?

--3.备份数据库以及配置文件

mkdir /backup

ttBackup -type fileFull -dir /backup -fname ttwindbk -force -connstr "DSN=ttwind"

cp /data/app/timesten/TimesTen/ttwind/info/sys.odbc.ini /backup/

cp /data/app/timesten/TimesTen/ttwind/tnsnames.ora /backup/

?

--4.删除cachegroup

ttIsql "DSN=ttwind;UID=cacheuser;PWD=cacheuser;OraclePWD=cacheuser;"

call ttcachestop;

DROP Cache Group cachetblorders;

exit;

--5.卸载内存

ttDaemonAdmin -stop

ttadmin -ramunload ttwind --二选一

--6.毁坏数据库

ttDestroy ttwind;

?

--7.删除旧目录 (可选)

rm -rf /etc/TimesTen/

rm -rf /data/app/timesten/

--7.install timesten new version

mkdir /etc/TimesTen

mkdir -p /data/app/timesten

chgrp -R ttadmin /etc/TimesTen

chgrp -R ttadmin /data/app/timesten

chmod 770 /etc/TimesTen/

chmod 770 /data/app/timesten

chmod 660 /etc/TimesTen/*

?

chown -R ocpyang.ttadmin /soft

ls /soft

unzip tt11.2.2.8.2\ .zip

cd /soft/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.

#步骤1：输入安装实例名称
Please choose an instance name for this installation? [ tt1122 ] ttwind #输入自定义的名字
Instance name will be 'ttwind'.
Is this correct? [ yes ] yes

#步骤2：安装组件
Of the three components:

[1] Client/Server and Data Manager
[2] Data Manager Only
[3] Client Only

Which would you like to install? [ 1 ] 1 #输入1

#步骤3：安装位置
Of the following options :

[1] /home/ocpyang
[2] /soft
[3] Specify a location
[q] Quit the installation

?

Where would you like to install the ttwind instance of TimesTen? [ 1 ] 3 #输入3 自定义一个安装目录
Please specify a directory to install TimesTen? [ /home/ocpyang ] /data/app/timesten/ #输入自定义一个安装目录
Where would you like to create the daemon home directory? [ /data/app/timesten/TimesTen/ttwind/info ]

The daemon logs will be located in /data/app/timesten/TimesTen/ttwind/info
Would you like to specify a different location for the daemon logs? [ no ]

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'.

#步骤4：输入自定义的主进程端口号

The default port number is 53396.

?

Do you want to use the default port number for the TimesTen daemon? [ yes ] no #输入no 自定义端口
Please enter a unique port number for the TimesTen daemon (=list)? [ ] 53355 #输入自定义端口