This section describes how to configure the Presentation Services and create the appropriate Oracle Solaris Cluster resource groups and resources for both a failover and a multi-master case.
Once the Oracle BI EE Presentation Services software has been installed, you must configure Oracle WebLogic Server to load the analytics.ear (Enterprise Archive) file as described in the Oracle WebLogic Server documentation. Ensure that the plug-in is marked as active, otherwise attempts to connect to the service will result in HTTP 503 errors. The plug-in cannot be tested until the entire stack, Presentation Services, BI Server and Cluster Controller, where appropriate, are set up.
Before You Begin
Before you create the BI Presentation Service resource for a failover configuration, you might need to edit the following files:
/etc/netmasks – Ensure that the /etc/netmasks file has IP-address subnet and netmask entries for all logical hostnames. If necessary, edit the /etc/netmasks file to add any missing entries.
BI_DATA_DIRECTORY/web/config/instanceconfig.xml – Check the setting for the <DSN> tag. This field references a [tag_name] section in the odbc.ini file.
BI_INSTALL_DIRECTORY/setup/odbc.ini – Set the ServerMachine and Port entries that will be used by the BI server. For a failover configuration, the ServerMachine corresponds to the host name plumbed by the SUNW.LogicalHostname resource in the BI Server resource group.
# run-saw.sh
# clresourcegroup create -n phys-green1,phys-green2 \ wls-svr-rg
# clreslogicalhostname create -g wls-svr-rg -h green-lh2 wls-svr-lh-rs
# clresource create -t SUNW.HAStoragePlus -g wls-svr-rg \ -p FileSystemMountPoints=/failover/wls:/failover/wls \ wls-svr-hasp-rs
For more information about creating a failover configuration for Oracle WebLogic Server, see Oracle Solaris Cluster Data Service for Oracle WebLogic Server Guide .
# clresourcegroup online -eM wls-svr-rg
This resource must reside in the same resource group as the Presentation Service resource.
# clresource create -t SUNW.wls -g wls-svr-rg \ -p resource_dependencies=wls-svr-hasp-rs \ -p Confdir_list=/failover/wls/Oracle/Middleware/wlserver_10.3 \ -p Server_url=http://green-lh2.example.com:7003 \ -p Start_script=/failover/wls/Oracle/Middleware/user_projects/domains/obiee/bin/ startManagedWebLogic.sh \ -p Server_name=ms1 wls-svr-rs
For more information, see Installing and Configuring Oracle Business Intelligence Enterprise Edition.
# clresourcetype register ORCL.obiee_presentation_service
# clresource create -g wls-svr-rg \ -t ORCL.obiee_presentation_service \ -p Run_64_bit=True \ -p resource_dependencies=wls-svr-hasp-rs,wls-svr-lh-rs \ -p BI_INSTALL_DIRECTORY=/failover/wls/obiee/OracleBI \ -p BI_DATA_DIRECTORY=/failover/wls/obiee/OracleBIData \ bi-pres-svc-rs
# clresource status bi-pres-svc-rs === Cluster Resources === Resource Name Node Name State Status Message ------------- --------- ----- ------- ------- bi-pres-svc-rs phys-green1 Online Online - Service is online. phys-green2 Offline Offline
Because the Oracle WebLogic Server Presentation Service plug-in sends requests to the local BI Presentation Service server process, the Oracle WebLogic Server resource must set an offline_restart dependency on the BI Presentation Service resource. This setting ensures that if a BI Presentation Service server is unavailable, the load-balancer stops sending requests to the Oracle WebLogic Server.
# clresource set \ -p resource_dependencies_offline_restart=bi-pres-svc-rs \ wls-svr-rs
# ps -ef | grep sawserver # /usr/java/bin/jps -v | grep javahost
The Presentation Services tier results in two processes being started: sawserver and a Java process. The name of the sawserver process depends on whether the 64-bit option is chosen.
If the BI server has been configured, you can log in from a web browser using one of the accounts that you have configured. For example, if the Oracle WebLogic Server is running on logical host green-lh1 on port 7003, the URL would be http://green-lh1:7003/analytics/saw.dll?Dashboard.
A multi-master Presentation Services configuration requires a multi-master Oracle WebLogic Server configuration and a mechanism to load-balance incoming web connections. A failover Oracle WebLogic Server with a load-balancing plug-in can be configured to perform this task. For more information about creating a multi-master configuration for Oracle WebLogic Server, see Oracle Solaris Cluster Data Service for Oracle WebLogic Server Guide .
Before You Begin
Before you create the multi-master configuration for BI Presentation Services, you need to edit the following configuration file:
BI_INSTALL_DIRECTORY/setup/odbc.ini – A multi-master Presentation Services configuration requires primary and secondary cluster controllers to be defined in the odbc.ini file. Therefore, ensure that the PrimaryCCS and SecondaryCCS entries are present in the file. The host names used must be capable of being resolved.
# run-saw.sh
# clresourcegroup create -n phys-green1,phys-green2 \ -p RG_mode=Scalable \ -p Maximum_primaries=2 \ -p Desired_primaries=2 \ mm-wls-svr-rg
# clresource create -t SUNW.HAStoragePlus -g mm-wls-svr-rg \ -p FileSystemMountPoints=/global/wls:/global/wls \ mm-wls-svr-hasp-rs
# clresourcegroup online -eM mm-wls-svr-rg
# clresource create -t SUNW.wls -g mm-wls-svr-rg \
-p Confdir_list=/export/home/beamm/Oracle/Middleware/wlserver_10.3 \
-p Server_url=http://localhost:7003 \
-p Start_script=/export/home/beamm/Oracle/Middleware/user_projects/domains/obiee/bin/
startManagedWebLogic.sh \
-p "Server_name{phys-green1}"=ms1 \
-p "Server_name{phys-green2}"=ms2 \
-p smooth_shutdown=true \
-p resource_dependencies=mm-wls-svr-hasp-rs \
mm-wls-svr-rs
# clresource status -g mm-wls-svr-rg
=== Cluster Resources ===
Resource Name Node Name State Status Message
------------- --------- ----- --------------
mm-wls-svr-hasp-rs phys-green1 Online Online
phys-green2 Online Online
mm-wls-svr-rs phys-green1 Online Online - Service is online.
phys-green2 Online Online - Service is online.
# clresourcetype register ORCL.obiee_presentation_service
# clresource create -t ORCL.obiee_presentation_service \ -g mm-wls-svr-rg -p BI_INSTALL_DIRECTORY=/export/home/obiee/OracleBI \ -p BI_DATA_DIRECTORY=/export/home/obiee/OracleBIData \ -p Resource_dependencies_offline_restart=mm-wls-svr-hasp-rs \ mm-pres-svc-rs
# clresource status -g mm-wls-svr-rg
=== Cluster Resources ===
Resource Name Node Name State Status Message
------------- --------- ----- --------------
mm-wls-svr-hasp-rs phys-green1 Online Online
phys-green2 Online Online
mm-wls-svr-rs phys-green1 Online Online - Service is online.
phys-green2 Online Online - Service is online.
mm-pres-svc-rs phys-green1 Online Online - Service is online.
phys-green2 Online Online - Service is online.
Because the Oracle WebLogic Server Presentation Service plug-in sends requests to the local BI Presentation Service server process, the Oracle WebLogic Server resource must set an offline-restart dependency on the BI Presentation Service resource. This ensures that if a BI Presentation Service server is unavailable, the load-balancer stops sending requests to the Oracle WebLogic Server.
# clresource set \ -p Resource_dependencies_offline_restart=mm-pres-svc-rs \ mm-wls-svr-rs
When a multi-master configuration is used, connection is made through the logical hostname of the load-balancer resource. For example, if the Oracle iPlanet Web Server is running on logical host web-svr-lh, the URL is http://wls-svr-lh/analytics/saw.dll?Dashboard. The requests are then load-balanced to the underlying managed Oracle WebLogic Servers that listen on port 7003.