环境:
OS:Centos 7
DB:22.1
1.下载软件包
2.解压到相应目录
我这里是解压到/opt/tt22.1.1.13.0目录
3.创建用户
groupadd -g 10000 timesten
useradd -u 55000 -g timesten instanceadmin
passwd instanceadmin
4.检查
[root@localhost tt22.1.1.13.0]# /opt/tt22.1.1.13.0/bin/ttInstallationCheck
This installation has been verified.
5.创建实例目录
mkdir -p /opt/tt22.1.1.13.0/instance_dir
chown -R instanceadmin:timesten /opt/tt22.1.1.13.0
6.创建实例
[root@localhost tt22.1.1.13.0]# /opt/tt22.1.1.13.0/bin/ttInstanceCreate -name instance1 -location /opt/tt22.1.1.13.0/instance_dir
ERROR: It is not allowed to install TimesTen as root.
Please refer to the installation guide for more information.
Aborting installation.
使用普通用户创建
[root@localhost opt]# su - instanceadmin
[instanceadmin@localhost opt]$ /opt/tt22.1.1.13.0/bin/ttInstanceCreate -name instance1 -location /opt/tt22.1.1.13.0/instance_dir
Creating instance in /opt/tt22.1.1.13.0/instance_dir/instance1 ...
NOTE: The TimesTen daemon startup/shutdown scripts have not been installed.
The startup script is located here :
'/opt/tt22.1.1.13.0/instance_dir/instance1/startup/tt_instance1'
Run the 'setuproot' script :
/opt/tt22.1.1.13.0/instance_dir/instance1/bin/setuproot -install
This will move the TimesTen startup script into its appropriate location.
The 22.1 Release Notes are located here :
'/opt/tt22.1.1.13.0/README.html'
Instance created successfully.
7.设置环境变量
[instanceadmin@localhost ~]$source /opt/tt22.1.1.13.0/instance_dir/instance1/bin/ttenv.sh
[instanceadmin@localhost ~]$ which ttVersion
/opt/tt22.1.1.13.0/instance_dir/instance1/bin/ttVersion
[instanceadmin@localhost ~]$ ttVersion
TimesTen Release 22.1.1.13.0 (64 bit Linux/x86_64) (instance1:6624) 2023-05-09T22:59:41Z
Instance admin: instanceadmin
Instance home directory: /opt/tt22.1.1.13.0/instance_dir/instance1
Group owner: timesten
Daemon home directory: /opt/tt22.1.1.13.0/instance_dir/instance1/info
PL/SQL enabled.
[instanceadmin@localhost ~]$ ttStatus
ttStatus: Could not connect to the TimesTen daemon on port 6624.
If the TimesTen daemon is not running, please start it
by running "ttDaemonAdmin -start".
8.启动ttDaemonAdmin
[instanceadmin@localhost ~]$ ttDaemonAdmin -start
TimesTen Daemon (PID: 11153, port: 6624) startup OK.
[instanceadmin@localhost ~]$ ttStatus
TimesTen status report as of Thu Jun 1 02:31:02 2023
Daemon pid 11153 port 6624 instance instance1
TimesTen server pid 11160 started on port 6625
------------------------------------------------------------------------
------------------------------------------------------------------------
Accessible by group timesten
End of report
9.修改配置文件
cd /opt/tt22.1.1.13.0/instance_dir/instance1/conf
vi sys.odbc.ini
[ODBC Data Sources]
sampledb=TimesTen 22.1 Driver
sampledbCS=TimesTen 22.1 Client Driver
[sampledb]
Driver=/opt/tt22.1.1.13.0/instance_dir/instance1/install/lib/libtten.so
DataStore=/databases/sampledb
PermSize=512
TempSize=128
LogBufMB=256
LogFileSize=256
LogDir=/logs
DatabaseCharacterSet=AL32UTF8
OracleNetServiceName=ttorcl
[sampledbCS]
TTC_SERVER=sampledb_CS
TTC_SERVER_DSN=sampledb
[instanceadmin@localhost conf]$ more sys.ttconnect.ini
# Copyright (c) 1999, 2015, Oracle and/or its affiliates. All rights reserved.
###############################################################
# This is a sample sys.ttconnect.ini file that is used for the
# TimesTen Client. It contains entries for each server.
###############################################################
[sampledb_CS]
Description=TimesTen Server
Network_Address=192.168.1.101
TCP_Port=6625
10.创建配置文件中指定的目录
mkdir /logs
mkdir /databases/sampledb
chown -R instanceadmin:timesten /logs
chown -R instanceadmin:timesten /databases
11.本地登录
cd /opt/tt22.1.1.13.0/instance_dir/instance1/bin
./ttisql # 本地访问客户端
connect "dsn=sampledb"; # 连接dsn,若不指定userid的话会默认使用timesten.conf定义的用户admin_user=instanceadmin
create user hxl identified by 'oracle';
grant all to hxl;
tables;
procedures;
建表:
SQL> CREATE TABLE readtab (a NUMBER NOT NULL PRIMARY KEY,b VARCHAR2(31));
SQL> INSERT INTO readtab VALUES (1, 'hello');
SQL> INSERT INTO readtab VALUES (2, 'world');
SQL> COMMIT;
11.远程登录
cd /opt/tt22.1.1.13.0/instance_dir/instance1/bin
./ttIsqlCS # 远程访问客户端
connect "dsn=sampledbCS;uid=hxl;pwd=oracle";
Command> connect "dsn=sampledbCS;uid=hxl;pwd=oracle";
Connection successful: DSN=sampledbCS;TTC_SERVER=sampledb_CS;TTC_SERVER_DSN=sampledb;UID=hxl;DATASTORE=/databases/sampledb;DATABASECHARACTERSET=AL32UTF8;CONNECTIONCHARACTERSET=US7ASCII;LOGFILESIZE=256;LOGBUFMB=256;LOGDIR=/logs;PERMSIZE=512;TEMPSIZE=128;ORACLENETSERVICENAME=ttorcl;
(Default setting AutoCommit=1)
12.日常维护
停止/启动 timesten
su - instanceadmin
ttDaemonAdmin -stop
ttDaemonAdmin -start
查看状态
source /opt/tt22.1.1.13.0/instance_dir/instance1/bin/ttenv.sh
ttstatus