5186: The OCI client library in use does not contain required routines to support caching LOBS from Oracle.
5183: Function kollgsnp2 was not in the library. The function will not be called.
Are you trying to use the instance client shipped with Timesten ? We only support instanceclient provided with Timesten software . It can be found here
After that it should works fine. Additionally there are not errors, these messages are warnings, so you can ignore them.
Warning 5183: Function kollglid2 was not in the library. The function will not be called. Warning 5183: Function kollgsnp2 was not in the library. The function will not be called. Warning 5186: The OCI client library in use does not contain required routines to support caching LOBS from Oracle.
SQL> @grantCacheAdminPrivileges "cacheadmin" Please enter the administrator user id The value chosen for administrator user id is cacheadmin ***************** Initialization for cache admin begins ****************** 0. Granting the CREATE SESSION privilege to CACHEADMIN 1. Granting the TT_CACHE_ADMIN_ROLE to CACHEADMIN 2. Granting the DBMS_LOCK package privilege to CACHEADMIN 3. Granting the RESOURCE privilege to CACHEADMIN 4. Granting the CREATE PROCEDURE privilege to CACHEADMIN 5. Granting the CREATE ANY TRIGGER privilege to CACHEADMIN 6. Granting the DBMS_LOB package privilege to CACHEADMIN 7. Granting the SELECT on SYS.ALL_OBJECTS privilege to CACHEADMIN 8. Granting the SELECT on SYS.ALL_SYNONYMS privilege to CACHEADMIN 9. Checking if the cache administrator user has permissions on the default tablespace Permission exists 11. Granting the CREATE ANY TYPE privilege to CACHEADMIN ********* Initialization for cache admin user done successfully ********* SQL>
Additionally dont forget to issue the grants for cacheadmin user in Oracle DB
Command> CREATE USER cacheadmin IDENTIFIED BY oracle; User created. Command> GRANT CREATE SESSION, CACHE_MANAGER, CREATE ANY TABLE, DROP ANY TABLE TO cacheadmin; Command> Command> CREATE USER oratt IDENTIFIED BY oracle; User created. Command> grant create session to oratt; Command> ... [oracle@tt1 ~]$ ttIsql "DSN=db_cache;UID=cacheadmin;PWD=oracle;OraclePWD=oracle" Copyright (c) 1996-2010, Oracle. All rights reserved. Type ? or "help" for help, type "exit" to quit ttIsql. connect "DSN=db_cache;UID=cacheadmin;PWD=oracle;OraclePWD=oracle"; Connection successful: DSN=db_cache;UID=cacheadmin;DataStore=/u01/app/oracle/datastore/db_cache;DatabaseCharacterSet=AL32UTF8;ConnectionCharacterSet=US7ASCII;DRIVER=/u01/app/oracle/product/11.2.1/TimesTen/tt1/lib/libtten.so;PermSize=100;TempSize=32;TypeMode=0;CacheGridEnable=0;OracleNetServiceName=ORCL; (Default setting AutoCommit=1) Command> call ttCacheUidPwdSet('cacheadmin','oracle'); Command> ... Command> CREATE READONLY CACHE GROUP readcache > AUTOREFRESH INTERVAL > 5 SECONDS > FROM oratt.readtab ( > a NUMBER NOT NULL PRIMARY KEY, > b VARCHAR2(100) ); Command>
SQL> GRANT SELECT ON readtab TO cacheadmin; Grant succeeded.
Executing the above command, you are trying to delete the table linked with cache groups. Dont do that.
Command> Drop table oratt.readtab; 8228: Cannot drop cache group table READTAB; please use DROP CACHE GROUP instead The command failed.
What user do you use for this command. Try this by using the cacheadmin user:
Command> Drop cache group oratt.readtab ; 8227: Cache group ORATT.READTAB not found The command failed.
and after that
Command> cachegroups; Cache Group CACHEADMIN.AWTCACHE: … Cache Group Type: Asynchronous Writethrough Autorefresh: No Aging: No aging defined Root Table: ORATT.AWTTAB Table Type: Propagate … Command>
Command> drop cache group awtcache;