OBIEE 11.1.1.6.0 on Oracle Enterprise Linux 5.5 - PART 1 | The Big Data - Business Intelligence by Sandeep Venu

Enter key word

OBIEE 11.1.1.6.0 on Oracle Enterprise Linux 5.5 - PART 1

PART 1- ORACLE DATABASE
PART 2- RCU
PART 3- OBIEE



Hi Guys,

I thought of sharing this with all of you. There was a requirement to setup a LINUX OBIEE server for a POC environment.

The challenge was that:

The Machine was only 2 GB of RAM and 200 GB Of hard disk. (Worst config).
No Prior experience in LINUX. :(

But i managed to bring up the server. If you guys are planning to setup an OBIEE 11G server on a LINUX machine please follow the steps EXACTLY.

Setp 1: You need to have a lot of prerequisites done before starting the OBIEE suit installation.

Download the installables:

Oracle 11gR2 Database
Oracle RCU
OBIEE 11.1.1.6.0

you can download these from the download links given in this blog.

Step 2:

Once you have downloaded all the installables , start the db intallation.

There are some prerequisites for the oracle db install, You need to have all the necessary packages installed.
and the system parameters also set.

For installing the packages, use the YUM package installer.

A) Follow the steps below EXACTLY to install the packages


login as root and execute the following commands.

Use the following commands according to your LINUX version


Oracle Linux 5

# cd /etc/yum.repos.d
# wget http://public-yum.oracle.com/public-yum-el5.repo

Oracle Linux 6

# cd /etc/yum.repos.d
# wget http://public-yum.oracle.com/public-yum-ol6.repo


now the file will be saved to your local drive

For more options you can go to this file and open it in a notepad and enable the versions according to your LINUX.

To install the packages required, you can use the yum server with  following commands.

# cd /
# yum install <package name>

or

for default oracle package installation (recommended) use the command below

# yum install oracle-validated  --The packages will be installed (Press Y  when prompted)
# yum install gcc*
# yum install compat*
# yum install unix*
# yum install libaio*

These commands will also install the remaining dependencies. (retype the command with any of your missing packages)



B) Configure the system parameters

To set the LINUX System parameters follow the below steps EXACTLY

Edit the /etc/sysctl.confand add following lines:  (You can edit this in the note editor -GUI)

These are recommended values , if the values in your current file is LARGER than this , the DO NOT exit that parameter, If else edit it with the below values

# vi /etc/sysctl.conf


kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 6815744
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576


Note: You need reboot system or execute "sysctl -p" command to apply above settings.
/sbin/sysctl -p


 Edit the /etc/security/limits.conf file and add following lines:
# vi /etc/security/limits.conf


oracle    soft  nproc  2047
oracle    hard  nproc  16384
oracle    soft  nofile  1024
oracle    hard  nofile  65536



Restart the machine.

The prerequisites for ORACLE Database is complete


If you have any difficulties, please reach out to me. I will definitely help you.


Cheers 
SHARE

About test

    Blogger Comment
    Facebook Comment

5 comments:

Unknown said...

Hi Sandeep
Thanks for sharing your experience

i have a question, can i install the Db on linux and the rcu and the obiee on windows ? or the rcu should be on linux as well ?

thanks

test said...

Yanal,

By Installing RCU its means that your are creating the bi schema for obiee installation. So you are 'running' the RCU on to a database that is already installed to create the BI_PLAFRORM AND MDS schemas.
So in your case you need to create/run/install the rcu on your installed database.

You run the rcu utility from windows and provide the connection details to your linux db.

Sandeep

Unknown said...

Thank you Sandeep for your help and reply

i really appreciate it

Unknown said...

hey sandeep
sorry for saying this but i have another question please

in oracle 10g
how can i know which reports are using a table or object ?

where is the reports are saved in the system and whats the extension or file format for them ? "."

Unknown said...

hey sandeep

hope you are doing good, can you please text\call me at this number 619-669-8941
i want to talk to you about something or send me an email please
yanal.rsakaji@gmail.com

thanks

Top Links

Upgrading BI Publisher

Add Google Search

OBIEE- LDAP

Change Admin Password

Best Practices

ORACLE 11GR2

Host Files

Customization

OBIEE-SIEBEL

Bug Fixes

Setting Default

OBIEE Installation failed

OBIEE Installation

Oracle Databse

Oracle In Linux

Loopback Adapter

Weblogic Failed

Yum Commands

Weblogic Admin

Linux Static IP

OBIEE LDAP

Admin Paswword

Scaling

Weblogic Starting Error

Localizing BI

Physical Schemas

Multimedia Dashboard

Video in OBIEE

Variables in OBIEE

Ago 30 Days

Email Link

ODI Installation

AGO Function

Sort Pivote table

OBIEE Patch

Reset Sys password

Date Calculation

Add Row in Report

Increase Row limit

OBIEE with Essbase

Reset Weblogic

BIP Login Error

MDS and BI Platform

ORA 28001 Error

ORA 12560 TNS Protocal Error

ORA 12154 TNS Error

OBIEE ON AIX

Pre Requsite

AIX Commands

Commands