Technical data

Troubleshooting Oracle In-Memory Database Cache 4-1

4Troubleshooting Oracle In-Memory Database

Cache

This chapter describes how to troubleshoot some of the problems you may encounter

when using Oracle In-Memory Database Cache (IMDB Cache). It includes the

following topics:

■ Unable to create a cache group

■ Unable to start or stop the cache agent

■ Recovering cache grid after unexpected system shutdown

■ Unable to resolve Oracle Service Name

■ Unable to resolve connect identifier

■ Incompatible Oracle Server and Client versions

■ Unable to validate Oracle username and password

■ OCI initialization failed

■ Unsupported data type mapping

■ Null constraint does not match Oracle

■ DDL operations on cached Oracle tables may cause cache group operations to fail

■ Changes not visible after updating object in cache group

■ Loading or refreshing fails

■ Monitoring autorefresh cache groups

■ Optimize Performance for IMDB Cache

■ Autorefresh not refreshing cache at the specified interval

■ Incremental autorefresh not progressing

■ Incremental autorefresh becomes full autorefresh

■ Poor autorefresh performance

If you are having problems with an AWT cache group, see also Chapter 5,

"Troubleshooting AWT Cache Groups".

Unable to create a cache group

This section describes some of the problems you might encounter when executing the

CREATE CACHE GROUP statement.