OBIEE
12c Linux Fresh installation
Oracle released Oracle Business Intelligence 12c (12.2.1.0.0). New features in 12c include an updated and cleaner
look-and-feel, Visual Analyzer that brings Tableau-style reporting to OBIEE
users along with another new feature called “data-mashups”, enables
users to upload spreadsheets of their own data to combine with their main
curated datasets. Let me guide you to
install 12c on linux and it will be the even easy on windows environment as
well.
Steps to install OBIEE 12c are the following:
1.
Review system certification
2.
Install database for repository (or use existing)
3.
Download software distributives
4.
Install
5.
Configure
Review system certification
You can find a certification
matrix here. Download "System Requirements and Supported Platforms for
Oracle Fusion Middleware 12c (12.2.1)" and ensure your system is certified
and patch level is appropriate. Right now certified OSes are Oracle
Linux/Redhat Linux 6/7, SLES 11, HP-UX 11.31, IBM AIX 7.1, MS Windows Server
2012/2012 R2, Oracle Solaris 11 (both Sparc and x86_64).
Install database for repository (or use existing)
As for the previous release, OBIEE need a database to store a
repository. You will find a list of certified Databases in the same
"System Requirements and Supported Platforms for Oracle Fusion Middleware
12c (12.2.1)" document. Right now certified databases are Oracle
12.1.0.1+/11.2.0.4+, IBM DB2 10.5 and MS SQL Server 2012.
Here goes the first difference from 11g. You don't need to
download and run RCU before the installation. RCU is bundled with an OBIEE
installer. And you have another new option: required repository schemas could
be created automatically during a configuration process.
Download software distributives
Before you start you need to download the following
distributives:
1.
Java Development Kit (JDK 8)
2.
Oracle Weblogic Server 12c (Fusion Middleware Infrastructure
12.2.1.0.0)
3.
OBIEE 12c
Right now OBIEE 12c is published only
on OTN: download page. This page has links to all required distributives for
all platforms. The latest version on eDelivery is 11.1.1.9.0.
After downloading and unpacking distributives, you'll get four
files.
Install
Installation consists of four main steps:
1.
Install JDK
2.
Install required OS packages
3.
Install FMW infrastructure
4.
Install OBIEE software
Install JDK 8
JDK installation is pretty easy, and I'm sure will cause no
problems.
After installation is done, please check the version of java as
below.
.
Install required OS
packages
You also need the xdpyinfo package used by OUI.
OUI says which packages are needed:
1
2
3
4
5
6
7
8
9
10
11
12
|
compat-libcap1-1.10
compat-libstdc++-33-3.2.3-x86_64
libgcc-4.8.2-x86_64
libstdc++-4.8.2-x86_64
libstdc++-devel-4.8.2-x86_64
sysstat-10.1.5
gcc-4.8.2
gcc-c++-4.8.2
make-3.82
glibc-2.17-x86_64
glibc-devel-2.17-x86_64
libaio-0.3.109-x86_64
|
While we don't need this packages at this step, it's a good time
to install them and don't think about it anymore.
1
|
sudo yum install compat-libcap1 compat-libstdc++-33
libgcc libstdc++ libstdc++-devel sysstat gcc gcc-c++ make glibc glibc-devel libaio
|
Install Oracle
Fusion Middleware Infrastructure
This part of the installation is very easy and fast. The only
decision you need to make is to choose an installation directory (ORACLE_HOME)
on the third step. This directory will be used for OBIEE installation. After a
full installation (including OBIEE), this directory size on my server is 11G.
The GUI will popup and the window as shown below:
Choose install directory (ORACLE_HOME).
Install OBIEE
software
Run the installer
Click ok and you see the below screen
.
Select previously created ORACLE_HOME
Once installation is completed successfully then we need to start configuring as same like obiee11g.
Configure OBIEE
The script for configuring an OBIEE
is located in $ORACLE_HOME/bi/bin directory. In my case, ORACLE_HOME is a/u03/oracle/Oracle/Middleware/Oracle_Home directory
(was created during an FMW installation).
The configuration script is called config.sh, just like it was
in 11g.
Run this script.
Clik ok/next in step1 and
then
Define (weblogic)
password.
Define parameters for repository
schemas. As an alternative, you can run RCU located in$ORACLE_HOME/oracle_common/bin directory. Using of
an RCU gives you more flexibility (you can define tablespaces, for example, or
prepare scripts for a DBA if you don't have DBA privileges).
By default it will take 9500 – 9999, you can change the port
numbers according to your requirement
If this is fresh install please select the first option, if you
want to migrate from 11g, you have to use the BI Application Bundle jar file to
export from 11g to 12c
You can check the oracle doc for more information on migrating
from 11g to 12c with bundle jar file
Review and save ports and URLs as they differ from 11g.
Wait until the process is finished.it takes almost 45 min – 1hr .please
be patient to get it completed. If it fails in between, please review the error
in the log as given in the above log location, troubleshoot or try to restart the config process once again.
At the end, you will see
the login form. Please note that URL port
is changed from 9704 to 9502 .
URL for new Visual Analyzer is different:
http://<your_host>:9502/va.
OBIEE 12c Analytics Page:
Default entry
points
WebLogic
Console
|
http://<your_host>:9500/console
|
Fusion
Middleware Control
|
http://<your_host>:9500/em
|
BI
Publisher
|
http://<your_host>:9502/xmlpserver
|
Visual
Analyzer
|
http://<your_host>:9502/va
|
BI
Analytics
|
http://<your_host>:9502/analytics
|
BI
Admin tool ODBC port
|
9514
|
Enjoy 12c Installation!!!J
Thanks
Saleem Syed (SS)