配置TimesTen应用层数据库缓存.docVIP

配置TimesTen应用层数据库缓存 一、 配置TimesTen应用层数据库缓存 1、 创建一个新的表空间 以SYS用户登录SQL*Plus,命令如下： create tablespace ttuscrs datafile，ttusers, dbf，SIZE 40M; 2、 创建TimesTen用户 执行脚本 initCacheGlobalSchema.sql （位于timesten_install_dir/oraclescripts 目录下）创建 TimesTen Schema 到 Oracle 数据库 SQL 0TimesTen/ttll22/oraciescripts/initCacheGlobalSche3ia.sql Please enter the tablespace where TIMESTEN user is to be created ttusers The value chosen ￡oe tablespace is ttusers *?**?*? Creation of TIMESTEN schema and TT_CACHE_ADMIN_ROLE starts Creating TIMESTEN schema Creating TIMESTEN.TT^GRIDID table Creating TIMESTEN.TT^GRIDINFO table Creating TT_CACHE-ADMIN_ROLE role Granting privileges to TT_CACHE_ADMIN_ROLE Creation o￡ TIMESTEN schema and TT_CACHE_ADHIN_ROLE done successfully PL/SQL procedure successfully completed. SQL | 3、 创建缓存管理员用户 创建一个Oracle账户作为缓存管理员用户，如下命令： create user cacheadm identified by cacheadm default tablespace ttusers quota unlimited on ttusers temporary tablespace temp; 4、 给缓存管理员用户赋孑系统权限 执行脚本timesten_install_dir/oraclescripts/grantCacheAdminPrivileges.sql 给缓存管理员用 户赋予必要的权限 SQL 6TimesTen/ttll22/oraclescripts/grant￡acheAdminPrivileges.sql Please enter the administrator user id cacheadu The value chosen ￡oe administrator user id is cacheadm tabLespace 0. Granting丸antingGrantingGranting 0. Granting 丸anting Granting Granting Granting Granting ^ranting 5ran ting Granting Checking 6. 7. 8. 9. Initialization for cache admin begins the CREATE SESSION privilege to CACHEADH the TT_CACHE ADMIN ROLE to CACHEADM the th皀 the the the the the DBMS^LOCK package privilege to CACHEADM RESOURCE privilege to CACHEADM CREATE PROCEDURE privilege to CACHEADM CREATE ANY TRIGGER privilege to CACHEADM DBMS_LOB package privilege to CACHEADM SELECT on SYS.ALL_OBJECTS privilege to CACHEADM SELECT on SYS.ALL【SYNONYMS privilege to CACHEADM if the cache administrator user has permissions on the default Permission exists 11. Granting the CREATE ANY TYPE privilege to CACHEADM Initialization Cor cache admin user done successful