1
Download TimesTen Troubleshooting Guide
Transcript
Check the amount of memory allocated to the database .......................................................... Permanent data partition filling up....................................................................................... Temporary data partition filling up ...................................................................................... Update query optimizer statistics................................................................................................. Check memory used by queries.................................................................................................... Out of memory after fatal crash of the database ........................................................................ Check transaction log file use of disk space ................................................................................ Check if tracing is enabled............................................................................................................. Check the semaphore limit ............................................................................................................ Duplicate results from a SELECT statement.................................................................................... Cannot attach PL/SQL shared memory ............................................................................................. 2-17 2-17 2-18 2-18 2-18 2-18 2-18 2-20 2-20 2-20 2-20 3 Troubleshooting Oracle In-Memory Database Cache Unable to create a cache group .............................................................................................................. 3-2 Unable to start or stop the cache agent................................................................................................. 3-2 Check status of the cache agent........................................................................................................ 3-3 Check ORACLE_HOME environment variable ............................................................................ 3-3 Check NLS environment variables .................................................................................................. 3-3 Recovering cache grid after unexpected system shutdown ............................................................. 3-3 A portion of the cache grid nodes are still running ...................................................................... 3-3 All cache grid nodes exited unexpectedly...................................................................................... 3-4 Unable to resolve Oracle Service Name............................................................................................... 3-4 Unable to resolve connect identifier..................................................................................................... 3-5 Incompatible Oracle Database Server and Client versions ............................................................. 3-5 Unable to validate the Oracle database username and password .................................................. 3-5 Check library path environment variable ...................................................................................... 3-6 Check status of TNS listener and Oracle Database Server........................................................... 3-6 Check the Oracle database privileges ............................................................................................. 3-6 Check DSN definition........................................................................................................................ 3-6 Reboot TimesTen machine................................................................................................................ 3-7 Set the cache administration user name and password ............................................................... 3-7 Check user and system environment .............................................................................................. 3-7 Verify the loaded dynamic libraries ................................................................................................ 3-8 OCI initialization failed.......................................................................................................................... 3-9 Unsupported data type mapping .......................................................................................................... 3-9 Null constraint does not match Oracle Database .............................................................................. 3-9 DDL operations on the cached Oracle database tables may cause cache group operations to fail .. 3-10 Changes not visible after updating object in cache group ........................................................... 3-10 Loading or refreshing fails .................................................................................................................. 3-11 Monitoring autorefresh cache groups ............................................................................................... 3-11 Using the ttCacheAutorefreshStatsGet procedure..................................................................... 3-11 Displaying information from the change log tables .................................................................. 3-13 Understanding messages about autorefresh in the support log .............................................. 3-14 Diagnosing autorefresh failure ..................................................................................................... 3-15 Diagnosing autorefresh performance problems......................................................................... 3-15 Using SNMP traps for alerts about autorefresh problems........................................................ 3-16 v
