Technical data

v
Running out of a resource.................................................................................................................... 2-16
Operating system tools and shared memory.............................................................................. 2-16
Check the amount of memory allocated to the data store ........................................................ 2-16
Permanent segment filling up................................................................................................ 2-17
Temporary segment filling up ............................................................................................... 2-17
Update query optimizer statistics................................................................................................. 2-18
Check memory used by queries.................................................................................................... 2-18
Check available swap space (virtual memory)........................................................................... 2-18
Check transaction log file use of disk space................................................................................ 2-18
Check the semaphore limit ............................................................................................................ 2-20
Duplicate results from a SELECT statement.................................................................................... 2-20
Cannot attach PL/SQL shared memory ............................................................................................. 2-20
3 Troubleshooting Installation, Upgrades and Downgrades
Installing 32-bit TimesTen on 64-bit Windows.................................................................................. 3-1
Downgrading a data store with Oracle data types to TimesTen 6.0............................................... 3-1
4 Troubleshooting Oracle In-Memory Database Cache
Unable to create a cache group .............................................................................................................. 4-1
Unable to start or stop the cache agent................................................................................................. 4-2
Check status of the cache agent........................................................................................................ 4-3
Check ORACLE_HOME environment variable ............................................................................ 4-3
Check NLS environment variables.................................................................................................. 4-3
Recovering cache grid after unexpected system shutdown ............................................................. 4-3
A portion of the cache grid nodes are still running ...................................................................... 4-3
All cache grid nodes exited unexpectedly...................................................................................... 4-3
Unable to resolve Oracle Service Name............................................................................................... 4-4
Unable to resolve connect identifier..................................................................................................... 4-4
Incompatible Oracle Server and Client versions ............................................................................... 4-5
Unable to validate Oracle username and password .......................................................................... 4-5
Check library path environment variable ...................................................................................... 4-6
Check status of TNS listener and Oracle Server............................................................................ 4-6
Check Oracle privileges..................................................................................................................... 4-6
Check DSN definition........................................................................................................................ 4-6
Reboot TimesTen machine................................................................................................................ 4-7
Set the cache administration user id and password ..................................................................... 4-7
Check user and system environment .............................................................................................. 4-7
Verify the loaded dynamic libraries................................................................................................ 4-7
OCI initialization failed.......................................................................................................................... 4-8
Unsupported data type mapping .......................................................................................................... 4-9
Null constraint does not match Oracle................................................................................................. 4-9
DDL operations on cached Oracle tables may cause cache group operations to fail.................. 4-9
Changes not visible after updating object in cache group ........................................................... 4-10
Loading or refreshing fails .................................................................................................................. 4-10
Monitoring autorefresh cache groups ............................................................................................... 4-10
Using the ttCacheAutorefreshStatsGet procedure..................................................................... 4-11