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 NQClusterConfig.INI File

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

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

To set parameters in the NQClusterConfig.INI file

1. Open the NQClusterConfig.INI file for editing.
2. Set the parameter ENABLE_CONTROLLER to YES to enable clustering.
3. Identify the Primary and Secondary Cluster Controllers:
   • Set the parameter PRIMARY_CONTROLLER to the machine hosting the Primary Cluster Controller.
   • Set the parameter SECONDARY_CONTROLLER to the machine hosting the Secondary Cluster Controller.
4. Set the parameter SERVERS by entering a comma-separated list of the BI Server hostnames.

   NOTE:  Do not specify Fully Qualified Domain Names for the BI Servers.

5. Set the parameter MASTER_SERVER by entering the hostname of the Master BI Server machine.
6. Set the parameter SCHEDULERS for the Scheduler servers participating in the cluster.

   SCHEDULERS = "scheduler1:<rpc port>:<monitor port>", "scheduler2:<rpc port>:<monitor port>";

   where:

   • <rpc port> is the Server Port Number that is set during initial configuration of the BI Scheduler. The default port is 9705. Refer to the chapter on configuring the BI Scheduler component in the Oracle Business Intelligence Infrastructure Installation and Configuration Guide.
   • <monitor port> is the Cluster Monitor Port that is set during configuration of the BI Scheduler for participation in the BI cluster. The default is 9708. Refer to the topic Configuring BI Scheduler.
7. The following parameters are set to the default values shown. Modify the parameter values as required for your deployment.

   Parameter	For...	Default
   SERVER_POLL_SECONDS	BI Server to Cluster Controller polling frequency	5
   CONTROLLER_POLL_SECONDS	Cluster Controller to Cluster Controller polling frequency	5
   CLIENT_SERVER_PORT	Set to same as RPC_SERVICE_OR_PORT in NQSConfig.INI	9703
   CLIENT_CONTROLLER_PORT	Port used by clustered ODBC for communication with Cluster Controller	9706
   MONITOR_CONTROLLER_PORT	Port used by Cluster Controllers for Cluster Controller to Cluster Controller communication	9700
   MONITOR_SERVER_PORT	Port used by Cluster Controller for life cycle monitoring of BI Servers	9701

   For example:

   # NQClusterConfig.INI

   [Cluster]

   ENABLE_CONTROLLER = YES;
   PRIMARY_CONTROLLER = "BI-CCS-01";
   SECONDARY_CONTROLLER = "BI-CCS-02";
   SERVERS = "BI-SERVER-01","BI-SERVER-02";
   MASTER_SERVER = "BI-SERVER-01";
   SERVER_POLL_SECONDS = 5;
   CONTROLLER_POLL_SECONDS = 5;
   CLIENT_SERVER_PORT = 9703;
   CLIENT_CONTROLLER_PORT = 9706;
   MONITOR_CONTROLLER_PORT = 9700;
   MONITOR_SERVER_PORT = 9701;
   SCHEDULERS = "BI-SCHEDULER-01:9705:9708","BI-SCHEDULER-02:9705:9708";