timesten客户端安装配置备忘
timesten客户端安装配置备忘
1、首先配置客户端的host表
这一步注意要在host表中即要添加服务端的主机名与ip对应，也要添加客户端自已的主机名与ip对应。本例假设为：
192.168.0.1 server.test.com
192.168.0.5 client.test.com
2、客户端timesten的安装
unzip p8606783_70510_Linux-x86-64.zip
cd linux8664
./setup.sh
Of the following two choices :
[1] 32-bit Linux for x86
[2] 64-bit Linux for AMD64 and Intel EM64T processors
Which platform are you currently running? [ 2 ] 按回车
3.在root 用户下安装 timesTen
./setup.sh
Please choose an instance name for this installation? [ tt70 ]
Instance name will be 'tt70'.
Is this correct? [ yes ]
Please select a product :
[1] Oracle TimesTen In-Memory Database
[2] Oracle In-Memory Database Cache
Which product would you like to install? [ 1 ] --默认就选 [1] 按回车
Of the three components:
[1] Client/Server and Data Manager
[2] Data Manager Only
[3] Client Only
Which would you like to install? [ 1 ] 3 --选 [3] 按回车
Where would you like to install the tt70 instance of TimesTen? [ /opt ] --路径用默认的按回车
Installing into /opt/TimesTen/tt70 ...
Creating /opt/TimesTen/tt70 ...
Uncompressing ...
Processing /opt/TimesTen/tt70/PERL/perl.tar ...
Installing client components ...
What is the name of the host running the TimesTen server? [ client ] server.test.com
What is the TCP/IP port number that the TimesTen server on server.test.com is listening on? [ 17003 ]
What is the name of the instance running the TimesTen server on server.test.com? [ tt70 ]
Creating new /var/TimesTen/sys.ttconnect.ini
Would you like to install the documentation? [ yes ] no
4. 在sys.odbc.ini 中加入下边的内容 vi /var/TimesTen/sys.odbc.ini
[ODBC Data Sources] 下增加
timesten=TimesTen 7.0 Driver
timestenCS=TimesTen 7.0 Client Driver
[timesten] ##这个名字一定要与服务器端的dsn一样
TTC_SERVER=server.test.com
TTC_SERVER_DSN=timesten ##这个名字一定要与服务器端的dsn一样
UID=userid
PWD=userpw
5. 文件追加
vi /etc/profile
export PATH=/opt/TimesTen/tt70/bin:$PATH
export CLASSPATH=/opt/TimesTen/tt70/lib:$CLASSPATH
source /etc/profile
6. ttisqlcs
Command> connect "dsn=timesten;uid=userid;pwd=userpw";
Connection successful: ....
网站地图
