Setting Up Active-Passive Essbase Clusters

If you set up an active-passive Essbase cluster using EPM System Configurator, you must perform additional steps to set up Essbase failover on both cluster nodes.

  To complete the setup of the Essbase active-passive cluster:

  1. Update EPM_ORACLE_INSTANCE/config/OPMN/opmn/opmn.xml to specify the OPMN service failover network topology. In the <notification-server interface> section, add the <topology> section. For example:

    <notification-server interface="any">
         <ipaddr remote="hostName" />
         <port local="portNumber" remote="portNumber" />
         <ssl enabled="true" wallet-file="\Oracle\Middleware\user_projects\epmsystem1\config\OPMN\opmn\wallet"/>
         <topology>
             <nodes list="nodeName1:nodeRemotePort1,nodeName2:nodeRemotePort2"/>
         </topology>
    </notification-server>
    
  2. In the same section of the file, update hostName to match the nodeName for this machine.

    Oracle recommends using a fully qualified name.

  3. In the same section of the file, enable or disable SSL communication as the communication mechanism between the OPMN servers in the failover nodes. By default, the ssl enabled parameter is True.

    To enable SSL , you must also recreate the wallet file on both nodes of the cluster. The wallet file parameters must be the same on both machines.

    To disable SSL communication, change the ssl enabled parameter to False. For example:

    <notification-server interface="any">
         <ipaddr remote="hostName" />
         <port local="portNumber" remote="portNumber" />
         <ssl enabled="false" wallet-file="\Oracle\Middleware\user_projects\epmsystem1\config\OPMN\opmn\wallet"/>
         <topology>
             <nodes list="nodeName1:nodeRemotePort1,nodeName2:nodeRemotePort2"/>
         </topology>
    </notification-server>
    

    where nodePort1 and nodePort2 are the remote ports of OPMN on each machine in the cluster.

  4. Update opmn.xml to enable service failover for Essbase. In the <ias-component id="Essbase"> section, add service-failover="1". For example:

    <ias-component id="Essbase">
         <process-type id="EssbaseAgent" module-id="ESS" service-failover="1" service-weight="100">
  5. In the <ias-component id="Essbase"> section of opmn.xml, for the first node, change service-weight="100" to service-weight="101" . For the second node, keep the value at 100.

  6. Update opmn.xml to reflect the name of the cluster. In the <ias-component id="Essbase"> section, change id="Essbase" from “Essbase” to the name of the cluster. For example, change:

    <ias-component id="Essbase">

    to

    <ias-component id="EssbaseClusterName">
  7. In opmn.xml, remove "numprocs" from the process set definition and change the restart-on-death value to “true”. For example edit the following section:

    <process-set id="AGENT" numprocs="1" restart-on-death="false">

    as follows:

    <process-set id="AGENT" restart-on-death="true">