Jul 31 11:57:54 2015 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> GRANT EXECUTE ON SYS.DBMS_LOCK TO cacheuser; Grant succeeded. SQL> GRANT EXECUTE ON SYS.DBMS_LOB TO cacheuser; Grant succeeded. SQL> GRANT SELECT ON SYS.GV_$LOCK TO cacheuser; Grant succeeded. SQL> GRANT SELECT ON SYS.GV_$SESSION TO cacheuser; Grant succeeded. SQL> GRANT SELECT ON SYS.DBA_DATA_FILES TO cacheuser; Grant succeeded.
将脚本整理到这里，方便以后调用
GRANT EXECUTE ON SYS.DBMS_LOCK TO cacheuser; GRANT EXECUTE ON SYS.DBMS_LOB TO cacheuser; GRANT SELECT ON SYS.GV_$LOCK TO cacheuser; GRANT SELECT ON SYS.GV_$SESSION TO cacheuser; GRANT SELECT ON SYS.DBA_DATA_FILES TO cacheuser;
到此Oracle的工作已基本结束，以下是Timesten需要配置的内容
4、配置TNS_ADMIN
[timesten@bogon ~]$ ttModInstall -tns_admin /opt/oracle/TimesTen/tt1122/ttoracle_home/instantclient_11_2/network/admin; TNS_ADMIN for the instance 'tt1122' is currently not set. Would you like to change TNS_ADMIN for this instance? [ yes ] yes Please enter a value for TNS_ADMIN (q=quit)? [ /opt/oracle/TimesTen/tt1122/ttoracle_home/instantclient_11_2/network/admin ] Do you want to restart the daemon using the new configuration? [ yes ] yes Restarting the daemon ... TimesTen Daemon stopped. TimesTen Daemon startup OK. Instance tt1122 is now configured with TNS_ADMIN=/opt/oracle/TimesTen/tt1122/ttoracle_home/instantclient_11_2/network/admin
如果在安装时配置了TNS_ADMIN 则此项忽略
5、设置cache administration user
NOTE:This procedure requires CACHE_MANAGER privilege.
ttCacheUidPwdSet(‘UID’, ‘PWD’)
ttCacheUidGet()
Command> call ttCacheUidPwdSet('cacheuser','oracle'); Command> call ttCacheUidGet(); < CACHEUSER > 1 row found.
6、创建cache grid
在创建cache group之前需要先建立cache grid，只有cache grid的第一个数据库成员需要执行这个操作。当以cache manager user 登录后，输入如下命令创建一个cache grid “myGrid”
Command> call ttGridCreate('gjds_grid');
将timesten和刚建好的cache grid 关联起来
Command> call ttGridNameSet('gjds_grid');
启动cache代理，如果建立了read only cache，需要启动该代理才能使用。该代理负责timesten database之间的沟通以及oracle和timesten cache database之间的数据流。
Command> call ttCacheStart;
7、创建cache groups
创建一个只读cache group readcache用于高速缓存oracle中的表TEST.TT_CACHE_TEST
#首先需要在Oracle中将TT_CACHE_TEST的查询权限授予CACHEUSER SQL> GRANT SELECT ON TT_CACHE_TEST TO CACHEUSER; 然后在Timesten中执行下面的语句 Command> create readonly cache group TT_CACHE_TEST1 autorefresh interval 60 seconds from TT_CACHE_TEST( ID VARCHAR2(20) PRIMARY KEY, ADDRESS VARCHAR2(40), NAME VARCHAR2(20) );
启动复制agent，如果数据库中有asynchronous writethrough cache groups就必须要启动这个agent，这个进程负责TT数据库之间，TT和oracle之间的数据复制。
Command> call ttrepstart;
8、使用read-only cache group
当以cache manager user 登录后，需要先手动从oracle中载入readcache中相应cache表的内容
Command> LOAD CACHE GROUP TT_CACHE_TEST1 COMMIT EVERY 100 ROWS; 9 cache instances affected
9、重启Cache代理
如果发现数据没有同步可重启cache代理
Command> call ttCacheStop(); Command> call ttCacheStart();