OBIEE 11g Global Cache Not Being Copied to Other Servers on Vertical Cluster
Last updated on SEPTEMBER 28, 2016
Applies to:Business Intelligence Server Enterprise Edition - Version 220.127.116.11.140225 and later
Oracle Exalytics Software - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
Using Exalytics bare metal server with Patchset (PS) 3 and OBIEE 22.214.171.124.140225. The server includes a single instance that has been scaled out to a 4 node, vertical cluster with 4 BI servers, 4 presentation servers and 4 java hosts.
In this environment, global cache has been setup and agents are used to seed the global cache. When the agents are run, they are run by a user with full privileges (BIAdmin or other administrator user).
In some cases, cache table (.tbl files) are present on the primary node but are not being copied to all of the servers in the cluster. This is preventing cache from being used properly and causing reports to be re-run instead of retrieved from the cache.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms