You use a combination of the Exalytics Domain Management Utility and manual steps to scale-out an existing Oracle Business Intelligence domain.
This section contains the following topics:
Parent topic: Deploying Oracle Exalytics for High Availability
Install Oracle Exalytics on the first Exalytics Machine using the instructions that are provided in Installing Business Intelligence Software on New Deployments of this guide before installing on the second Exalytics Machine.
Parent topic: Configuring for High Availability
To prepare the second Exalytics Machine:
Parent topic: Configuring for High Availability
You scale out the existing Oracle Business Intelligence domain by running the Exalytics Domain Management Utility.
Note:
The Exalytics Domain Management Utility only scales out and configures Oracle Business Intelligence. If you want to scale out and configure Oracle TimesTen, then install it manually on the second Exalytics Machine. See Step 4: Installing and Configuring Oracle TimesTen.
To scale out an Oracle Business Intelligence domain:
Parent topic: Configuring for High Availability
To install and configure Oracle TimesTen:
Enter the following commands:
cd /home/oracle/EXALYTICS_INSTALLERS/tt >./setup.sh instance name tt1122 [default chosen] install client/server and data manager [default chosen] specify particular location for install [3] enter location [custom location chosen /u01/app/oracle/product/TimesTen] create daemon home - [default chosen] daemon logs - [default chosen] accept default port no - 53396 restrict access to TT to group oracle? - Yes enable PL/SQL - yes [default chosen] TNS_ADMIN – not chosen during install. port for TT server - 53397 quickstart and doc - no [default chosen] doc without quickstart - yes [default chosen] - location default TT replication with clusterware - no - [default chosen]
Run the daemon configuration scripts for Oracle TimesTen as root, as described in Running the Daemon Configuration Scripts for Oracle TimesTen.
On the first Exalytics Machine, configure the BI Server to communicate with either instance of Oracle TimesTen by creating two DSNs for Oracle TimesTen, as described in Configuring the ODBC Connection from Oracle Business Intelligence to Oracle TimesTen.
On the second Exalytics Machine, perform the same procedure as in the previous step to create DSNs for Oracle TimesTen to configure the connectivity from the second BI Server to either instance of Oracle TimesTen.
Update the opmn.xml file on the second Exalytics Machine to point to the driver location for ODBC for Oracle TimesTen by editing the following "variable" elements. The edited text is shown in bold.
<variable id="LD_LIBRARY_PATH" value="$ORACLE_HOME/common/ODBC/Merant/5.3/lib$:$ORACLE_HOME/bifoundation/server/bin$:$ORACLE_HOME/bifoundation/web/bin$:$ORACLE_HOME/clients/epm/Essbase/EssbaseRTC/bin$:$ORACLE_HOME/bifoundation/odbc/lib$:$ORACLE_INSTANCE$:$ORACLE_HOME/lib:/u01/app/oracle/product/TimesTen/tt1122/lib" append="true"/> <variable id="TIMESTEN_DLL" value="/u01/app/oracle/product/TimesTen/tt1122/lib/libttclient.so"/>
The opmn.xml file is in the following directory:
/u01/app/oracle/product/fmw/instances/instance2/config/OPMN
Stop and start the Notification Server (OPMN).
Go to the following directory that contains the OPMN command-line tool:
/u01/app/oracle/product/fmw/instances/instance2/bin
Run the following command:
./opmnctl stopall
Stops OPMN and all Oracle Business Intelligence system components.
Go to the following directory that contains the OPMN command-line tool:
/u01/app/oracle/product/fmw/instances/instance2/bin
Run the following command:
./opmnctl startall
Starts OPMN and all Oracle Business Intelligence system components.
For more information, see "Using the OPMN Command Line to Start, Stop, Restart, and View the Status of System Components" in System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.
Validate that you can use a client/server DSN for Oracle TimesTen from the first Exalytics Machine by entering the following commands:
cd $ORACLE_INSTANCE/bifoundation/OracleBIApplication/coreapplication/setup/
. ./bi-init.sh (bash shell)
cd Times-Ten-root-dir/tt1122/bin
./ttisqlcs –connstr "uid=oracle;pwd=welcome1;dsn=bim_tt1";
These commands use the SQL client for Oracle TimesTen to connect to the Oracle TimesTen server on the first Exalytics Machine and validate that the BI Server can communicate with Oracle TimesTen.
Repeat the previous step for the client/server DSN for Oracle TimesTen from the second Exalytics Machine.
Parent topic: Configuring for High Availability
As part of the process of configuring the Exalytics Machine, you must configure various persistent stores to be located on a shared directory location such as a NAS (network attached storage). The following list outlines those stores and includes link for information on configuring them:
Repository for the Oracle BI Server. Specify a shared RPD publishing directory in Fusion Middleware Control to propagate online repository changes in a cluster. The master BI Server copies its local repository to this directory when online changes are made. When slave BI Servers start, if the version in the publishing directory is newer, then each slave server copies the version in the shared directory to its local disk.
For information, see Using Fusion Middleware Control to Upload a Repository and Set the Oracle BI Presentation Catalog Location in System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.
Oracle BI Presentation Catalog Location. Each Oracle BI Presentation Services instance loads the catalog from the catalog location that is specified in Fusion Middleware Control. Copy any existing catalogs to shared storage before reconfiguring this location to shared storage.
For information, see "Using Fusion Middleware Control to Upload a Repository and Set the Oracle BI Presentation Catalog Location" in System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.
Global cache. The global cache resides on a shared file system and stores purging events, seeding events (which are often generated by agents), and results sets that are associated with seeding events. Each BI Server maintains its own local query cache for regular queries. The query cache for the BI Server continues to be located on the local node.
For information, see "Using Fusion Middleware Control to Set Global Cache Parameters" in System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.
Parent topic: Configuring for High Availability
Configure a front-end load balancer, which is properly configured with the Oracle WebLogic Server Cluster Plug-in. For information, see "Configuring High Availability for Oracle Business Intelligence and EPM" in High Availability Guide.
Parent topic: Configuring for High Availability