Timesten 11.2.2.7.4 OEL x86 64位安裝手冊(cè)(外部).doc

Timsten 11.2.2.7.4 OEL6.5 x86 64位版本安裝手冊(cè) 提交人:薛傲提交日期:2015-01-06版本號(hào):v1.0 文檔控制 變更記錄日期作者版本號(hào)變更參考文件2014-01-06薛傲V1.02014-01-09薛傲V1.1添加了Huge Pages的設(shè)置方法 審閱日期姓名職位目錄1概述11.1目的11.1規(guī)劃的目標(biāo)11.2預(yù)期的讀者和閱讀建議12安裝環(huán)境部署22.1內(nèi)核參數(shù)修改22.3用戶以及用戶組建立22.4Huge Pages設(shè)置22.5介質(zhì)安裝前的文件授權(quán)32.6環(huán)境變量設(shè)置32.7介質(zhì)安裝43創(chuàng)建Timesten數(shù)據(jù)庫(kù)73.1配置sys.odbc.ini參數(shù)文件73.2創(chuàng)建和啟動(dòng)數(shù)據(jù)庫(kù)9- II -1 概述1.1 目的本文檔詳細(xì)描述Timesten 11.2.2.7.4版本在Oracle Enterprise Linux 6.5 x86 64位版本上安裝步驟，使相關(guān)人員可以根據(jù)本文檔進(jìn)行獨(dú)立安裝Timsten數(shù)據(jù)庫(kù)軟件。1.1 規(guī)劃的目標(biāo)相關(guān)人員根據(jù)本文檔可以獨(dú)立正確完成Timesten 11.2.2.7.4數(shù)據(jù)庫(kù)軟件在Oracle Enterprise Linux 6.5 x86 64位系統(tǒng)上的安裝1.2 預(yù)期的讀者和閱讀建議公司Oracle DBA、公司SA相關(guān)讀者應(yīng)對(duì)Red Hat相關(guān)軟件包安裝熟悉。2 安裝環(huán)境部署2.1 內(nèi)核參數(shù)修改使用root用戶進(jìn)行如下修改：# 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是你所需要使用內(nèi)存的最大值，根據(jù)Timesten：PERMSIZE+TEMPSIZE+LOGBUFMB+64MB來(lái)進(jìn)行計(jì)算。kernel.shmall是shmmax/page_size所計(jì)算出來(lái)的最小值。（默認(rèn)的page_size=4096）kernel.sem的第一個(gè)參數(shù)是最大的信號(hào)數(shù)（Timesten自身會(huì)需要155個(gè)，如果你需要你的連接很多，則需要增大這個(gè)參數(shù)）。最后一個(gè)參數(shù)是最小信號(hào)數(shù)，默認(rèn)128。注：修改后使用sysctl p使參數(shù)生效122.12.22.3 用戶以及用戶組建立使用root用戶進(jìn)行以下操作：# 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設(shè)置使用root用戶進(jìn)行以下操作：# id -g timesten500# vi /etc/sysctl.confvm.nr_hugepages = 51200vm.hugetlb_shm_group = 500# sysctl -p在sysctl.conf中添加標(biāo)紅的參數(shù)后，執(zhí)行sysctl p使修改生效。上面操作完成后可以使用cat /proc/meminfo來(lái)驗(yàn)證修改。注：vm.nr_hugepages：是通過(guò)Timesten的shared memory size來(lái)計(jì)算的。vm.hugetlb_shm_group：是通過(guò)命令id g 組名查詢所獲得的。設(shè)置memlock參數(shù)。# vi /etc/security/limits.conftimesten soft memlock 104857600timesten hard memlock 104857600在limits.conf添加標(biāo)紅的參數(shù)，此修改需要重啟或者登出再登入用戶才生效。下面操作請(qǐng)?jiān)赥imesten安裝完成后用timesten用戶進(jìn)行操作：$ vi /oradata/ttdata/ttendaemon.options-linuxLargePageAlignment 2$ ttdaemonadmin -stop$ ttdaemonadmin start$ ttstatusShared Memory KEY 0x1c02000e ID 163845 (LARGE PAGES, LOCKED)通過(guò)在ttendaemon.options中添加第一個(gè)所標(biāo)紅的參數(shù)后，重啟Timesten主進(jìn)程使其生效。可通過(guò)ttstatus驗(yàn)證修改成功與否。2.42.5 介質(zhì)安裝前的文件授權(quán)使用root用戶進(jìn)行以下操作：# 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安裝前若不作此操作，在安裝過(guò)程中也會(huì)提示讓你去創(chuàng)建/etc/TimesTen，另外的文件目錄則為安裝規(guī)范，安裝的時(shí)候指定安裝到該目錄下。2.6 環(huán)境變量設(shè)置使用timesten用戶進(jìn)行以下操作：$ 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讓參數(shù)生效。2.7 介質(zhì)安裝使用root用戶上傳介質(zhì)到/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然后對(duì)解壓后的目錄進(jìn)行授權(quán)# chown -R timesten:timesten linux8664/隨后使用timesten用戶進(jìn)入目錄運(yùn)行setup.sh進(jìn)行安裝# 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的實(shí)例名，這里需要注意的是Timesten的實(shí)例名和oracle的實(shí)例名并不一樣，在Timesten中一個(gè)Timesten軟件只能有一個(gè)實(shí)例名。如果想要在一臺(tái)機(jī)器上創(chuàng)建多個(gè)實(shí)例則需要安裝多個(gè)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 .根據(jù)安裝規(guī)范，我們需要將Timesten指定到我們所創(chuàng)建的目錄路徑下。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 為T(mén)imesten建立監(jiān)聽(tīng)端口和選擇用戶組，這里默認(rèn)為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的時(shí)候timesten需要通過(guò)tns_admin來(lái)識(shí)別connect的ORACLE地址，由于timesten的tnsname.ora和oracle的通用，所以我們這里選擇跳過(guò)，等裝完后將ORACLE的TNSNAME.ORA復(fù)制過(guò)來(lái)即可。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 .這個(gè)DemoDataStore目錄就Timesten存放模板數(shù)據(jù)庫(kù)的ckpt文件以及l(fā)og文件的地方，我們指定它到之前創(chuàng)建的路徑上。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，按默認(rèn)值no回車，然后使用root用戶運(yùn)行所提示的腳本，這樣就完成安裝了。3 創(chuàng)建Timesten數(shù)據(jù)庫(kù)3.1 配置sys.odbc.ini參數(shù)文件使用timesten用戶進(jìn)行以下操作：$ 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數(shù)據(jù)源處添加你所需要建立的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配置文件中添加相應(yīng)dsn名稱的配置參數(shù)：Driver的參數(shù)可以直接