TimesTen高可用性Word格式文档下载.docx

1、后即陆续介绍如何安装，如何配置data store,如何配置 cache group连接到 oracle，如何配置复制，实现高可用性timesten系列二：如何安装timesten发表人:wzy25 | 发表时间: 2008年八月07日, 16:53imesten支持在linux,unix,windows上面运行，最新的版本是 7.0.5 ，下面我们将以在oracle enterprise linux 5.0 上面为例说明如何安装 timesten，真的很简单，比装oracle简单安装目录 /oracle/timesten操作系统版本 oracle enterprise linux 5.0 3

2、2bit需要把SELINUX关闭timesten instance名字为tt701.修改内核参数修改/etc/sysctl.conf文件，加上如下列kernel.shmmax=2147483648kernel.sem = 250 32000 128 100net.ipv4.tcp_rmem=4096 4194304 4194304net.ipv4.tcp_wmem=98304 4194304 4194304net.ipv4.tcp_mem=net.core.rmem_default=65535net.core.wmem_default=65535net.core.rmem_max=419430

3、4net.core.wmem_max=4194304net.ipv4.tcp_window_scaling=1net.ipv4.ip_local_port_range=1024 65000然后执行 sysctl -p ，使修改生效2.为了能够连接到oracle做同步，请安装oracle 10.2的客户端oracle以oracle用户,dba组安装 3.添加用户useradd -g dba -u 505 timesten4.用root用户登陆os然后执行下面的操作，为timesten保存安装信息用mkdir /etc/TimesTenchmod 775 /etc/TimesTenchgrp ti

4、mesten /etc/TimesTen5.设置用户.bash_profileexport CLASSPATH=/oracle/timesten/TimesTen/tt70/lib/ttjdbc14.jar:$CLASSPATHexport PATH=/oracle/timesten/TimesTen/tt70/bin:$PATHexport ORACLE_HOME=/oracle/product/10.2.0/db_1export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/network/lib:/oracle/timesten/TimesT

5、en/tt70/lib:$LD_LIBRARY_PATH注意：LD_LIBRARY_PATH 一定要包含上面的几个目录，否则cache 会出问题下载地址 ： . 0500.linux86.tar.gz然后 解开 timesten安装包 tar xvzf timesten70500.linux86.tar.tarcd linux86/./setup.sh 后面会提示输入路径，名称，端口等，一路回车，就ok了，具体的安装提示，请看下面：NOTE: Each TimesTen installation is identified by a unique instance name.The insta

6、nce name must be a non-null alphanumeric string, not longerthan 255 characters.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 Database2 Oracle In-Memory Database CacheWhich product would

7、you like to install? 1 Of the three components:1 Client/Server and Data Manager2 Data Manager Only3 Client OnlyWhich would you like to install?Where would you like to install the tt70 instance of TimesTen? /home/timesten /oracle/timestenThe directory /oracle/timesten does not exist.Do you want to cr

8、eate it?Where would you like to create the daemon home directory? /oracle/timesten/TimesTen/tt70/info The directory /oracle/timesten/TimesTen/tt70/info does not exist.Installing into /oracle/timesten/TimesTen/tt70 .Uncompressing .The TimesTen Demo applications can take up to 64 Mbytes of disk space.

9、Depending on how your system is configured, you may not want to create theDemoDataStore directory in the default location,/oracle/timesten/TimesTen/tt70/info/DemoDataStoreWhere would you like to create the DemoDataStore directory?Creating /oracle/timesten/TimesTen/tt70/info/DemoDataStore . All insta

10、llations that replicate to each other must use the same daemonport number that is set at installation time. The daemon port number canbe verified by running ttVersionThe default port number is 17000.Do you want to use the default port number for the TimesTen daemon?The daemon will run on the default

11、 port number （17000）.Processing /oracle/timesten/TimesTen/tt70/PERL/perl.tar .Would you like to enable datastore access control? no The daemon logs will be located in /oracle/timesten/TimesTen/tt70/infoWould you like to specify a different location for the daemon logs? It appears that you are runnin

12、g version 4.1 of the g+compiler. TimesTen ships with multiple sets of client libraries and serverbinaries : one built with g+ 3.2.3, one with g+ 3.4.6, and one withg+ 4.1.0. The installer has created links to the 4.1.0 library in the/lib directory and to the 4.1.0 server binary in the/bin directory.

13、 If you want to use a different compiler,please modify the links to point to the desired library and server binary.Installing server components .Would you like to log all server Connects/Disconnects?What is the TCP/IP port number that you want the TimesTen Server to listen on? 17002 Starting the dae

14、mon .TimesTen Daemon startup OK.Installing client components .What is the name of the host running the TimesTen server? rac01 What is the TCP/IP port number that the TimesTen server is listening on?What is the name of the instance running the TimesTen server?Creating new /oracle/timesten/TimesTen/tt

15、70/info/sys.ttconnect.iniExtracting 3rd party tools .Would you like to install the documentation? yes noDocumentation not installed.To manually install the documentation, run the command setup.sh -installDoc The TimesTen daemon startup/shutdown scripts have not been installed.Run the script /oracle/

16、timesten/TimesTen/tt70/bin/setuproot as root.This will move the TimesTen startup script into its appropriate location.The startup script is currently located here :/oracle/timesten/TimesTen/tt70/startup/tt_tt70End of TimesTen installation.为了添加随着OS启动而启动timesten daemon的脚本，需要按照提示，用root用户执行下面的脚本：/oracle

17、/timesten/TimesTen/tt70/bin/setuproot很简单，就完成了安装了，看看timesten启动之后的进程情况：ps -ef |grep timestentimesten 2200 1 0 18:45 ? 00:00:00 /oracle/timesten/TimesTen/tt70/bin/timestend -initfd 13timesten 2203 2200 0 18:00 /oracle/timesten/TimesTen/tt70/bin/timestensubd timesten 2204 2200 0 18:timesten 2205 2200 0

18、18:timesten 2206 2200 0 18:timesten 2208 2200 0 18:00 /oracle/timesten/TimesTen/tt70/bin/ttcserver系统安装完成之后，会有一个缺省的data store（这个概念和oracle的schema概念差不多）,叫 TpcbData_tt70 我们现在就连接到这个data store来看看，看看timesten工作是否正常。ttIsql TpcbData_tt70 （注释：ttIsql 是一个和oracle sqlplus差不多的命令行交互控制工具）timestenrac01 info$ ttIsql Tp

19、cbData_tt70Copyright （c） 1996-2008, Oracle. All rights reserved.Type ? or help for help, type exit to quit ttIsql.All commands must end with a semicolon character.connect DSN=TpcbData_tt70;Connection successful: DSN=TpcbData_tt70;UID=timesten;DataStore=/oracle/timesten/TimesTen/tt70/info/DemoDataSto

20、re/TpcbData;DatabaseCharacterSet=US7ASCII;ConnectionCharacterSet=US7ASCII;WaitForConnect=0;DRIVER=/oracle/timesten/TimesTen/tt70/lib/libtten.so;Authenticate=0;PermSize=16;TypeMode=0;（Default setting AutoCommit=1）Command tables;SYS.CACHE_GROUPSYS.COLUMNSSYS.COLUMN_HISTORYSYS.COL_STATSSYS.DUALSYS.INDE

21、XESSYS.MONITORSYS.OBJ_ACC_RIGHTSYS.PLANSYS.SEQUENCESSYS.SYNONYMSSYS.SYS_ACC_RIGHTSYS.TABLESSYS.TABLE_HISTORYSYS.TBL_STATSSYS.TCOL_STATSSYS.TINDEXESSYS.TRANSACTION_LOG_APISYS.TTABLESSYS.TTBL_STATSSYS.USERSSYS.VIEWSSYS.XLASUBSCRIPTIONSTTREP.REPELEMENTSTTREP.REPLICATIONSTTREP.REPNETWORKTTREP.REPPEERSTT

22、REP.REPSTORESTTREP.REPSUBSCRIPTIONSTTREP.REPTABLESTTREP.TTSTORES31 tables found.在来做一个创建表的测试 create table test（id number（2）; insert into test values（1）;1 row inserted. commit; select * from test; 1 1 row found.TT的语法和oracle几乎是一样的，特别是dml和ddl，所以，如果有oracle的基础，就很容易了。ok，TT工作正常，安装顺利结束。如何启动停止timesten呢？（以后就简称

23、timesten为TT）启动TT ttDaemonAdmin -start停止TTttDaemonAdmin -stopTT的所有配置文件都放在 install_dir/info目录下TT产生的日志也都在 install_dir/infotimesten系列三：如何安装创建自己的data store 2008年八月12日, 16:55在完成上面的安装任务之后，因为我们需要TT存放我们应用的数据，我们就要配置自己的data store了（理解为oracle里面的schema）。在做这个任务之前，需要厘清一个概念，DSN=data source name ,这个是标准的ODBC的用语，用来描述一个

24、可以提供odbc连接的数据库服务器，在timesten里面，所有的连接都是通过odbc的，就算是jdbc也是通过odbc连接到到TT上的。在TT里面，有两种DSN1.系统一级的DSN定义在服务器端，定义该data store的文件存放位置，以及其他的一些控制参数，比如是否需要log，是否打开checkpoint等等。 2.客户端的DSN，用来描述一个远端服务器上的data store，客户端程序用来连接到服务器首先我们在刚才装好的TT服务器上定义个两个DSN，一个系统一级的，一个用户一级的打开 $INSTALL_DIR/info/sys.odbc.ini 在ODBC Data Sources

25、下面添加如下两行 ，定义我们这个data store需要的driverwzy_tt70=TimesTen 7.0 DriverwzyCS_tt70=TimesTen 7.0 Client Driver 然后在 该文件的最后，添加如下内容：#定义系统一级的DSN 的名字wzy_tt70#定义驱动Driver=/oracle/timesten/TimesTen/tt70/lib/libtten.so#定义文件存放位置，数据文件和log都是放在info/wzy目录下，以 wzy 为前缀开始的DataStore=/oracle/timesten/TimesTen/tt70/info/wzy/wzy#定义数据库的字符集DatabaseCharacterSet=WE8ISO8859P1#定义是否需要用户授权认证Authenticate=0#定义内存大小PermSize=64TempSize=16#定义用户一级的DSNwzyCS_tt70#服务器的地址TTC_SERVER=LocalHost_tt70#服务器data store的系统一级的DSN 名字，对应上面定义的 名字TTC_SERVER_DSN=wzy_tt70然后我们创建 wzy这个目录mkdir wzy