Oracle Business Intelligence 12c installation on Linux

This article describes how to install and configure Oracle Business Intelligence on Oracle Linux 7 on test environment. Basic steps are described for quick OBIEE 12c installation.

Preparing to Install and Configure Oracle Business Intelligence

To prepare for your Oracle Business Intelligence installation, verify that your system meets the basic requirements. Then obtain the correct installation software.

Server Topology for OBIEE 12c Installation:
Server Topology for OBIEE 12c Installation

Directory structure for OBIEE 12c installation:
Directory Structure for OBIEE 12c installation

Installation Checklist

Important items that you must know before, or decide during, Oracle Business Intelligence installation.

Information Value Description
JAVA_HOME /u01/apps/obi12c/product/jdk Environment variable that points to the Java JDK home directory.
ORACLE_HOME /u01/apps/obi12c/product/Oracle_Home Directory you will install your software in. This directory will include Oracle Fusion Middleware Infrastructure and Oracle Business Intelligence, as needed.
DOMAIN_HOME /u01/apps/obi12c/config/domains Location in which your domain data is stored.
APPLICATION_HOME /u01/apps/obi12c/config/applications Location your application data is stored in.
WebLogic Server hostname appmt14.it-play.com Hostname for Oracle WebLogic Server and Oracle Business Intelligence consoles.
Console port 7001 Port for Oracle WebLogic Server and Oracle Business Intelligence consoles.
Administrator user name for WebLogic domain weblogic Name of user with Oracle WebLogic Server administration privileges.
Administrator user password *** Password of the user with Oracle WebLogic Server administration privileges.
Config utility ORACLE_HOME/oracle_common/common/bin Path to the configuration wizard for domain creation and configuration.
RCU utility ORACLE_HOME/oracle_common/bin Path to the Repository Creation Utility (RCU).
RCU schema prefix BI12C Prefix for names of database schemas used by Oracle Business Intelligence.
RCU schema password *** Password for the database schemas used by Oracle Business Intelligence.
Database hostname oradb11.it-play.com Name and domain of the host where the database is running.
Database port 1523 Port number that the database listens on.
Database service name BIPROD Oracle databases require a unique service name.
DBA username sys Name of user with database administration privileges.

General UNIX Operating System Requirements

Modifying the SHMMAX Parameter on Linux Operating Systems

Change the value of SHMMAX:
[root@appmt14 ~]# view /etc/sysctl.conf
———————————————-
kernel.shmmax = 4294967295
———————————————-

Activate the new SHMMAX setting:
[root@appmt14 ~]# /sbin/sysctl -p
———————————————-
kernel.shmmax = 4294967295
———————————————-

Enabling Unicode Support

Note: Oracle highly recommends that you enable Unicode support by setting the LANG and LC_ALL environment variables to a locale with the UTF-8 character set.
LANG — This environment variable sets the installation default locale.
LC_ALL — This environment variable overrides the value of the LANG environment variable and the values of any other LC_* environment variables.

[root@appmt14 ~]# locale
———————————————-
LANG=en_US.UTF-8
LC_CTYPE=»en_US.UTF-8″
LC_NUMERIC=»en_US.UTF-8″
LC_TIME=»en_US.UTF-8″
LC_COLLATE=»en_US.UTF-8″
LC_MONETARY=»en_US.UTF-8″
LC_MESSAGES=»en_US.UTF-8″
LC_PAPER=»en_US.UTF-8″
LC_NAME=»en_US.UTF-8″
LC_ADDRESS=»en_US.UTF-8″
LC_TELEPHONE=»en_US.UTF-8″
LC_MEASUREMENT=»en_US.UTF-8″
LC_IDENTIFICATION=»en_US.UTF-8″
LC_ALL=
———————————————-

Setting the Open File Limit and Number of Processes Settings on UNIX Systems

[root@appmt14 ~]# view /etc/security/limits.conf
Add the following lines:
———————————————-
@dba soft nofile 4096
@dba hard nofile 65536
@dba soft nproc 2047
@dba hard nproc 16384
———————————————-

Note: Make sure the same values are added to the /etc/security/limits.d/20-nproc.conf file.

[root@appmt14 ~]# cat /etc/security/limits.d/20-nproc.conf
———————————————-
* soft nproc 4096
root soft nproc unlimited
———————————————-

Restart the server
[root@appmt14 ~]# reboot

Linux Operating System Requirements

Required Packages:
————————————
binutils-2.23.52.0.1
compat-libcap1-1.10
compat-libstdc++-33-3.2.3 for x86_64
compat-libstdc++-33-3.2.3 for i686
gcc-4.8.2
gcc-c++-4.8.2
glibc-2.17 for x86_64
glibc-2.17 for i686
glibc-devel-2.17 for x86_64
libaio-0.3.109 for x86_64
libaio-devel-0.3.109 for x86_64
libgcc-4.8.2 for x86_64
libgcc-4.8.2 for i686
libstdc++-4.8.2 for x86_64
libstdc++-4.8.2 for i686
libstdc++-devel-4.8.2 for x86_64
ksh
make-3.82
ocfs2-tools-1.8.0
sysstat-10.1.5
numactl-2.0.9 for x86_64 (required for OBIEE-Essbase)
numactl-devel-2.0.9 for x86_64 (required for OBIEE-Essbase)
————————————

Note: Some packages are 32bit (i686) and they should be also installed with 64bit (x86_64) packages.

[root@appmt14 ~]# yum install binutils compat-libcap1 gcc gcc-c++ glibc-devel libaio libaio-devel libstdc++-devel ksh make ocfs2-tools sysstat numactl numactl-devel compat-libstdc++-33.i686 compat-libstdc++-33.x86_64 glibc.x86_64 glibc.i686 libgcc.x86_64 libgcc.i686 libstdc++.x86_64 libstdc++.i686
————————————

======================================================================
Install 14 Packages (+173 Dependent packages)
Upgrade 1 Package (+ 2 Dependent packages)
Total download size: 80 M
Is this ok [y/d/N]: Y

Complete!
————————————

Creating an Installation User

[root@appmt14 ~]# adduser appbit -g dba
[root@appmt14 ~]# passwd appbit
————————————
Changing password for user appbit.
New password: ***
Retype new password: ***
passwd: all authentication tokens updated successfully.
————————————

Note: Oracle recommends that you set the umask to 027 on your system prior to installation.

Log in under appbit user:

[appbit@appmt14 ~]$ view .bash_profile
Add the following string:
————————————
umask 027
————————————

Create directory structure

[root@appmt14 ~]# mkdir /u01/apps/obi12c
[root@appmt14 ~]# chown appbit:dba /u01/apps/obi12c
[root@appmt14 ~]# chmod 750 /u01/apps/obi12c

Log in under appbit user and create directories:

[appbit@appmt14 ~]$ mkdir /u01/apps/obi12c/product
[appbit@appmt14 ~]$ mkdir /u01/apps/obi12c/config
[appbit@appmt14 ~]$ mkdir /u01/apps/obi12c/config/domains
[appbit@appmt14 ~]$ mkdir /u01/apps/obi12c/config/applications

Create Central Inventory

[root@appmt14 ~]# mkdir /etc/oraInventory
[root@appmt14 ~]# chown root:dba /etc/oraInventory
[root@appmt14 ~]# chmod 775 /etc/oraInventory

Create Central Inventory Pointer File

[root@appmt14 ~]# view /etc/oraInst.loc
Add following strings:
————————————
inst_group=dba
inventory_loc=/etc/oraInventory
————————————

[root@appmt14 ~]# chown root:dba /etc/oraInst.loc
[root@appmt14 ~]# chmod 775 /etc/oraInst.loc

Installing the Oracle Fusion Middleware Infrastructure in Preparation for Installing Oracle Business Intelligence

Installing a Supported JDK

[appbit@appmt14 ~]$ mkdir /u01/apps/obi12c/product/jdk
[appbit@appmt14 ~]$ cd /stage/oracle/OBIEE12c/Linux

[appbit@appmt14 Linux]$ tar -xzf jdk-8u65-linux-x64.tar.gz -C ./
[appbit@appmt14 Linux]$ mv ./jdk1.8.0_65/* /u01/apps/obi12c/product/jdk/

[appbit@appmt14 ~]$ export JAVA_HOME=/u01/apps/obi12c/product/jdk
[appbit@appmt14 ~]$ export PATH=$JAVA_HOME/bin:$PATH
[appbit@appmt14 ~]$ java -version
————————————
java version «1.8.0_65»
Java(TM) SE Runtime Environment (build 1.8.0_65-b17)
Java HotSpot(TM) 64-Bit Server VM (build 25.65-b01, mixed mode)
————————————

Run the Infrastructure Installer

Note: Run Xming server and create DISPLAY variable.
[appbit@appmt14 ~]$ export DISPLAY=192.168.30.101:7

[appbit@appmt14 ~]$ java -jar /u01/apps/install/fmw_12.2.1.0.0_infrastructure.jar

obiee12c001
Click Next


Select Skip Auto Updates
Click Next


Oracle Home: /u01/apps/obi12c/product/Oracle_Home
Click Next


Select Fusion Middleware Infrastructures
Click Next


Click Next


De-select I wish to receive security updates via My Oracle Support
Click Next


Click Yes


Click Install


Click Next


Click Finish

Checking the Directory Structure

[appbit@appmt14 ~]$ cd /u01/apps/obi12c/product/Oracle_Home
[appbit@appmt14 Oracle_Home]$ ls -1
————————————————————-
cfgtoollogs
coherence
em
install
inventory
OPatch
oracle_common
oraInst.loc
oui
root.sh
wlserver
————————————————————-

Installing Oracle Business Intelligence

Installing Oracle Business Intelligence

[appbit@appmt14 ~]$ /u01/apps/install/bi_platform-12.2.1.0.0_linux64.bin


Click Next


Select Skip Auto Updates
Click Next


Oracle Home: /u01/apps/obi12c/product/Oracle_Home
Click Next


Select BI Platform Distribution with Samples
Click Next


Click Next


Click Next


Click Next


Click Finish

Checking the Directory Structure

[appbit@appmt14 ~]$ ls -1 /u01/apps/obi12c/product/Oracle_Home
—————————————————
bi
bin
cfgtoollogs
coherence
crs
css
em
has
install
instantclient
inventory
jdbc
jlib
ldap
lib
network
nls
OPatch
oracle_common
oracore
oraInst.loc
oui
plsql
plugins
precomp
rdbms
root.sh
slax
sqlplus
srvm
wlserver
xdk
—————————————————

Configuring Oracle Business Intelligence

Oracle Business Intelligence 12c Configuration Assistant is a multi-functional utility that helps to create database schemas, specify port range, and create system components, and start the application servers in addition to configuring the BI standard topology. Oracle strongly recommends you to use the Configuration Assistant to configure the BI domain.

Note: You have to create the database schema using the Repository Creation Utility (RCU) or while running the BI Configuration Assistant. Using RCU in advance gives you an additional option to choose and manage tablespaces. The RCU is available in the following directory: Oracle_home/oracle_common/bin

Running the Oracle Business Intelligence 12c Configuration Assistant

[appbit@appmt14 ~]$ /u01/apps/obi12c/product/Oracle_Home/bi/bin/config.sh


Components to include:

  • Essbase
  • Business Intelligence Enterprise Edition
  • Business Intelligence Publisher

Click Next


Click Next


Location of new domain
Domains Directory: /u01/apps/obi12c/config/domains
Domain Name: BI12C_domain
Domains Home: /u01/apps/obi12c/config/domains/BI12C_domain

Credentials for new domain
Username: weblogic
Password: ***
Confirm Password: ***
Click Next


Select Create new schema
Schema prefix: BI12C
Schema password: ***
Confirm schema password: ***
Database type: Oracle Database
Username: sys
Password: ***
Simple connect string: oradb11.it-play.com:1523:BIPROD
Click Next


Port Range Starting Port: 9500
Port Range End Port: 9999
Click Next


Select Oracle sample application (SampleAppLite)
Click Next


Click Configure


Click Next


Click Finish

Documentation

Oracle Business Intelligence 12c installation on Linux: 2 комментария

  1. Melanie

    hi, I installed obiee12c on Linux. Now I want to migrate rdp and all catalogs on 12c on windows to new BI on Linux there are many docs about 11g to 12c migration but not 12c to 12c thanks in advice for your help

Добавить комментарий

Ваш e-mail не будет опубликован. Обязательные поля помечены *

*