Setting Up Shared Files and Directories

When you have multiple instances of a given Oracle Business Intelligence component, files and directories including global cache and shared Oracle BI Scheduler scripts are located on a shared storage device (such as NAS or SAN).

Using shared files and directories simplifies management of your system (see the following illustration) including scale out of Oracle Business Intelligence components.

Description of GUID-9B285BA5-0FE7-49E7-A0DC-82BA929963F2-default.png follows
Description of the illustration GUID-9B285BA5-0FE7-49E7-A0DC-82BA929963F2-default.png

This section contains the following topics:

Changing the Singleton Data Directory (SDD)

Oracle Business Intelligence metadata is stored in a singleton data directory (SDD).

The default location is set to:

DOMAIN_HOME/bidata

The SDD path is defined in the file bi-environment.xml, located in:

DOMAIN_HOME/config/fmwconfig/bienv/core/bi-environment.xml

See Key Directories in Oracle Business Intelligence.

  1. Create a shared directory and make sure it is available on all hosts.

    For example, on Windows:

    dir \\example.com\dir

    For example, on UNIX:

    ls /oraclehome/user_projects/domains/bi/bidata

  2. Stop all Oracle Business Intelligence processes by running the following command located in:

    DOMAIN_HOME/bitools/bin

    For example on UNIX enter:

    ./stop.sh
  3. Backup the file bi-environment.xml, and existing SDD if desired.
  4. Open the file bi-environment.xml for editing, and specify the singleton path.

    For example:

    <bi:singleton-data-directory>/oraclehome/user_projects/domains/bi/bidata/</bi:singleton-data-directory>
  5. Save the file.
  6. Copy the contents of the bidata directory to the shared directory previously created.
  7. Start all Oracle Business Intelligence processes by running the following command located in:

    DOMAIN_HOME/bitools/bin/

    For example on UNIX enter:

    ./start.sh

The SDD is now configured for all host computers.

Setting Up the Global Cache

The global cache is a query cache that is shared by all Oracle BI Servers participating in a cluster.

See About the Global Cache.

It is recommended that you configure the global cache so that cache seeding and purging events can be shared by all Oracle BI Servers participating in a cluster.

  1. Use the Performance tab of the Oracle Business Intelligence Instance Configuration page in Fusion Middleware Control to set the Global cache path and Global cache size options.