Use these instructions to install and configure Oracle BI Applications.
You must perform the following procedures in the order they are listed:
Business Analytics Warehouse schema
Oracle BI Applications Components Repository (for Configuration Manager and Functional Setup Manager)
Oracle Data Integrator Repository for Oracle BI Applications (includes Master and Work repositories)
Note these points:
For this release of Oracle BI Applications, the following components are supported only on Oracle Database Enterprise Edition:
Business Analytics Warehouse
BI Applications Components Repository
Oracle Data Integrator Repository for BI Applications
To identify the specific version of Oracle Database Enterprise Edition supported for this release of Oracle BI Applications, go to the Oracle Fusion Middleware Supported System Configurations page at http://www.oracle.com/technetwork/middleware/ias/downloads/fusion-certification-100350.html and see System Requirements and Supported Platforms.
The Oracle Database Enterprise Edition must be configured with UNICODE.
The Business Analytics Warehouse, BI Applications Components Repository, and Oracle Data Integrator Repository can be installed on different database servers.
The Oracle Data Integrator Master and Work repositories are installed into the same schema.
Review Guidelines for Setting Up Oracle Business Analytics Warehouse Databases for information about database requirements for the Business Analytics Warehouse.
You must run the Business Analytics Applications Suite RCU to create schemas for Oracle Business Analytics Warehouse, Oracle Business Applications Components, and Oracle Data Integrator Repository for Oracle BI Applications.
Before you run the Business Analytics Applications Suite RCU, note these points:
On Windows systems, make sure that you unzip the downloaded RCU .zip file into a directory that does not have spaces in the directory path.
The RCU uses .dmp files to create the required schemas. You must copy the .dmp files for each schema to a directory with global write access on the appropriate database servers. (RCU writes log files to this directory.) The .dmp files are located in BIA_RCU_HOME/rcu/integration/biapps/schema
.
To create schemas with RCU on Oracle databases, you must possess the DBA privilege and be logged in as SYSDBA (for example, as user SYS,
with the SYSDBA role selected).
If you are creating schemas on different databases, then you will need to run RCU multiple times, once for each database connections, because the database connections are different for the different database servers.
To create the Oracle BI Applications schemas using the Business Analytics Applications Suite RCU:
Run the Business Analytics Applications Suite installer to install Oracle BI Applications. This installer runs in software-only mode. You must run the Business Analytics Applications Suite installer on the system where you ran the Oracle BI EE installer. All files are installed to disk in the Oracle Home for BI directory. Note that you will perform post-installation steps to configure Oracle BI Applications in a later procedure.
The installer is a generic installer and requires JDK or JRockit to be installed. See JDK or JRocket Installation.
35 GB free disk space is required to run the Business Analytics Applications Suite installer. This disk space will be released after the installer finishes.
Apply the appropriate platform patches during the installation process.
Apply these patches to complete your installation:
Fusion Middleware bundle patch OBIEE 11g 11.1.1.7.150120
Oracle BI EE Client installer patch 19190111 (included in the Oracle Business Intelligence Applications 11.1.1.9.2 media pack).
If installing Fusion Middleware on Windows, install patch 18600348, which you can obtain at http://aru.us.oracle.com:8080/ARU/ViewPatchRequest/process_form?aru=18600348
Apply the Oracle BI EE Client installer patch 19190111 (included in the Oracle Business Intelligence Applications 11.1.1.9.2 media pack) on Windows system where the BI Administration Tool has been installed.
System administrators must provide the BI EE Client Installer executable to developers who have installed the BI Administration Tool on Windows systems.
Use these instructions to update the ATGLite data in the BIACOMP schema.
Use these instructions to update the FSM data in the BIACOMP schema.
You configure the BI Domain by running the config.bat
or config.sh
file.
The config.bat
and config.sh
files are located in ORACLE_HOME/bin
.
When running the script, do these tasks:
On the Create or Scale Out BI System screen, select Create New BI System.
On the Configure Components screen, for Oracle BI Applications, you must select the following four options:
Business Intelligence Enterprise Edition.
Business Intelligence Publisher (will be automatically selected).
Real-Time Decisions.
Essbase Suite.
Note:
Don't scale out the BI Domain.You'll need to run the configApps.bat
or configApps.sh
file to extend the BI Domain to deploy Oracle BI Applications and to configure the components.
Oracle BI Applications Configuration Manager, Functional Setup Manager, ODI Java EE Agent, ODI Console, and Load Plan Generator are deployed into WebLogic Server.
Component wiring is performed.
A BI Applications Administrator User (with full access to Configuration Manager and access to ODI with the Supervisor role) is created in WebLogic Server embedded LDAP.
The Oracle Data Integrator Repository for Oracle BI Applications is configured and set to use external authentication (that is, authentication against the WebLogic Server embedded LDAP).
The configApps.bat
and configApps.sh
files are located in ORACLE_HOME/bin
.
Oracle BI Applications requires the BI and Oracle Data Integrator Managed Servers (bi_server1 and odi_server1) to be started using Node Manager. This is required so that parameters, memory, and JVM arguments are appropriately set. If you do not start the BI and Oracle Data Integrator Managed Servers, functionality loss and memory issues can occur in Oracle BI Applications Configuration Manager, Functional Setup Manager, and Oracle Data Integrator.
To ensure that the BI and Oracle Data Integrator Managed Servers are started using Node Manager, start them using the WebLogic Administration Console user interface. Do not start the BI and Oracle Data Integrator Managed Servers using the Managed Server start scripts.
You can design and manage the ODI Repository by using the ODI Studio desktop client. ODI Studio is typically installed on developer systems. The supported operating systems for ODI Studio are Windows 32-bit and 64-bit and Linux 32-bit.
You install ODI Studio using the Oracle Data Integrator installer.
On the Select Installation Type screen, select Developer Installation as the installation type and both options under Developer Installation, that is, ODI Studio (with local agent) and ODI SDK.
On the Repository Configuration screen, select the Skip Repository Configuration option.
For instructions on installing ODI Studio, see Oracle Fusion Middleware Installation Guide for Oracle Data Integrator.
The Oracle Data Integrator Repository is configured for external authentication against the WebLogic Server embedded LDAP server. ODI Studio must be configured to use the appropriate security files for authentication. You must perform these steps on all installations of ODI Studio.
Note:
You must perform these steps even if ODI Studio has been installed on the machine where Oracle Home for BI resides.To configure user access for ODI Studio:
The ODI Studio patch is available in PATCH_ROOT_DIR/odi/generic
.
For an explanation of the PATCH_ROOT_DIR, see Applying Platform Patches.
System administrators must provide this patch to developers who have installed ODI Studio on their systems. Follow the instructions in the Patch Readme to apply the patch on ODI Studio.
Note:
If you installed ODI Studio on the BI Domain host machine, you don't have to apply the patch.During installation of Oracle BI Applications, source files are installed in the BI_Oracle_Home/biapps/etl directory. These files are used during the ETL process and will be configured by functional developers. You must copy these files to a location that ODI Agent deployed in WebLogic Server can access but that is outside of the Oracle Home directory; otherwise, when the Oracle BI Applications environment is upgraded or patched, these files will be overwritten.
The next steps in the installation and setup process are to perform the system setup tasks and configure BI Applications–ODI Authentication to external (OID).
See Performing Post-Installation System Setup Tasks . These tasks are required to complete integration of the Oracle BI Applications components and to ready the system for functional configurations and data loads.
Steps to Configure BI Applications–ODI Authentication to External (OID)
Oracle Business Intelligence uses the Oracle WebLogic Server LDAP directory for authentication by default. The BI Applications installation on the BI EE platform requires the use of the embedded Weblogic LDAP. Once BI Applications has been installed and set up, you can be configured it to use an external LDAP for authentication.
Prerequisite: BI Applications 11.1.1.9.1+ has been installed into the BI Domain where the default Weblogic embedded LDAP is used for authentication.
Note:
The BI Applications installation will fail if an external LDAP system is being used. If you have configured the BI system for use with an external LDAP (for example, Oracle Internet Directory), then you must re-configure to use the default Weblogic embedded LDAP before you perform the BI Applications installation