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

Setting Parameters in the NQSConfig.INI File

This topic shows how to use the NQSConfig.INI file to configure your deployment. The NQSConfig.INI file is located as follows:

• For Windows: OracleBI\server\Config
• For Linux or UNIX: OracleBI/server/Config

To set parameters in the NQSConfig.INI file

1. Open the NQSConfig.INI file for editing.
2. In the Repository section of the NQSConfig.INI, define your repository by setting the logical repository name and file name pair. For example:

   Star = < Custom rpd filename>, DEFAULT;

3. Set Cache parameters. Caching is enabled by default.

   To use the cluster-aware caching capability, set the cluster-aware cache parameters for the BI Sever. In the Query Result Cache section of the NQSConfig.INI file, uncomment and set the following parameters:

   • GLOBAL_CACHE_STORAGE_PATH. Set "<path to shared storage for cache>" and <Size>.
   • MAX_GLOBAL_CACHE_ENTRIES. Set <Max number of entries>.
   • CACHE_POLL_SECONDS. Set <Polling interval in seconds>.
4. In the Server Section, uncomment the parameter CLUSTER_PARTICIPANT and set it to YES.
5. When the BI Server is a cluster participant, comment out the parameter SERVER_HOSTNAME_OR_IP_ADDRESSES = "ALLNICS";
6. Set the parameter RPC_SERVICE_OR_PORT to the desired port that the BI Server will listen on.

   NOTE:  The default port is 9703.

7. In order for online modifications to be made to the repository, uncomment and set the following parameters:
   • REPOSITORY_PUBLISHING_DIRECTORY. Set "<path to shared network location>".
   • REQUIRE_PUBLISHING_DIRECTORY. Set to YES.

     For example:

   [ REPOSITORY ]
   Star = custom.rpd, DEFAULT;
   
   [ CACHE ]
   ENABLE = YES:
   
   // Cluster-aware cache
   GLOBAL_CACHE_STORAGE_PATH = "\\FS-HOST\OracleBI\ClusterCache" 700 MB;
   MAX_GLOBAL_CACHE_ENTRIES = 1000;
   CACHE_POLL_SECONDS = 300;
   CLUSTER_AWARE_CACHE_LOGGING = NO;
   
   [ SERVER ]
   
   # SERVER_HOSTNAME_OR_IP_ADDRESSES = "ALLNICS"
   CLUSTER_PARTICIPANT = YES;
   REPOSITORY_PUBLISHING_DIRECTORY = "\\FS-HOST\OracleBIData\ClusterRpd";
   REQUIRE_PUBLISHING_DIRECTORY = YES;