Oracle^® Business Intelligence Enterprise Edition Deployment Guide > Clustering, Load Balancing, and Failover in Oracle Business Intelligence > Configuration of BI Components for Clustering, Load Balancing, and Failover >

Setting Parameters in the NQSConfig.INI File

BI Server machines are configured for participation in a BI cluster by setting parameters in the NQSConfig.INI file. This file is located in the following directory on the BI Server machine.

To access the NQSConfig.INI file

• For Windows, access OracleBI_HOME\server\Config
• For Linux or UNIX, access OracleBI_HOME/server/Config

Setting the Cluster Participation Parameters

You must configure the CLUSTER_PARTICIPANT and RPC_SERVICE_OR_PORT parameters.

To set the Cluster Participation parameters

• Set the parameter CLUSTER_PARTICIPANT to YES for a BI Server to join the BI Cluster.
• Set the parameter RPC_SERVICE_OR_PORT to the desired port that the BI Server will listen on for client requests.

  The default port number is 9703. When the BI Server is a cluster participant, the following line must be commented out as shown:

  # SERVER_HOSTNAME_OR_IP_ADDRESSES = "ALLNICS";
  Multi-NIC is not supported for clustered deployments.

Setting the Repository Publishing Directory

To allow online modifications to be made to the repository, the following parameters must be set.

To set the repository publishing directory

• Set the parameter REPOSITORY_PUBLISHING_DIRECTORY to the path to the shared file system for the Repository Publishing Directory for all BI Servers participating in the cluster.
• Set the parameter REQUIRE_PUBLISHING_DIRECTORY to YES to make the repository publishing directory available, in order for the BI Server to start up and join the cluster.

Setting Cluster-Aware Caching Parameters

Caching is enabled by default for BI Servers. In addition to the caching-related parameters that are set for the BI Sever for the local query cache, you must set the cluster-aware cache parameters.

NOTE:  A copy of the NQSConfig.INI file must reside on all BI Server machines that are part of the BI cluster.

To set cluster-aware caching parameters

• Set the parameter GLOBAL_CACHE_STORAGE_PATH to specify the following:
  • Location of the shared file system storage for the global cache that stores seeding and purging events.
  • Capacity of storage, depending on the maximum number of entries allowed for the global cache and the average size of each entry.
• Set the parameter MAX_GLOBAL_CACHE_ENTRIES to the maximum number of entries that are allowed in the global cache store.
• Set the parameter CACHE_POLL_SECONDS to specify the interval in seconds at which the BI Server will pull from the logical event queue in order to synchronize with other server nodes in the cluster.
• Set the parameter CLUSTER_AWARE_CACHE_LOGGING to turn on logging for the shared cache.
  • Set to YES (enable logging) only for debugging purposes.
  • Entries are made to the NQQuery.log file:
    • Under Windows, located in the directory OracleBI_HOME\server\Log
    • Under Linux and UNIX, located in the directory OracleBI_HOME/server/Log