This section describes how to configure the BI scheduler and create the appropriate Oracle Solaris Cluster resource groups and resources for both a failover and a multi-master case.
The failover BI scheduler configuration does not require a cluster controller because there is only one active BI scheduler process.
The schedulers need access to the Oracle Database client libraries and tnsnames.ora file to be able to connect to the scheduler database.
For more information, see the section “Configuration Tasks for Oracle BI Scheduler ” in the Oracle Fusion Middleware Scheduling Jobs Guide for Oracle Business Intelligence Enterprise Edition.
For more information, see the section “Configuring Oracle BI Scheduler Instances in a Clustered Environment” in the Oracle Fusion Middleware Scheduling Jobs Guide for Oracle Business Intelligence Enterprise Edition.
To access the Oracle client libraries, the scheduler uses parameters set in the BI_INSTALL_DIRECTORY/setup/user.sh file. Uncomment and provide appropriate values for the Oracle Solaris entries:
$ cat ~/OracleBI/setup/user.sh … ORACLE_HOME=/export/home/oracle/app/oracle/product/11.1.0/client_1 export ORACLE_HOME TNS_ADMIN=$ORACLE_HOME/network/admin export TNS_ADMIN PATH=$ORACLE_HOME/bin:/opt/bin:$PATH export PATH LD_LIBRARY_PATH_64=$ORACLE_HOME/lib: $LD_LIBRARY_PATH_64:/opt/jdk/jdk1.6.0_20/jre/lib/sparc export LD_LIBRARY_PATH_64 …
$ cd Oracle-BI-Install-dir/setup $ . ./sa-init64.sh $ schconfig
Set the Data Source Name to the scheduler database service name in the tnsnames.ora file.
Set the User Name and Password to the user name and password that you use to access the scheduler database.
Set the Scheduler Script Path and Default Script Path to locations that reside on a global file system.
To simplify setup and to avoid having to use certificates, set the Administrator Password to null.
Set Participant in Cluster to False.
Set the SAW Machine Name to the logical hostname of the Presentation Services tier.
The schconfig utility modifies the BI_DATA_DIRECTORY/scheduler/config/instanceconfig.xml file.
# clresourcetype register ORCL.obiee_scheduler
# clresource create -g bi-svr-rg \ -t ORCL.obiee_scheduler \ -p Run_64_bit=True \ -p Resource_dependencies_offline_restart=bi-svr-hasp-rs,bi-svr-lh-rs \ -p BI_INSTALL_DIRECTORY=/failover/obiee/OracleBI \ -p BI_DATA_DIRECTORY=/failover/obiee/OracleBIData \ bi-sch-rs
# clresource status bi-sch-rs
=== Cluster Resources ===
Resource Name Node Name State Status Message
------------- --------- ----- --------------
bi-sch-rs phys-red1 Online Online - Service is online.
phys-red2 Offline Offline
A multi-master BI Scheduler configuration requires primary and secondary BI Cluster Controllers to be configured as explained in BI Cluster Controller Configuration, although strictly speaking, the secondary BI Cluster Controller is optional when creating an Oracle Solaris Cluster configuration. The BI Cluster Controller is responsible for directing requests coming in from the Presentation Services clients to the active BI scheduler.
The schedulers need access to the Oracle Database client libraries and tnsnames.ora file to be able to connect to the scheduler database.
For more information, see the section “Configuration Tasks for Oracle BI Scheduler ” in the Oracle Fusion Middleware Scheduling Jobs Guide for Oracle Business Intelligence Enterprise Edition.
For more information, see the section “Configuring Oracle BI Scheduler Instances in a Clustered Environment” in the Oracle Fusion Middleware Scheduling Jobs Guide for Oracle Business Intelligence Enterprise Edition.
In order to access the Oracle client libraries, the scheduler uses parameters set in the BI_INSTALL_DIRECTORY/setup/user.sh file. Uncomment and provide appropriate values for the Oracle Solaris entries.
$ cat ~/OracleBI/setup/user.sh … ORACLE_HOME=/export/home/oracle/app/oracle/product/11.1.0/client_1 export ORACLE_HOME TNS_ADMIN=$ORACLE_HOME/network/admin export TNS_ADMIN PATH=$ORACLE_HOME/bin:/opt/bin:$PATH export PATH LD_LIBRARY_PATH_64=$ORACLE_HOME/lib: $LD_LIBRARY_PATH_64:/opt/jdk/jdk1.6.0_20/jre/lib/sparc export LD_LIBRARY_PATH_64 …
$ cd Oracle-BI-Install-dir/setup $ . ./sa-init64.sh $ schconfig
Set the Data Source Name to the scheduler database service name in the tnsnames.ora file.
Set the User Name and Password to the user name and password that you use to access the scheduler database.
Set the Scheduler Script Path and Default Script Path to locations that reside on a global file system.
To simplify setup and to avoid having to use certificates, set the Administrator Password to null.
Set Participant in Cluster to True.
Set the SAW Machine Name to the physical host name of the Presentation Services component.
The schconfig utility modifies the BI_DATA_DIRECTORY/scheduler/config/instanceconfig.xml file.
# clresource create -g mm-bi-svr-rg \ -t ORCL.obiee_scheduler \ -p BI_INSTALL_DIRECTORY=/export/home/obiee/OracleBI \ -p BI_DATA_DIRECTORY=/export/home/obiee/OracleBIData \ -p Resource_dependencies_offline_restart=mm-bi-svr-hasp-rs \ mm-bi-sch-rs
# clresource status mm-bi-sch-rs
=== Cluster Resources ===
Resource Name Node Name State Status Message
------------- --------- ----- --------------
mm-bi-sch-rs phys-red1:red-zone1 Online Online
phys-red2:red-zone2 Online Online