Oracle Business Intelligence Application Architect
☎ +91 9994883085
Don't miss

Saturday, 7 June 2014

OBIA Installation and configuration in Linux

By on 18:24:00

Installing and Configuring Oracle BI Applications:

Create a folder /OBIA_RCU_LOG and give all global permission to it.
Copy .dmp files from /Softwares/OBIA11.1.7.1/OBIA_RCU/rcu/integration/biapps/schema
To /OBIA_Schemas having global write access (RCU writes log files to this directory.)

Creating Schemas Using Business Analytics Applications Suite RCU:
$ su oracle (run with oracle user as permissions are not available for others)
$cd /Softwares/OBIA11.1.7.1/OBIA_RCU/bin

Password: Admin123

Click on Manage Tablespaces and modify existing tablespace values as below:
Ø  DEV_DW_DATA Size: 20 GB | Maximum Size: Unlimited
Ø  DEV _DW_IDX Size: GB | Maximum Size: Unlimited
Ø  DEV_DW_STG Size: 10 GB | Maximum Size: Unlimited
Ø  DEV_DW_TEMP Size: 15 GB | Maximum Size: Unlimited

Business Analytics Applications installation as shown below:
Run with new_obiee11g user
chown -R new_obiee11g:dba /BI/obiee11g_home
$cd /Softwares/OBIA11.1.7.1/biappsshiphome/Disk1  
$ ./runInstaller -jreLoc /BI/obiee11ghome/Oracle_BI1/jdk

Applying Platform Patches

Change values for file /BI/Obiee11GHome/Oracle_BI1/biapps/tools/bin/apply_patches_import.txt as below:

# Required - Inventory Location
# Required - An existing writable directory to create logs and temp patch files
# Required - Path of patch directory till the release patch-set folder which is inside patches4fa/dist.
# i;e the patch-set folder for a particular release to apply patch from
# eg; /scratch/aime/tmp/ps1/biappsshiphome/patches4fa/dist/ps6rc3
Run the below script:
perl /BI/ OBIEE11GHome/Oracle_BI1/biapps/tools/bin/ 

Installing Fusion Middleware Patches :
$cd /BI/OBIEE11GHome/Oracle_BI1/bin
$ ./

/BI/obiee11ghome /Oracle_BI1
/BI/obiee11ghome /wlserver_10.3
/BI/obiee11ghome /user_projects/domains/bifoundation_domain
/BI/obiee11ghome /instances/instance1

Password: Admin123

Username: OBIA11G
Password: Admin123

Password: Admin123

Password: obiee

Upgrading Weblogic to 10.3.6:
Download patch p13529623_1036_Generic from oracle metalink.
Follow the below document for the installation:

Generating Security Files for ODI Studio
1.   Copy cwallet.sso and jps-config-jse.xml from:

2.   Edit <ODI_Home>/oracledi/client/odi/bin/odi.conf by updating the JPS configuration file name as follows:

Update BIACOMP schema with ATGLite Patch scripts:
Connect BIACOMP schemas and run below script located script

Installing Oracle BI Applications Load Plan Generator Plug-In:

The ZIP file is installed in the Oracle Home for BI directory, at <BI_Oracle_ Home>/clients/biappsclients/odi/
Follow the instructions in the Readme file to extract the ZIP file and deploy the jar files.

Connect to ODI with creating connection as below:
$ cd /BI/OBIEE11GHome/Oracle_ODI1/oracledi/client/

Follow below link for the instructions:


OBIA Installation and configuration in Linux

OBIA Installation and configuration in Linux

OBIA Installation and configuration in Linux
Click on Create

OBIA Installation and configuration in Linux

OBIA Installation and configuration in Linux

Upgrading weblogic to 10.3.6
Follow below Doc:


Post a Comment

Blog Archive


1z0-482 Dumps (2) 1Z0-525 Dumps (1) BI Apps Installation (1) BI Publisher Interview Questions (1) BICS (2) Business Intelligence (1) DATA WAREHOUSE ADMINISTRATOR CONSOLE (18) Data Warehousing (48) E-BIZ R12 (1) E-BIZ R12 INSTALLATION (1) Essbase (1) hmailserver (1) Hyperion (1) Hyperion Essbase (2) Hyperion Essbase Interview Questions (1) Hyperion financial management (1) Informatica (163) Informatica Installation 9.6.1 (2) Informatica Interview Question (47) Informatica Online Training (1) informatica scenarios questions (1) Informatica Training (1) Informatica Training Chennai (1) JAVA (1) linux (1) Normalization in Oracle (1) OBIA (1) OBIA (3) OBIA Installation (33) OBIEE (2) OBIEE 10G (8) OBIEE 11G (138) OBIEE 11g dumps (2) OBIEE 11g Interview Questions (1) OBIEE 12c (20) OBIEE 12c Architecture (1) OBIEE 12C TRAINING (1) OBIEE certification (2) OBIEE Interview Question (1) OBIEE Publisher Interview Questions (1) OBIEE TRAINING CHENNAI (1) OBIEE TRAINING ONLINE (1) ODI (Oracle data integrator) (2) odi 11g certification (1) ODI dumps (2) Oracle Administrator (20) Oracle Business Intelligence Application (3) Oracle Data Integrator (2) Oracle Data Integrator Interview questions for experience (1) Oracle Database (3) Oracle Database 12c Installation steps (3) Oracle Database Installation in Linux 6 (2) Oracle E-Business R 12.3 (1) Oracle Hyperion Planning and Budgeting Questionnaire (2) oracle Joins (1) Power BI (5) RCU INSTALLATION (1) scorecard in obiee 11g (1) SQL (3) SQL Interview Questions (1) sql server 2008 (2) Sql server installation (1) WinSCP (1)