Cluster configuration for OBIEE

 

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