obiee 11.1.1.6 linux x86 64bit redhat installation document

www.deliverbi.co.uk

+44 (0)203 005 5244

Email : [email protected]

of 25

Delivering World Class BI Solutions

OBIEE 11.1.1.6 LINUX X86 64BIT

REDHAT 6 INSTALLATION - Part one (installation only)

Authors: co founders of DELIVER BI

Shahed Munir (Technical Director)

Krishna Mohan (Projects Director)

April 2012

www.deliverbi.co.uk

+44 (0)203 005 5244


of 25

Table of Contents

Hardware Requirements ........................................................................................................................................................ 3

Download of Installation Files ............................................................................................................................................... 3

Pre Requisites ......................................................................................................................................................................... 3

Creation of the Middleware Home directory ........................................................................................................................ 4

Libraries for Linux Redhat ...................................................................................................................................................... 4

Ulimits ....................................................................................................................................................................................... 4

Click cancel and start again by setting the U LIMIT. ......................................................................................................... 5

Creating an RCU on Database ............................................................................................................................................. 6

OBIEE 11.1.1.6 Installation ................................................................................................................................................. 11

Unzip the installation files on the Linux box .................................................................................................................. 11

Start the Installation process ........................................................................................................................................... 11

Specify Inventory Directory .............................................................................................................................................. 13

Installer Starts Main GUI for Installation. ....................................................................................................................... 14

Step 1 : Installer release Notes etc ................................................................................................................................ 14

Step 2 : Software Updates ............................................................................................................................................... 15

Step 3: Installation Type : Enterprise Installation ......................................................................................................... 15

Step 4: The Prequisite checks start here....................................................................................................................... 16

Step 5 : Weblogic User and Scale Out .......................................................................................................................... 16

Step 6: Specify Installation Location .............................................................................................................................. 17

Step 7: Select Components to Install ............................................................................................................................. 17

Step 8/9: Fill in Database Details related to RCU Created ......................................................................................... 18

Step 10: Auto Port Configuration .................................................................................................................................... 19

Step 11: Oracle Security Updates .................................................................................................................................. 19

Step 12: Generate a Response File (Silent Install File) & Summary ........................................................................ 20

Step 13: Installation Has Started Copying Of Files ...................................................................................................... 21

Step 14: Installation Has Started Configuring OBIEE .................................................................................................. 21

Step 15: Installation Result Summary Screen .............................................................................................................. 23

Browser Path – Just Ignore it .......................................................................................................................................... 23

Linux Bash Profile Example................................................................................................................................................. 24

www.deliverbi.co.uk

+44 (0)203 005 5244


of 25

Hardware Requirements

Hardisk required around 40gb (Including installation files etc) Ram = 4gb minimum

Download of Installation Files

http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/bi-downloads-1525270.html - for Linux x86-64-bit:

Disk 1 (1of2) (1.4G) (cksum 2909839713)

Disk 1 (2of2) (1.5G) (cksum 1499178505)

Disk 2 (1of2) (1.7G) (cksum 1921434953)

Disk 2 (2of2) (1.5G) (cksum 397265218)

Disk 3 (1.6G) (cksum 320598023)

Libraries for this installation are available from here if any are missing http://linux1.fnal.gov/linux/scientific/5x/x86_64/SL/ Xming installation has already been completed the instructions can be found on a separate Document. Xming is used to render the graphical interface from the Linux Server that you will be installing OBIEE on.

Pre Requisites

On Linux, running Oracle Business Intelligence 11.1.1.6 Installer as the root user is not supported.

Make sure there is a user available with the oinstall group and dba group memberships assigned Create MiddlewareHome Directory in a location where there is sufficient space available Use the command df –h to check space available to you for the install and space for the installation files.

www.deliverbi.co.uk

+44 (0)203 005 5244


of 25

When you have found the directory where you would like to install then create a middleware home

Creation of the Middleware Home directory

mkdir -p /MiddlewareHome chown -R obi:oinstall /MiddlewareHome chmod -R 775 /MiddlewareHome When installation starts it will run a pre-req check on the system to make sure all libraries needed for the install are available. You can either use YUM or the above link in the document to download the required libraries identified during the pre-req check.

Libraries for Linux Redhat

If Libraries need to be installed cancel the install – Download and install the libraries using the commands below :

To Install: rpm -ilv <package name>

To Remove: rpm -e <package name

Ulimits

Set the Ulimit Parameters (Soft and Hard Limits) set the /etc/security/limits.conf file oracle soft nofile 4096 oracle hard nofile 65536 If you have set the Ulimits in the conf file above then the Linux instance will need a bounce for the settings to be set on boot up.

www.deliverbi.co.uk

+44 (0)203 005 5244


of 25

Temporarily to run install you can execute the below command as installation user

ulimit -n 4096

To see if you have set the ulimit correctly the command to use is : ulimit –a

ulimit –a |grep open

ulimit -a|grep open

If you don’t set the Ulimit parameter you will get a fail on the OBIEE installation pre req checks like below

Click cancel and start again by setting the U LIMIT.

www.deliverbi.co.uk

+44 (0)203 005 5244


of 25

Creating an RCU on Database

As we are running OBIEE on Linux 64 Bit platform we have to create the RCU from a Windows Machine. We are using windows 7 for this. This utility can be run any time prior to the OBIEE installation and the Database user must have sysdba privilege on the required Database. Database version we are using is 11G ofm_rcu_win_11.1.1.6.0_disk1_1of1\rcuHome\BIN Start the rcu.bat

Create and click Next

www.deliverbi.co.uk

+44 (0)203 005 5244


of 25

Fill in the relevant details. These can be found in the TNS Entry for the database that you want to install the RCU on. Click Next

Click Ok

www.deliverbi.co.uk

+44 (0)203 005 5244


of 25

Click Oracle Business Intelligence and click next. Make a Note of the Prefix.

Enter password. Make a Note of It… Click Next

www.deliverbi.co.uk

+44 (0)203 005 5244


of 25

Make a note of your schema Owners and click Next

Click OK

Click OK and then click next on the screen

www.deliverbi.co.uk

+44 (0)203 005 5244


of 25

Make sure summary is ok and you have taken down all notes and click create. This will take a few minutes as its creating the schemas in the database.

You will get a completion Summary. Click Close. That’s it your ready if you login to your database you will see 2 schemas with their objects have been created ready to support OBIEE main installation.

www.deliverbi.co.uk

+44 (0)203 005 5244


of 25

OBIEE 11.1.1.6 Installation

Unzip the installation files on the Linux box

When you issue the first unzip command it will create a bishiphome directory and with in create sub directories for the disks If you do not have enough disk space on the Linux box you can keep deleting the installation zip files after you unzip them Below are the commands for unzipping the installation files

• unzip bi_linux_x86_111160_64_disk1_1of2.zip • unzip bi_linux_x86_111160_64_disk1_2of2.zip • unzip bi_linux_x86_111160_64_disk2_1of2.zip • unzip bi_linux_x86_111160_64_disk2_2of2.zip • unzip bi_linux_x86_111160_64_disk3.zip

Start the Installation process

Please refer to the xming document on how to start the service on the linux box for the GUI to render on your windows computer. You can do silent installation but you will still need to render the GUI so you can get a one off silent install script. Start the xhost command on ther server

www.deliverbi.co.uk

+44 (0)203 005 5244


of 25

export DISPLAY=142.89.12.453:0.0 (youripaddress:0:0) /usr/X11R6/bin/xhost Navigate to the following directory on the server /bishiphome/Disk1/install/linux64

Initiate the installation by giving the following command on the server ./runInstaller If the xhost is set up correctly then you should see the installation window popping up on your windows machine as below

www.deliverbi.co.uk

+44 (0)203 005 5244


of 25

Specify Inventory Directory

Click Ok

Tick Continue and OK

www.deliverbi.co.uk

+44 (0)203 005 5244


of 25

Installer Starts Main GUI for Installation.

Step 1 : Installer release Notes etc

www.deliverbi.co.uk

+44 (0)203 005 5244


of 25

Click Next

Step 2 : Software Updates

Skip Software Updates and Click Next

Step 3: Installation Type : Enterprise Installation

www.deliverbi.co.uk

+44 (0)203 005 5244


of 25

Click Enterprise Install and Click Next

Step 4: The Prequisite checks start here

If any pre –req checks fail ( Then cancel correct them and restart the installer) . If all ok then click Next.

Step 5 : Weblogic User and Scale Out

www.deliverbi.co.uk

+44 (0)203 005 5244


of 25

Fill in Weblogic Passwords and Click Next

Step 6: Specify Installation Location

Point to Middleware Directory Created earlier on install guide. And Click Next

Step 7: Select Components to Install

www.deliverbi.co.uk

+44 (0)203 005 5244


of 25

Click Next

Step 8/9: Fill in Database Details related to RCU Created

The same for MDS and & BIPLATFORM schemas created in RCU Process. Fill in Database Type : Oracle Database Connect String : Description as above BIPLATFORM : Schema as created when creating RCU and password used and click Next Click Next for MDS Schema as defaults.

www.deliverbi.co.uk

+44 (0)203 005 5244


of 25

Step 10: Auto Port Configuration

Click Next

Step 11: Oracle Security Updates

www.deliverbi.co.uk

+44 (0)203 005 5244


of 25

Untick support box as above and click next

Click Yes

Step 12: Generate a Response File (Silent Install File) & Summary

Here you can generate a response file (Silent Install File) Click save and save to a location for another installation if needed. Click Install

www.deliverbi.co.uk

+44 (0)203 005 5244


of 25

Step 13: Installation Has Started Copying Of Files

Install stage of copying files has started, post install scripts and one off patches etc. Once at 100% the copying is complete.

Step 14: Installation Has Started Configuring OBIEE

www.deliverbi.co.uk

+44 (0)203 005 5244


of 25

This is where the Installer is Configuring OBIEE 11.1.1.6 and weblogic and Fusion Middleware etc.

Make sure everything is Success, Everything will be working as expected. Click Next

www.deliverbi.co.uk

+44 (0)203 005 5244


of 25

Step 15: Installation Result Summary Screen

Save the Completion Summary to the box and copy all the URL’s Needed etc to launch OBIEE. That’s it for the installation . Run the EM make sure everything is ok. If not go into Weblogic and start any other deployments needed.

Click Finish

Browser Path – Just Ignore it

Ignore this .. Just click Cancel If Xming window is stuck after cancel then that’s fine. Just close it. Test your URL’s from your completion summary and everything is up and running. Next is the customization and security aspect.

www.deliverbi.co.uk

+44 (0)203 005 5244


of 25

Linux Bash Profile Example

# .bash_profile # File Descriptor Limit ulimit -n 10240 # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific environment and startup programs PATH=$PATH:/oracle/data NLS_LANG=AMERICAN_AMERICA.UTF8 export NLS_LANG

export TNS_ADMIN=/u01/MiddlewareHome/Oracle_BI1/network/admin export JAVA_HOME=/u01/MiddlewareHome/Oracle_BI1/jdk/bin export MW_HOME=/u01/MiddlewareHome export DOMAIN_HOME=$MW_HOME/user_projects/domains/bifoundation_domain export WL_HOME=$MW_HOME/wlserver_10.3 export ORACLE_HOME=/u01/MiddlewareHome/Oracle_BI1 PATH=$PATH:/u01/MiddlewareHomes PATH=$PATH:/u01/MiddlewareHome/Oracle_BI1/jdk/bin PATH=$PATH:/u01/MiddlewareHome/Oracle_BI1/OPatch export PATH

www.deliverbi.co.uk

+44 (0)203 005 5244


of 25

WWW.DELIVERBI.CO.UK Email us now for in depth training courses in OBIEE 11g, Any questions or queries: Email: [email protected] Phone : +44 (0)203 0055244

obiee 11.1.1.6 linux x86 64bit redhat installation document

Documents