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
- Open the NQSConfig.INI file for editing.
- 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;
- 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>.
- In the Server Section, uncomment the parameter CLUSTER_PARTICIPANT and set it to YES.
- When the BI Server is a cluster participant, comment out the parameter SERVER_HOSTNAME_OR_IP_ADDRESSES = "ALLNICS";
- Set the parameter RPC_SERVICE_OR_PORT to the desired port that the BI Server will listen on.
NOTE: The default port is 9703.
- 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;
|