联系:手机/微信(+86 17813235971) QQ(107644445)
作者:惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
1.安装timesten
[oracle@bas 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 ] xifenfei Instance name will be 'xifenfei'. Is this correct? [ yes ] yes Of the three components: [1] Client/Server and Data Manager [2] Data Manager Only [3] Client Only Which would you like to install? [ 1 ] 1 Of the following options : [1] /home/oracle [2] /home/oracle/timesten [3] Specify a location [q] Quit the installation Where would you like to install the xifenfei instance of TimesTen? [ 1 ] 2 Where would you like to create the daemon home directory? [ /home/oracle/timesten/TimesTen/xifenfei/info ] The daemon logs will be located in /home/oracle/timesten/TimesTen/xifenfei/info Would you like to specify a different location for the daemon logs? [ no ] Installing into /home/oracle/timesten/TimesTen/xifenfei ... Uncompressing ... 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 'oinstall'? [ yes ] yes NOTE: Enabling PL/SQL will increase the size of some TimesTen libraries. Would you like to enable PL/SQL for this instance? [ yes ] yes TNS_ADMIN was not set in your environment but there is a tnsnames.ora file in /opt/app/oracle/product/10.2.0/db_1/network/admin. Would you like to use this TNS_ADMIN setting for the In-Memory Database Cache? [ yes ] yes TNS_ADMIN will be set to /opt/app/oracle/product/10.2.0/db_1/network/admin You can change TNS_ADMIN later by running <install_dir>/bin/ttmodinstall. NOTE: It appears that you are running version 3.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 3.4.6 library in the <install_dir>/lib directory and to the 3.4.6 server binary in the <install_dir>/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 QuickStart and the TimesTen Documentation? [ no ] no Would you like to install the documentation (without QuickStart)? [ yes ] Where would you like to create the doc directory (s=skip)? [ /home/oracle/timesten/TimesTen/xifenfei/doc ] s Installing client components ... Would you like to use TimesTen Replication with Oracle Clusterware? [ no ] no NOTE: The TimesTen daemon startup/shutdown scripts have not been installed. Run the 'setuproot' script : cd /home/oracle/timesten/TimesTen/xifenfei/bin ./setuproot -install This will move the TimesTen startup script into its appropriate location. The startup script is currently located here : '/home/oracle/timesten/TimesTen/xifenfei/startup/tt_xifenfei'. The documentation was not installed. To manually install the documentation, run the command 'setup.sh -installDoc' The 11.2.2.2 Release Notes are located here : '/home/oracle/timesten/TimesTen/xifenfei/README.html' Starting the daemon ... TimesTen Daemon startup OK. End of TimesTen installation. --设置开机启动 [root@bas linux8664]# cd /home/oracle/timesten/TimesTen/xifenfei/bin/ [root@bas bin]# ./setuproot -install Would you like to install the TimesTen daemon startup scripts into /etc/init.d? [ yes ] yes Copying /home/oracle/timesten/TimesTen/xifenfei/startup/tt_xifenfei to /etc/init.d Successfully installed the following scripts : /etc/init.d/tt_xifenfei /etc/rc.d/rc0.d/K45tt_xifenfei /etc/rc.d/rc1.d/K45tt_xifenfei /etc/rc.d/rc2.d/S90tt_xifenfei /etc/rc.d/rc3.d/S90tt_xifenfei /etc/rc.d/rc5.d/S90tt_xifenfei /etc/rc.d/rc6.d/K45tt_xifenfei
2.配置DSN
[root@bas info]# pwd /home/oracle/timesten/TimesTen/xifenfei/info [root@bas info]# more sys.odbc.ini [ODBC Data Sources] TT_1122=TimesTen 11.2.2 Driver [TT_1122] Driver=/home/oracle/timesten/TimesTen/xifenfei/lib/libtten.so DataStore=/home/oracle/timesten/TimesTen/xifenfei/info/TT_1122 DatabaseCharacterSet=ZHS16GBK PermSize=300 TempSize=64 OracleNetServiceName=orcl_tt
Driver = the TimesTen Direct Linked ODBC Driver
DataStore = the location and the name of the database files
LogDir = the directory for the transaction logs
PermSize = the size of the permanent region of the database. In the above example, this is configured for 40MB
TempSize = the size of the temporary region of the database. In the above example, this is configured for 32MB
DatabaseCharacterSet = the character set used by the database
OracleNetServiceName = the TNS service name to the Oracle database. This attribute is required for In-Memory Database Cache only.
3.查看相关文件和进程
[root@bas info]# ps -ef|grep timesten|grep -v grep oracle 30391 1 0 00:01 ? 00:00:00 /home/oracle/timesten/TimesTen/xifenfei/bin/timestend -initfd 13 oracle 30395 30391 0 00:01 ? 00:00:00 /home/oracle/timesten/TimesTen/xifenfei/bin/timestensubd -verbose -userlog tterrors.log -supportlog ttmesg.log -id 1000000 -facility user oracle 30396 30391 0 00:01 ? 00:00:00 /home/oracle/timesten/TimesTen/xifenfei/bin/timestensubd -verbose -userlog tterrors.log -supportlog ttmesg.log -id 1000001 -facility user oracle 30397 30391 0 00:01 ? 00:00:00 /home/oracle/timesten/TimesTen/xifenfei/bin/timestensubd -verbose -userlog tterrors.log -supportlog ttmesg.log -id 1000002 -facility user oracle 30398 30391 0 00:01 ? 00:00:00 /home/oracle/timesten/TimesTen/xifenfei/bin/timestensubd -verbose -userlog tterrors.log -supportlog ttmesg.log -id 1000003 -facility user oracle 30400 30391 0 00:01 ? 00:00:00 /home/oracle/timesten/TimesTen/xifenfei/bin/ttcserver -verbose -userlog tterrors.log -supportlog ttmesg.log -id 1000004 -p 53397 -facility user -group oinstall
[root@bas TimesTen]# pwd /home/oracle/timesten/TimesTen [root@bas TimesTen]# ls -l total 4 drwxr-x--- 17 oracle oinstall 4096 Feb 12 00:01 xifenfei [root@bas TimesTen]# cd xifenfei [root@bas xifenfei]# ls -l total 140 drwxr-x--- 4 oracle oinstall 4096 Feb 12 00:01 3rdparty drwxr-x--- 2 oracle oinstall 4096 Feb 12 00:43 bin drwxr-x--- 3 oracle oinstall 4096 Dec 24 00:23 include drwxr-x--- 2 oracle oinstall 4096 Feb 12 00:18 info drwxr-x--- 2 oracle oinstall 4096 Feb 12 00:00 lib drwxr-x--- 2 oracle oinstall 4096 Dec 24 00:23 mibs drwxr-x--- 3 oracle oinstall 4096 Dec 24 00:23 network drwxr-x--- 3 oracle oinstall 4096 Dec 24 00:23 nls drwxr-x--- 2 oracle oinstall 4096 Dec 24 00:23 oraclescripts drwxr-x--- 4 oracle oinstall 4096 Feb 11 23:59 PERL drwxr-x--- 8 oracle oinstall 4096 Dec 24 00:23 plsql -r--r----- 1 oracle oinstall 74764 Feb 12 00:00 README.html drwxr-x--- 2 oracle oinstall 4096 Feb 11 23:59 startup drwxr-x--- 2 oracle oinstall 4096 Dec 24 00:23 support drwxrw---- 5 oracle oinstall 4096 Feb 12 00:00 ttclasses drwxr-x--- 3 oracle oinstall 4096 Feb 11 23:59 ttoracle_home
4.试用Timesten
[oracle@bas bin]$ ttisql -version TimesTen Release 11.2.2.2.0 [oracle@bas info]$ ttisql TT_1122 Copyright (c) 1996-2011, Oracle. All rights reserved. Type ? or "help" for help, type "exit" to quit ttIsql. connect "DSN=TT_1122"; Warning 01S00: Undefined connection attribute "ConnectionCharacte" on line 144 of file /home/oracle/timesten/TimesTen/xifenfei/info/sys.odbc.ini Connection successful: DSN=TT_1122;UID=oracle;DataStore=/home/oracle/timesten/TimesTen/xifenfei/info/TT_1122;DatabaseCharacterSet=ZHS16GBK;ConnectionCharacterSet=US7ASCII;DRIVER=/home/oracle/timesten/TimesTen/xifenfei/lib/libtten.so;PermSize=300;TempSize=64;TypeMode=0;OracleNetServiceName=orcl_tt; (Default setting AutoCommit=1) Command> tables; 0 tables found. Command> create table t_xff(id number,name varchar2(100)); Command> tables; ORACLE.T_XFF 1 table found. Command> desc t_xff; Table ORACLE.T_XFF: Columns: ID NUMBER NAME VARCHAR2 (100) INLINE 1 table found. Command> insert into t_xff values(1,'xifenfei'); 1 row inserted. Command> insert into t_xff values(2,'www.xifenfei.com'); 1 row inserted. Command> commit; Command> select * from t_xff; < 1, xifenfei > < 2, www.xifenfei.com > 2 rows found. Command> update t_xff set name='xff' where id=1; 1 row updated. Command> select * from t_xff; < 1, xff > < 2, www.xifenfei.com > 2 rows found. Command> delete from t_xff where id=1; 1 row deleted. Command> commit; Command> select * from t_xff; < 2, www.xifenfei.com > 1 row found. Command> help Use "help all" to get a description of all commands or use "help <cmd>" to limit it to that command. ? free sqlcolumns ! functions sqlgetinfo @@ globalprocessing sqlquerytimeout accept help sqlstatistics allfunctions history sqltables allindexes host statsclear allpackages if statsestimate allprocedures indexes statsupdate allsequences isolation synonyms allsynonyms monitor tables alltables tblsize timing allviews multipleconnections tryglobalprocessing autocommit ncharencoding tryhash builtins optfirstrow trymaterialize cachegroups optprofile trymergejoin cachesqlget packages trynestedloopjoin clearhistory passthrough tryrowid clienttimeout prefetchcount tryrowlocks close prepare tryserial closeall print trytbllocks cmdcache procedures trytmphash columnlabels quantify trytmptable commit prompt trytmprange commitdurable remark tryrange compact repschemes undefine compare retryconnect unsetjoinorder connect rollback unsetuseindex define run use describe savehistory variable disconnect sequences verbosity dssize set version e: setjoinorder vertical exec setuseindex views execandfetch setvariable waitfor exit show whenever explain showjoinorder xlabookmarkdelete fetchall showplan <sql_statement> fetchone sleep Command> exit Disconnecting... Done.