Skip to content
  • Technology
  • Data

Installing an Oracle BI 12C cluster

by Antony Heljula

Here, we are going to explain how to scale out a standalone OBIEE 12c node to a 2-node cluster.

The scale-out process with 12c is very different to the previous 11g version, since you perform more manual steps using the command line rather than via a GUI.   But the overall process is a lot slicker / simpler than 11g.

Before we start to scale-out, you should have the first OBIEE node completely installed and working.  The second node should also be installed (weblogic and OBIEE) but not configured (using config.sh).  

Furthermore, you need a shared file system mounted at the same location on both nodes, this shared folder is where the RPD, catalog and cache get stored (you no longer have RPDs stored locally on each BI Server).

The shared file system can be a network share (e.g. NFS) or a clustered file system (e.g. OCFS2).

PREREQUISITES

  • You have two OBIEE servers e.g. binode1 and binode2

  • You have shared storage (e.g. clustered file system or network share) accessible to both servers and is mounted at the same location on both. For example:

    • /app/oracle/oraclebi_shared

  • On the first server (binode1) you have performed the following tasks:

    • Installed Weblogic Server

    • Installed Oracle BI 12c

    • Run the configuration for Oracle BI 12c (config.sh)

  • On the second server (binode2) you have performed the following:

    • Installed Weblogic Server To the exact same locations

    • Installed Oracle BI 12c } as on binode1

NOTE: You should not run the OBIEE config.sh utility on binode2

SCALE-OUT PROCESS

  1. binode1: Stop your OBIEE environment:

    [home]/user_projects/domains/bi/bitools/bin/stop.sh

  2. binode1: Edit the “bi-environment.xml” file and set the location of the shared folder that you intend to use as the OBIEE cluster share location

    [home]/user_projects/domains/bi/config/fmwconfig/bienv/    core/bi-environment.xml

    <bi:singleton-data-directory>

    /app/oracle/oraclebi/oraclebi_share/bidata

    </bi:singleton-data-directory>

    NOTE:  You need to copy your existing "bidata" folder locationto this shared location.
    The folder is located in your Domain Home e.g. [home]/user_projects/domains/bi/bidata

  3. binode1: Start your OBIEE environment:

    [home]/user_projects/domains/bi/bitools/bin/start.sh

  4. Log on to Enterprise Manager as weblogic:

    http://[host]:9500/em

  5. Navigate to “Business Intelligence > biinstance > Configuration > Performance

  6. Click “Lock & Edit”:
    260_75___1260_75__1_Image2.png

  7. Set the location and size of your BI “global cache”, the location should be on your shared folder location:

    e.g. /app/oracle/oraclebi_share/bicache

  8. Click “Apply”

  9. Click “Activate Changes”

  10. binode1: Log on as your oracle user and navigate to   the following folder:
    [home]/user_projects/domains/bi/bitools/bin

  11. binode1: Stop your OBIEE environment:
    ./stop.sh

  12. binode1: Run the following command to create a pack  file to scale out your 2nd node:
    ./clone_bi_machine.sh [-m <new machine name>]  <new machine ip address> <pack file>
    e.g.
    ./clone_bi_machine.sh -m binode2 10.10.8.51   binode2.jar

  13. binode1: Copy the pack file (e.g. binode2.jar) to binode2

  14. Binode2: Log on as your oracle user to binode2 and run the following command:[home]/oracle_common/common/bin/unpack.sh -domain=[home]/user_projects/domains/bi -template=     [pack file]
    e.g.
    /app/oracle/oraclebi/oracle_common/common/bin/unpack.sh -domain=/app/oracle/oraclebi/user_projects/domains/bi -template=/home/oracle/binode2.jar

  15. binode1: Login again as oracle to your binode1, change directory to the “bitools/bin” folder
    [home]/user_projects/domains/bi/bitools/bin

  16. binode1: Run the following command:
    ./sync_midtier_db.sh

  17. binode1: Copy the contents of the original local “bidata” folder to the equivalent folder on your shared folder location. For example:
    cp -R /app/oracle/oraclebi/user_projects/domains/bi/bidata /app/oracle/oraclebi_share

  18. binode2: On your new machine binode2, start Node Manager: nohup [home]/user_projects/domains/bi/bin/startNodeManager.sh &

  19. binode1: Back on binode1, start your OBIEE environment once again:
    [home]/user_projects/domains/bi/bitools/bin/start.sh

Your clustered OBIEE environment will now start……and the bi_server2 managed server will be created, so it will take longer than usual to start up! That's it..!!

Antony Heljula's avatar

Antony Heljula

Technology Director

Contact Antony

Our recent blog posts

Transformation is for everyone. We love sharing our thoughts, approaches, learning and research all gained from the work we do.

Tech Blog Umbraco Codegarden 2023 Header

Umbraco Codegarden 2023

Recently, a couple of our team had the opportunity to attend the annual Umbraco conference known as Codegarden.

The Internet of Things

This is a series of posts about the Internet of Things (IoT). In this first piece I give a brief overview of what it is and highlight some key enablers for current and emerging IoT technologies.

Understanding Linked Data principles

If an interoperable web of data is the goal; linked data can help get us there. Here we explain the principles behind linked data, with examples to show what it looks like and why it's so useful.