This post will be helpful to do installation and configuration of New Oracle BI Apps 11.1.1.7.1
without any issues.
Key Points to Remember:
- Recommended OBIEE installation Type is Enterprise.
- While Configuring BI Apps, BI Administrator user name should not be “weblogic”, “Administrator” or "Supervisor". Or else it will fail @ Configuring ODI.
- Upgrade to Oracle weblogic server 10.3.6 is mandatory to enable links and other controls for Configuration Manager and Functional Setup Manager.
- ODI 11.1.1.7.0 Studio UI does not support JDK 7.
- Execute configApps.bat only from command Prompt. Or else it implicitly Call Config.bat, which will start OBIEE Configuration.
- Oracle Database 11.2.0.3 is recommended, available at My Oracle Support.
- Avoid spaces for any Directory/Folder Paths.
- All the Fusion Products need to be installed onto same Middleware Home.
- Only BI Application Administrator Username should be used for ODI, BIACM and Functional Step at login screen to make any changes/modify.
- OBIEE 11.1.1.7.0 installation of type Software only will cause failures if you apply all the recommended patches.
Installation Steps:
Perform the below procedure in the given order without missing any step.
- Install JDK 1.6 Update 43.
- Install 7-Zip Or else Install WinZip with Command Line Add-on. Required to apply patches using Perl script.
- Run the Fusion Middleware RCU to create BIPLATFORM, MDS, SOAINFRA and ORASDPM Schemas.
- Install OBIEE 11.1.1.7.0 with Enterprise Install Type.
- Install ODI 11.1.1.7.0. @ Step 7 of 14 select Skip Repository Configuration.
- Install SOA Suite 11.1.1.7.0 as a Pre-requisite for Oracle Indirect Spend Planning.
- Copy all dumps (5 files) from <BIApps_RCU_Installer>\rcu\integration\biapps\schema to C:\BIApps_Schemas.
Note: Avoid copying the files to a location with a long
directory path.
- Run BI Apps RCU to create schemas for all the Oracle Application Components:
Ø Oracle Business Intelligence Applications.
Ø Oracle Business Analytics Warehouse | DEV_DW
Ø Oracle Business Intelligence Applications Components | DEV_BIACOMP
Ø Oracle Data Integration Master and Work Repository | DEV_BIA_ODIREPO
Ø Oracle Operation Planning
Ø Oracle Operation Planning | DEV_OPL
At Step 6 of 8, Alter the Size and Max. Size values for the following 4 tablespaces, leave the remaining attributes to default values. (This can be done by selecting manage tablespace option.
Ø DEV_DW_DATA Size: 20 GB | Maximum Size: Unlimited
Ø DEV _DW_IDX Size: 5 GB | Maximum Size: Unlimited
Ø DEV_DW_STG Size: 10 GB | Maximum Size: Unlimited
Ø DEV_DW_TEMP Size: 15 GB | Maximum Size: Unlimited
- Install Oracle BI Apps 11.1.1.7.1 using Generic Installer, will perform Software Only Installation.Installation Location should be Oracle Home for BI. Example: Oracle_BI1.
- Stop all the BI services, before you apply these patches.
- Extract the contents of the three downloaded zip files containing the patches into the same directory. The patches contains in folders: biappsshiphome, odi, soa, weblogic and oracle_common.
- To apply these patches, edit two files before executing the Perl Script located at path D:\oracle\middleware\Oracle_BI1\biapps\tools\bin.
Ø Update the parameter input file
apply_patches_import.txt as follows according to your system paths:
JAVA_HOME=
D:\oracle\middleware\Oracle_BI1\jdk
INVENTORY_LOC=C:\Program
Files\Oracle\Inventory
ORACLE_HOME=D:\oracle\middleware\Oracle_BI1
MW_HOME=D:\oracle\middleware
COMMON_ORACLE_HOME=D:\oracle\middleware\oracle_common
WL_HOME=D:\oracle\middleware\wlserver_10.3
SOA_HOME=D:\oracle\middleware\Oracle_SOA1
ODI_HOME=D:\oracle\middleware\Oracle_ODI1
WORKDIR=
D:\BIApps_Patches
PATCH_ROOT_DIR=
D:\BIApps_Patches
Note: WORKDIR is the
directory in which patch logs will be shown and PATCH_ROOT is the directory
where all patches are extracted.
Ø Update the Perl Script APPLY_PATCHES.pl as
follows:
The WinZip Command Line Support Add-On provides a command line interface that
allows you to use WinZip directly from the command prompt. Get it from http://www.winzip.com/downcl.htm
For
Winzip:
For
7-Zip:
Now execute the command as:
Configure OBIA:
Important note:
1. Run the configApps.bat from
command prompt, to include system variable which will Extend BI. (Don’t double-click on configApps.bat batch file)
2. At Step 7, BI Administrator user name should not be “weblogic”, “Administrator”
or "Supervisor". Or else it will fail @ Configuring
ODI.
- Before running the configApps.bat process, ensure that Node Manager and All BI Services are up and running.
- To Configure Oracle BI Applications and Indirect Spend planning. Go to BI_Oracle_Home/bin and run configApps.bat.
- Enter the correct details accordingly in each step and proceed next screen.
Download upgrade patch p13529623_1036_Generic.zip from My
Oracle Support and unzip and execute it with the following command:
java –D64 –jar –Xmx104m
wls1036_upgrade_generic.jar
