Here I will detail the steps to configure a two node OBIEE cluster.
Prerequisites:
I have used “Basic” OBIEE 10.1.3.4.0 installed (Complete as this requires Cluster Controller) on two linux machines with a shared file system under /share to do this test.
Take the backup of the configuration files before start changing them.
Create the shared directories:
I have created these directories under /share mount point for my testing
$mkdir Scripts -directory to configure scheduler scripts
$mkdir Config
$mkdir XMLP
$mkdir Catalog -directory for shared catalog
$mkdir Cache -directory for global cache
$mkdir Repository -repository publishing directory
Configure BI Server – changes to NQSConfig.INI on all nodes
File is under $BI_HOME/server/Config
# Query Result Cache Section
// Cluster-aware cache
GLOBAL_CACHE_STORAGE_PATH = “/share/Cache” 500 MB;
MAX_GLOBAL_CACHE_ENTRIES = 1000;
CACHE_POLL_SECONDS = 300;
CLUSTER_AWARE_CACHE_LOGGING = YES;
# Server Section
# Comment the following line
#SERVER_HOSTNAME_OR_IP_ADDRESSES = “ALLNICS”; # Example: “hostname” or “hostname”:port
#Set the CLUSTER_PARTICIPANT, REPOSITORY_PUBLISHING_DIRECOTRY and
REQUIRE_PUBLISHING_DIRECTORY parameters
CLUSTER_PARTICIPANT = YES;
REPOSITORY_PUBLISHING_DIRECTORY = “/share/Repository”;
REQUIRE_PUBLISHING_DIRECTORY = YES; // Don’t join cluster if directory not accessible
Configure Cluster Controller – changes to NQClusterConfig.INI on all nodes
File is under $BI_HOME/server/Config
# Cluster Configuration File
ENABLE_CONTROLLER = YES;
PRIMARY_CONTROLLER = “obiserver1.local.domain”;
SECONDARY_CONTROLLER = “obiserver2.local.domain “;
SERVERS = “obiserver1.local.domain”,”obiserver2.local.domain”;
MASTER_SERVER = “obiserver1.local.domain”;
SCHEDULERS = “obiserver1.local.domain:9705:9708″, “obiserver2.local.domain:9705:9708″;
Parameters like CLIENT_SERVER_PORT, CLIENT_CONTROLLER_PORT, MONITOR_CONTROLLER_PORT and MONITOR_SERVER_PORT should be set if the default port numbers are not used.
Configure Presentation service – changes to odbc.ini, instanceconfig.xml and web.xml on all nodes
odbc.ini file is under $BI_HOME/setup and changes to it are shown below -
[Cluster]
Catalog=
PrimaryCCS=obiserver1.local.domain
SecondaryCCS=obiserver2.local.domain
instanceconfig.xml file is under $BI_DATA_HOME/web/config and the changes to it are shown below -
<DSN>Cluster</DSN>
<CatalogPath>/share/Catalog/samplesales</CatalogPath>
Make sure the DSN is same as the one in odbc.ini which is “Cluster” in this example or the default.
web.xml file is under $BI_HOME/web/app/WEB-INF and changes to it are shown below -
Replace the lines
<init-param>
<param-name>oracle.bi.presentation.sawserver.Host</param-name>
<param-value>localhost</param-value>
</init-param>
<init-param>
<param-name>oracle.bi.presentation.sawserver.Port</param-name>
<param-value>9710</param-value>
</init-param>
with
<init-param>
<param-name>oracle.bi.presentation.sawservers</param-name>
<param-value>obiserver1.local.domain:9710;obiserver2.local.domain:9710</param-value>
</init-param>
Startup the BI services on all BI servers
