In today’s post will see Oracle Business Intelligence Applications installation and configuration(220.127.116.11.2) with Oracle Data Integrator (18.104.22.168)
- Biapp01.hussain.net = 192.168.0.128
- Biappdb01.hussain.net = 192.168.0.129
- OBIEE = 22.214.171.124
- ODI = 126.96.36.199
- OBIA = 188.8.131.52.2
- RDBMS = 184.108.40.206.0
Document followed :
Video URL for Step-by-Step Installation of OBIA:
- Install and configure Oracle RDBMS 220.127.116.11 software.
- Create a database with unicode characterset.
- Using RCU 18.104.22.168 create OBIEE repositiories.
- Install and configure OBIEE 22.214.171.124
- Install ODI 126.96.36.199 binaires on the server.
- Using OBIA RCU, create repositoires for OBIA.
- Install OBIA 188.8.131.52.2 binaries on the server.
- Apply FMW technology patches.
- Upgrade ATGLite, FSM, BIACM components using psa utility.
- Configure BIAPPS using configApps.sh script.
- Check all consoles, Admin, Analytics, Configuration Manager, Functional Setup Manager, ODI console.
- Install and configure OBIEE Client Administration tool and check by connecting to RPD online.
- Install and configure ODI client and check by connecting to work repository.
- Create one sample target source from Configuration Manager and check the connectivity.
Installation and Configuration of Oracle RDBMS 184.108.40.206.0:
Invoke netca to configure LISTENER:
Creation of database and using unicode characterset:
Create OS user for biapps software and use OBIEE RCU to create OBIEE related repositories:
Invoke runInstaller from OBIEE software to Install and Configure OBIEE:
Invoke OBIA RCU to create repositories related to Oracle Business Intelligence Applications:
Here with OBIA RCU, we will get dump files of repositories, copy the same to database node where we are creating repositories and give the same patch in RCU window.
Increase the below tablespace size as below:
Installation and configuration of OBIA:
Give the existing the BI home for OBIA as well:
Invoke runInstaller from Oracle Data Integrator software folder to install ODI:
After the Installation of OBIEE, ODI, OBIA, have to apply technology patches and the patches you can get from Oracle edelivery.
Edit the below file and give appropriate variable values and execute the perl command to apply patches.
Upgrade the ATGLite, FSM, BIACM components through psa utility which will be available in $ORACLE_COMMON_HOME/bin
Configure OBIA using configApps.sh script which will be under Oracle BI home.
After successful installation, we can see below servers in weblogic console.
Configuration Manager console:
Function Setup Manager Console:
Now, we are trying to download OBIEE Admin tool software from analytics console and installing it to connect RPD.
Successfully able to connect RPD through OBIEE Admin tool.
Now, installing ODI studio at client machine.
Copy the below files to Oracle ODI installed directory and also copy the source files to one desired etl directory which should be out of BI Oracle home.
Creating one source system (EBS DB in my case) and testing the connectivity: