OBIEE 11.1.1.9 Installation on Linux OEL 6: Step by Step

In this blog post I will describe the OBIEE 11.1.1.9 Installation on an Oracle Enterprise Linux 6.

The Oracle database needed for this installation is already installed

Prepare the Operating System:

as root on the OS Level enable Unicode:

[root@myserver]# locale

LANG=de_DE.UTF-8

LC_CTYPE=“de_DE.UTF-8″

LC_NUMERIC=“de_DE.UTF-8″

LC_TIME=“de_DE.UTF-8″

LC_COLLATE=“de_DE.UTF-8″

LC_MONETARY=“de_DE.UTF-8″

LC_MESSAGES=“de_DE.UTF-8″

LC_PAPER=“de_DE.UTF-8″

LC_NAME=“de_DE.UTF-8″

LC_ADDRESS=“de_DE.UTF-8″

LC_TELEPHONE=“de_DE.UTF-8″

LC_MEASUREMENT=“de_DE.UTF-8″

LC_IDENTIFICATION=“de_DE.UTF-8″

LC_ALL=

Configure kernel parameter SHMMAX: min. Value: 4294967295

As root edit the file /etc/sysctl.com:

vi /etc/sysctl.conf

kernel.shmmax = 4294967295

Enable changes:

/sbin/sysctl -p

Required OS Packages:

binutils-2.20.51.0.2-5.28.el6

compat-libcap1-1.10-1

compat-libstdc++-33-3.2.3-69.el6 for x86_64

compat-libstdc++-33-3.2.3-69.el6 for i686

gcc-4.4.4-13.el6

gcc-c++-4.4.4-13.el6

glibc-2.12-1.7.el6 for x86_64

glibc-2.12-1.7.el6 for i686

glibc-devel-2.12-1.7.el6 for i686

libaio-0.3.107-10.el6

libaio-devel-0.3.107-10.el6

libgcc-4.4.4-13.el6

libstdc++-4.4.4-13.el6 for x86_64

libstdc++-4.4.4-13.el6 for i686

libstdc++-devel-4.4.4-13.el6

libXext for i386

libXtst for i386

libXi for i386

openmotif-2.2.3 for x86_64

openmotif22-2.2.3 for x86_64

redhat-lsb-4.0-3.el6 for x86_64

sysstat-9.0.4-11.el6

uln-internal-setup-1.0.1-1.el6.noarch.rpm

Are all patches installed (check)?

rpm -q –qf ‚%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})n‘ binutils compat-libcap1 compat-libstdc++-33 gcc gcc-c++ glibc glibc-devel libaio libaio-devel libgcc libstdc++ libstdc++-devel libXext libXtst libXi redhat-lsb-core sysstat

binutils-2.20.51.0.2-5.42.el6 (x86_64)

compat-libcap1-1.10-1 (x86_64)

compat-libstdc++-33-3.2.3-69.el6 (i686)

compat-libstdc++-33-3.2.3-69.el6 (x86_64)

gcc-4.4.7-11.el6 (x86_64)

gcc-c++-4.4.7-11.el6 (x86_64)

glibc-2.12-1.149.el6_6.7 (x86_64)

glibc-2.12-1.149.el6_6.7 (i686)

glibc-devel-2.12-1.149.el6_6.7 (x86_64)

libaio-0.3.107-10.el6 (x86_64)

libaio-devel-0.3.107-10.el6 (x86_64)

libgcc-4.4.7-11.el6 (x86_64)

libgcc-4.4.7-11.el6 (i686)

libstdc++-4.4.7-11.el6 (x86_64)

libstdc++-4.4.7-11.el6 (i686)

libstdc++-devel-4.4.7-11.el6 (x86_64)

libXext-1.3.2-2.1.el6 (x86_64)

libXext-1.3.2-2.1.el6 (i686)

libXtst-1.2.2-2.1.el6 (x86_64)

libXtst-1.2.2-2.1.el6 (i686)

libXi-1.7.2-2.2.el6 (x86_64)

libXi-1.7.2-2.2.el6 (i686)

redhat-lsb-core-4.0-7.0.1.el6 (x86_64)

sysstat-9.0.4-27.el6 (x86_64)

if not: search the missing package with „yum search <package name>“ and install „yum install …“

NTPL Installation

If you plan to use the Oracle HTTP Server, the operating system needs to set Native POSIX Threads Library (NPTL) as the default threads-implementation. To check for this, run the following command:

getconf GNU_LIBPTHREAD_VERSION

Expected min. value: „NTPL 2.3.4“

Setting the Open File Limit:

The minimum Open File Limit should be at 4096

Check:

$ ulimit -n

Change:

vi /etc/security/limits.conf

* soft nofile 4096

* hard nofile 65536

* soft nproc 2047

* hard nproc 16384

vi /etc/security/limits.d/90-nproc.conf

* soft nofile 4096

* hard nofile 65536

* soft nproc 2047

* hard nproc 16384

Create Operating System user oracle and Group oinstall:

groupadd -g 1000 oinstall

useradd -u 1000 -g oinstall -d /home/oracle -m -s /bin/bash oracle

Set oracle Environment: umask

su – oracle

echo „umask 027“ >> .bash_profile

Create software directories:

As root:

mkdir /opt/oraclebi

chown oracle:oinstall /opt/oraclebi

Als oracle:

cd /opt/oraclebi

mkdir Software

mkdir -p product/MW_OBIEE/JAVA

chmod -R 775 product Software

Download the installation media

JDK 1.7.0_79:

http://www.oracle.com/technetwork/java/javase/downloads/jdk7-downloads-1880260.html

WebLogic Server 10.3.6:

http://www.oracle.com/technetwork/middleware/weblogic/downloads/wls-main-097127.html


Patch 20181997: SU Patch [YUIS]: WLS PATCH SET UPDATE 10.3.6.0.11:

MOS: https://support.oracle.com

OBIEE 11.1.1.9:

http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/bi-downloads-2537285.html

Repository Creation Utility 11.1.1.9:

http://download.oracle.com/otn/linux/bi/111190/rcuHome.zip

Preparing the installation media

As user oracle:

cd /opt/oraclebi/Software

mkdir WLS_10.3.6 JDK OBI_11.1.1.9 RCU_11.1.1.9

mv jdk-7u79-linux-x64.tar.gz JDK/

mv p20181997_1036_Generic.zip WLS_10.3.6/

mv obi_LINUXX64_11.1.1.9.0_1of5.zip OBI_11.1.1.9

mv obi_LINUXX64_11.1.1.9.0_2of5.zip OBI_11.1.1.9

mv obi_LINUXX64_11.1.1.9.0_3of5.zip OBI_11.1.1.9

mv obi_LINUXX64_11.1.1.9.0_4of5.zip OBI_11.1.1.9

mv obi_LINUXX64_11.1.1.9.0_5of5.zip OBI_11.1.1.9

mv rcuHome.zip RCU_11.1.1.9

chmod -R 777 /opt/oraclebi/Software

Installation JDK 1.7

As OS User oracle:

Install:

cd /opt/oraclebi/product/MW_OBIEE/JAVA

tar xvf /opt/oraclebi/Software/JDK/jdk-7u79-linux-x64.tar.gz

mv jdk1.7.0_79 jdk

touch jdk1.7.0_79

Check Java Version:

cd /opt/oraclebi/product/MW_OBIEE/JAVA/jdk/bin

./java -version

Java(TM) SE Runtime Environment (build 1.7.0_79-b15)

Java HotSpot(TM) 64-Bit Server VM (build 24.79-b02, mixed mode)

Installation WebLogic Server 10.3.6

As OS User oracle:

Start the Installer:

export JAVA_HOME=/opt/oraclebi/product/MW_OBIEE/JAVA/jdk

export PATH=$JAVA_HOME/bin:$PATH

java -Xmx1024m -jar /opt/oraclebi/Software/WLS_10.3.6/wls1036_generic.jar

Next

Create New Middleware Home

Custom -> Next

Disable „Server Examples“ -> Next

Disable „Run Quickstart“ -> Done

The Installation is in 10 Minutes completed

Installation Patch 20181997: WLS PSU 10.3.6.0.11

As OS User oracle:

Install:

mkdir /opt/oraclebi/product/MW_OBIEE/utils/bsu/cache_dir

cd /opt/oraclebi/product/MW_OBIEE/utils/bsu/cache_dir

unzip /opt/oraclebi/Software/WLS_10.3.6/p20181997_1036_Generic.zip

cd /opt/oraclebi/product/MW_OBIEE/utils/bsu

./bsu.sh -install -patch_download_dir=/opt/oraclebi/product/MW_OBIEE/utils/bsu/cache_dir -patchlist=YUIS -prod_dir=/opt/oraclebi/product/MW_OBIEE/wlserver_10.3

Output:

Prüfung auf Konflikte…

Keine Konflikte erkannt.

Patch-ID wird installiert: YUIS..

Ergebnis: Erfolg

Check:

source /opt/oraclebi/product/MW_OBIEE/wlserver_10.3/server/bin/setWLSEnv.sh

java weblogic.version

WebLogic Server 10.3.6.0.11 PSU Patch for BUG20181997
TUE NOV 12 15:54:42 IST 2015

WebLogic Server 10.3.6.0 Tue Nov 15 08:52:36 PST 2011 1441050

Configuring Database Schemas: RCU Configuration

The Database is already installed:

RDBMS Version:        12.1.0.2.0

Required Option:    JVM

Datenbank Benutzer:    SYS

Zeichensatz:        AL32UTF8

Schema BI:        PRD_BIPLATFORM

PRD_MDS

Create OBIEE schemas with RCU: Create repository:

cd /opt/oraclebi/Software/RCU_11.1.1.9

unzip rcuHome.zip

echo $LANG

de_DE.UTF-8

export ORACLE_HOME=/opt/oraclebi/Software/RCU_11.1.1.9

export LD_LIBRARY_PATH=$ORACLE_HOME/lib

cd $ORACLE_HOME/bin

./rcu

Welcome -> Next

Create repository -> Next

Database Connection Details:

  • database server name or IP address
  • database listener port
  • database service name
  • database user (with DBA or SYSDBA Rights)

The following screen will appear:

Ok

Choose Components: „Oracle Business Intelligence“ and „Metadata Services“

Define Prefix and click on „Next“


Checking Prerequisites -> „Ok“


Define Password for both Schemas: PRD_MDS and PRD_BIPLATFORM

Click on „Next“


Map tablespaces…


Summary: „Create“


After about 30 minutes the action is complete and the next screen will appear:


Completion Summary – Click on „Close“

Installation Oracle Business Intelligence Enterprise Edition 11.1.1.9

Unpack software and start the Installer:

cd /opt/oraclebi/Software/OBI_11.1.1.9

unzip obi_LINUXX64_11.1.1.9.0_1of5.zip

unzip obi_LINUXX64_11.1.1.9.0_2of5.zip

unzip obi_LINUXX64_11.1.1.9.0_3of5.zip

unzip obi_LINUXX64_11.1.1.9.0_4of5.zip

unzip obi_LINUXX64_11.1.1.9.0_5of5.zip

cd /opt/oraclebi/Software/OBI_11.1.1.9/bishiphome/Disk1

./runInstaller

Screen Welcome – Next

Choose „Skip Software Updates“ and klick on „Next“

Choose „Software only Install“. We will create the Domain and Instance later

Prerequisite Checks -> „Next“

Choose:

  • Oracle Middleware Home: /opt/oraclebi/product/MW_OBIEE
  • Oracle HOME Name: Oracle_BI1

Click on „Next“

OBIEE Konfiguration: Domäne erstellen

cd /opt/oraclebi/product/MW_OBIEE/Oracle_BI1/bin

./config.sh

Choose „Create New BI System“, enter Admin User and Password

Specify Installation Location: leave defaults

Enable Components and click on „Next“

Add the database connection information for schema prd_biplatform (configured via repository creation utility RCU).

Connect String Format: <Hostname>:<Listener Port>:<Database Service Name>

For Example: myhost:1521:myorcl


Add the database connection information for schema prd_mds (configured via repository creation utility RCU).

Connect String Format: <Hostname>:<Listener Port>:<Database Service Name>

For Example: myhost:1521:myorcl


Choose „Auto Port Configuration“… Next


Click „Configure“ and take a look at the OBIEE configuration


The Configuration is completed, click on „Next“

„Finish“

Installation prüfen

Check in Browser:

WLS Console:    http://10.16.72.134:7001/console        weblogic/welcome1

EM Console:    http://10.16.72.134:7001/em            weblogic/welcome1

OBIEE:        http://10.16.72.134:9704/analytics         weblogic/welcome1

BI Publisher:    http://10.16.72.134:9704/xmlpserver        weblogic/welcome1

Real-Time Decision (nur IE):    http://10.16.72.134:9704/ui    weblogic/welcome1

Calc. Manager:    http://10.16.72.134:9704/workspace        weblogic/welcome1

APS:        http://10.16.72.134:9704/aps

Enjoy J

Advertisements

Autor: Neselovskyi, Borys

Oracle Database / Middleware / Engineered System Solution Architect

Kommentar verfassen

Trage deine Daten unten ein oder klicke ein Icon um dich einzuloggen:

WordPress.com-Logo

Du kommentierst mit Deinem WordPress.com-Konto. Abmelden / Ändern )

Twitter-Bild

Du kommentierst mit Deinem Twitter-Konto. Abmelden / Ändern )

Facebook-Foto

Du kommentierst mit Deinem Facebook-Konto. Abmelden / Ändern )

Google+ Foto

Du kommentierst mit Deinem Google+-Konto. Abmelden / Ändern )

Verbinde mit %s