Oracle TimesTen trouble shooting

1、 15019: Only the instance admin may alter the PermSize attribute

使用 tt_sem 也就是内存数据库管理员帐号连接启用 PermSize配置

tt$ ttIsql “DataStore=/home/tt/app/data/tt001/tt_sem/tt_sem;DatabaseCharacterSet=ZHS16GBK;ConnectionCharacterSet=ZHS16GBK;DRIVER=/home/tt/app/TimesTen/tt001/lib/libtten.so;TypeMode=0;PermSize=16000;TempSize=2000”

2、java.sql.SQLException: Problems with loading native library/missing methods: no ttJdbc1122 in java.library.path
//windows: java.library.path=C:\TimesTen\tt1122_32\bin
//unix: LD_LIBRARY_PATH=$TT_HOME/lib
use jdbc:timesten:client mode

3、java.lang.NoSuchMethodError: autoClientFailoverCallback
使用程序运行的机器上的客户端 ttjdbc6.jar
比如window下则应该使用 windows 下的

4、8268: Asynchronous or Synchronous Writethrough cache group cannot have a WHERE clause

可写的内存表不能带 where 条件

5、报错
Warning  5002: Unable to connect to the cache agent for /data/tt/app/data/tt001/tt_sem/tt_sem; check agent status
Warning  5051: Commit message to cache agent failed. Cache agent must be restarted
解决办法:
Command> call ttCacheStart;

6、java中报错 java.sql.SQLException: [TimesTen][TimesTen 11.2.2.4.1 CLIENT]GetNodeName: Name or service not known

解决办法:在本机 /etc/hosts 加 机器名和ip映射, 也就是说本机是 host226 , 则 ping host226 必须返回正确的ip
TimesTen 客户端和 服务器端都要加各自的。

客户端会报错:
S1000: Failed to retrieve IP address of the system. System error: -2
The command failed.

服务器的 tterrors.log 会报错类似以下:
EventID=33| Server is exiting. gethostbyname() failed.   System error: -2

6、java.sql.SQLException: Specified driver could not be loaded, shared library version mismatch for [ttJdbcCS].  Expected version=11.2.2.4.0; loaded version=11.2.2.4.1
at com.timesten.jdbc.JdbcOdbcConnection.connect(JdbcOdbcConnection.java:1794)

解决办法:java应用中的 ttjdbcXXX.jar 需要和客户端安装的版本一致