more ttendaemon.options
-serverShmIpc
-serverShmSize628M
more sys.ttconnect.ini
[tt_xifenfei_c_s]
Network_Address=ttShmHost
TCP_PORT=53397
[timesten@test info]$ more sys.odbc.ini
[ODBC Data Sources]
TT_1122=TimesTen 11.2.2 Driver
[TT_1122]
Driver=/u01/timesten/TimesTen/tt1122/lib/libtten.so
DataStore=/u01/timesten/TimesTen/tt1122/info/TT_1122
DatabaseCharacterSet=ZHS16GBK
ConnectionCharacterSet=ZHS16GBK
PermSize=3000
TempSize=1000
OracleNetServiceName=vedb
[ODBC Data Sources]
tt_xifenfei_c=TimesTen 11.2.2 Client Driver
[tt_xifenfei_c]
TTC_SERVER=tt_xifenfei_c_s
TTC_SERVER_DSN=tt_1122
这个c/连接是共享内存连接？如何查询是不是共享内存连接呢？
[timesten@test ~]$ ttIsqlCS -connStr "DSN=tt_xifenfei_c";
Copyright (c) 1996, 2013, Oracle and/or its affiliates. All rights reserved.
Type ? or "help" for help, type "exit" to quit ttIsql.
connect "DSN=tt_xifenfei_c";
Connection successful: DSN=tt_xifenfei_c;TTC_SERVER=tt_xifenfei_c_s;TTC_SERVER_DSN=tt_1122;UID=timesten;DATASTORE=/u01/timesten/TimesTen/tt1122/info/TT_1122;DATABASECHARACTERSET=ZHS16GBK;CONNECTIONCHARACTERSET=ZHS16GBK;PERMSIZE=3000;TEMPSIZE=1000;TYPEMODE=0;ORACLENETSERVICENAME=vedb;
(Default setting AutoCommit=1)
这个c/s是什么连接方式，TCP/IP?
[timesten@test info]$ ttisql "dsn=tt_1122;uid=cacheuser;pwd=timesten;oraclepwd=oracle";
Copyright (c) 1996, 2013, Oracle and/or its affiliates. All rights reserved.
Type ? or "help" for help, type "exit" to quit ttIsql.
connect "dsn=tt_1122;uid=cacheuser;pwd=timesten;oraclepwd=oracle";
Connection successful: DSN=TT_1122;UID=cacheuser;DataStore=/u01/timesten/TimesTen/tt1122/info/TT_1122;DatabaseCharacterSet=ZHS16GBK;ConnectionCharacterSet=ZHS16GBK;DRIVER=/u01/timesten/TimesTen/tt1122/lib/libtten.so;PermSize=3000;TempSize=1000;TypeMode=0;OracleNetServiceName=vedb;
(Default setting AutoCommit=1) |
