Timesten 11.2.2.7.4 OEL x86 64位安装手册(外部).doc

Timsten 11.2.2.7.4 OEL6.5 x86 64位版本安装手册 提交人:薛傲提交日期:2015-01-06版本号:v1.0 文档控制 变更记录日期作者版本号变更参考文件2014-01-06薛傲V1.02014-01-09薛傲V1.1添加了Huge Pages的设置方法 审阅日期姓名职位目录1概述11.1目的11.1规划的目标11.2预期的读者和阅读建议12安装环境部署22.1内核参数修改22.3用户以及用户组建立22.4Huge Pages设置22.5介质安装前的文件授权32.6环境变量设置32.7介质安装43创建Timesten数据库73.1配置sys.odbc.ini参数文件73.2创建和启动数据库9- II -1 概述1.1 目的本文档详细描述Timesten 11.2.2.7.4版本在Oracle Enterprise Linux 6.5 x86 64位版本上安装步骤，使相关人员可以根据本文档进行独立安装Timsten数据库软件。1.1 规划的目标相关人员根据本文档可以独立正确完成Timesten 11.2.2.7.4数据库软件在Oracle Enterprise Linux 6.5 x86 64位系统上的安装1.2 预期的读者和阅读建议公司Oracle DBA、公司SA相关读者应对Red Hat相关软件包安装熟悉。2 安装环境部署2.1 内核参数修改使用root用户进行如下修改：# vi /etc/sysctl.conf# Controls the maximum shared segment size, in byteskernel.shmmax =107374182400# Controls the maximum number of shared memory segments, in pageskernel.shmall=26214400kernel.sem=350 32000 100 128kernel.shmmax是你所需要使用内存的最大值，根据Timesten：PERMSIZE+TEMPSIZE+LOGBUFMB+64MB来进行计算。kernel.shmall是shmmax/page_size所计算出来的最小值。（默认的page_size=4096）kernel.sem的第一个参数是最大的信号数（Timesten自身会需要155个，如果你需要你的连接很多，则需要增大这个参数）。最后一个参数是最小信号数，默认128。注：修改后使用sysctl p使参数生效122.12.22.3 用户以及用户组建立使用root用户进行以下操作：# groupadd timesten# useradd timesten g timesten G timesten# passwd timestenChanging password for user timesten.New password: BAD PASSWORD: it is based on a dictionary wordRetype new password: passwd: all authentication tokens updated successfully.2.22.32.4 Huge Pages设置使用root用户进行以下操作：# id -g timesten500# vi /etc/sysctl.confvm.nr_hugepages = 51200vm.hugetlb_shm_group = 500# sysctl -p在sysctl.conf中添加标红的参数后，执行sysctl p使修改生效。上面操作完成后可以使用cat /proc/meminfo来验证修改。注：vm.nr_hugepages：是通过Timesten的shared memory size来计算的。vm.hugetlb_shm_group：是通过命令id g 组名查询所获得的。设置memlock参数。# vi /etc/security/limits.conftimesten soft memlock 104857600timesten hard memlock 104857600在limits.conf添加标红的参数，此修改需要重启或者登出再登入用户才生效。下面操作请在Timesten安装完成后用timesten用户进行操作：$ vi /oradata/ttdata/ttendaemon.options-linuxLargePageAlignment 2$ ttdaemonadmin -stop$ ttdaemonadmin start$ ttstatusShared Memory KEY 0x1c02000e ID 163845 (LARGE PAGES, LOCKED)通过在ttendaemon.options中添加第一个所标红的参数后，重启Timesten主进程使其生效。可通过ttstatus验证修改成功与否。2.42.5 介质安装前的文件授权使用root用户进行以下操作：# mkdir /etc/TimesTen# chgrp R timesten /etc/TimesTen# chmod 775 /etc/Timesten/# chmod 660 /etc/TimesTen/*# mkdir /oradata/ttdata/ttlog# chown R timesten:timesten /opt/ttdata安装前若不作此操作，在安装过程中也会提示让你去创建/etc/TimesTen，另外的文件目录则为安装规范，安装的时候指定安装到该目录下。2.6 环境变量设置使用timesten用户进行以下操作：$ cd$ vi .bash_profileexportCLASSPATH=/opt/Timesten/TimesTen/zpcache/lib/ttjdbc14.jar:$CLASSPATHexportPATH=/opt/Timesten/TimesTen/zpcache/bin:$PATHexportLD_LIBRARY_PATH=/opt/Timesten/TimesTen/zpcache/lib:$LD_LIBRARY_PATH改完后使用source .bash_profile或者./.bash_profile让参数生效。2.7 介质安装使用root用户上传介质到/opt下，并解压。# tar zxvf timesten112274.linux8664.gz linux8664/linux8664/uninst.shlinux8664/install.pllinux8664/README.htmllinux8664/LINUX8664/linux8664/LINUX8664/ttpatchinstlinux8664/LINUX8664/unziplinux8664/LINUX8664/common.tar.bz2linux8664/LINUX8664/ttclient.tar.bz2linux8664/LINUX8664/perllinux8664/LINUX8664/manifestlinux8664/LINUX8664/timesten.tar.bz2linux8664/LINUX8664/bzip2linux8664/LINUX8664/ttserver.tar.bz2linux8664/3rdparty/linux8664/3rdparty/ant-1.6.2-bin.tar.bz2linux8664/3rdparty/jms-1_1-fr-apidocs.tar.bz2linux8664/doc/linux8664/doc/doc.ziplinux8664/setup.sh然后对解压后的目录进行授权# chown -R timesten:timesten linux8664/随后使用timesten用户进入目录运行setup.sh进行安装# su timesten$ cd /opt/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.Please choose an instance name for this installation? tt1122 zpcacheInstance name will be zpcache. Is this correct? yes 此处输入你的Timesten的实例名，这里需要注意的是Timesten的实例名和oracle的实例名并不一样，在Timesten中一个Timesten软件只能有一个实例名。如果想要在一台机器上创建多个实例则需要安装多个Timesten软件。Of the three components: 1 Client/Server and Data Manager 2 Data Manager Only 3 Client OnlyWhich would you like to install? 1 选择你需要安装的Timesten，在这里我们的是安装Server端，故选1。Of the following options : 1 /home/timesten 2 /opt 3 Specify a location q Quit the installationWhere would you like to install the zpcache instance of TimesTen? 1 3Please specify a directory to install TimesTen? /home/timesten /opt/TimestenWhere would you like to create the daemon home directory? /u01/Timesten/TimesTen/zpcache/info /oradata/ttdata/zpcacheThe daemon logs will be located in /oradata/ttdata/zpcacheWould you like to specify a different location for the daemon logs? no Installing into /opt/Timesten/TimesTen/zpcache .Creating /opt/Timesten/TimesTen/zpcache .Uncompressing .根据安装规范，我们需要将Timesten指定到我们所创建的目录路径下。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 53396.Do you want to use the default port number for the TimesTen daemon? yes The daemon will run on the default port number (53396).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 timesten? yes 为Timesten建立监听端口和选择用户组，这里默认为timesten用户组。NOTE: Enabling PL/SQL will increase the size of some TimesTen libraries.Would you like to enable PL/SQL for this instance? yes 选择是否启用PL/SQL，我们选择YES。In order to use the Oracle TimesTen Application-Tier Database Cache feature in any databasescreated within this installation, you must set a value for the TNS_ADMINenvironment variable. It can be left blank, and a value can be supplied laterusing /bin/ttModInstall.Please enter a value for TNS_ADMIN (s=skip)? s这里是在Cache connect to oracle的时候timesten需要通过tns_admin来识别connect的ORACLE地址，由于timesten的tnsname.ora和oracle的通用，所以我们这里选择跳过，等装完后将ORACLE的TNSNAME.ORA复制过来即可。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 /lib directory and to the 4.1.0 server binary in the /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? 53397 Do you want to install the Quick Start Sample Programs and the TimesTen Documentation? no Where would you like to create the DemoDataStore directory? /oradata/ttdata/ Creating /oradata/ttdata/DemoDataStore .这个DemoDataStore目录就Timesten存放模板数据库的ckpt文件以及log文件的地方，我们指定它到之前创建的路径上。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 /opt/Timesten/TimesTen/zpcache/bin ./setuproot -installThis will move the TimesTen startup script into its appropriate location.Starting the daemon .TimesTen Daemon startup OK.End of TimesTen installation.不使用Oracle Clusterware，按默认值no回车，然后使用root用户运行所提示的脚本，这样就完成安装了。3 创建Timesten数据库3.1 配置sys.odbc.ini参数文件使用timesten用户进行以下操作：$ cd /oradata/ttdata$ vi sys.odbc.iniODBC Data Sourceszpcache= TimesTen 11.2.2 DriverTT_1122=TimesTen 11.2.2 Driversampledb_1122=TimesTen 11.2.2 Drivercachedb1_1122=TimesTen 11.2.2 Driverrepdb1_1122=TimesTen 11.2.2 Driver在ODBC数据源处添加你所需要建立的Timesten的dsn名称，如红字所示。zpcacheDriver=/opt/Timesten/TimesTen/zpcache/lib/libtten.soDataStore=/oradata/ttdata/zpcache/zpcacheLogDir=/oradata/ttdata/ttlog/zpcachePermSize=92000TempSize=9200PLSQL=1ConnectionCharacterSet=WE8ISO8859P1DatabaseCharacterSet=WE8ISO8859P1#OracleNetServiceName=ogg1#OracleId=ogg1在/oradata/ttdata/sys.odbc.ini配置文件中添加相应dsn名称的配置参数：Driver的参数可以直接