Technical data

Unable to start or stop the cache agent
4-2 Oracle TimesTen In-Memory Database Troubleshooting Procedures Guide
Unable to start or stop the cache agent
This section describes some of the problems you might encounter when starting or
stopping the cache agent.
Possible cause What to do
User does not have the correct Oracle
privileges to create the cache group type.
See "Check Oracle privileges" on page 4-6.
User has insufficient access to data store. You must have CACHE_MANAGER privilege
to create a cache group.
The internal/external user does not match the
Oracle user.
The TimesTen user name must be the same as
the Oracle user name.
Cannot connect to Oracle See:
■ "Unable to resolve Oracle Service Name"
on page 4-4
■ "Unable to resolve connect identifier" on
page 4-4
■ "Unable to validate Oracle username and
password" on page 4-5
■ "Incompatible Oracle Server and Client
versions" on page 4-5
■ Check whether Oracle needs to be
restarted.
Check the network status.
Cache administration user ID or password not
set (when trying to create AWT or autorefresh
cache groups)
See "Set the cache administration user id and
password" on page 4-7.
Unsupported data type mapping See "Unsupported data type mapping" on
page 4-9.
Different nullability setting in Oracle See "Null constraint does not match Oracle" on
page 4-9.
Failure to specify primary key in root table The root table of a cache group must have a
primary key. See "Defining cache groups" in
the Oracle In-Memory Database Cache User's
Guide.
Possible cause What to do
Cache agent already running See "Check status of the cache agent" on page 4-3.
Unable to locate Oracle libraries
■ See "Check status of TNS listener and Oracle
Server" on page 4-6.
■ Check the permissions on the libraries.
ORACLE_HOME is invalid. See "Check ORACLE_HOME environment variable" on
page 4-3.
Insufficient privileges You must have CACHE_MANAGER privilege to start
or stop the cache agent.
Wrong OracleID Ensure that the OracleID set in your DSN definition
matches the Oracle Service Name for the Oracle
instance that contains the tables to cache in TimesTen.