OBIEE Software Only Installation Step-by-step Part-1

Part 1

Hey There!

Today I'll post a complete installation process of Oracle Business Intelligence Enterprise Edition version 11.1.1.9. Not just OBIEE, but the operational system OS, java, environment variables, repositories, weblogic server and OBIEE.

It will be a lot of information for this installation. So, download all required files for this tutorial.

The operational system will be Oracle Linux x64, therefore all files must be linux and x64 architecture.

all installations will be held in Oracle Virtual Box.

Oracle Virtual Box
Oracle Linux 5.7 x64
Java JDK 1.6.0_45  x64
Oracle Database 11gR2 x64
Repository Creation Utility 11.1.1.9 x64
OBIEE 11.1.1.9 x64
Weblogic 10.3.6 x64 generic


So here we go!

With all files in hands, install Oracle Virtual Box, for install the OBIEE, I recomend at least 2 processors, 5 gb RAM and 150 gb harddrive space for the virtual machine. I'll use Host-only for network.

Oracle Linux Installation

1.1   - Create the virtual machine and mount Oracle Linux image. Press enter to start the installation.
1.2   - Skip disk test.
1.3   - Next
1.4   - Select your language, next.
1.5   - Select your keyboard type, next.
1.6   - Yes to clear the disk and start the installation.
1.7   - Next
1.8   - Yes
1.9   - Next (we will configure the network after)
1.10 - Select your Region, next.
1.11 - Type and confirm a root password. For this tutotial i will use "welcome1" for all passwords, next.
1.12 - Select these options:

This option will install all required parameters, user, groups etc for Oracle Database 11gR2.

1.13 - Next. The installation will start.
1.14 - Reboot
1.15 - Foward
1.16 - Agree the licence Agreement, foward.
1.17 - Set the firewall to Disabled, foward, yes.
1.18 - Set SELinux to Disabled, foward, yes.
1.19 - Foward
1.20 - Adjust date and time, foward.
1.21 - Foward, continue.
1.22 - Foward.
1.23 - Finish, ok for reboot.

Oracle Enterprise Linux created! Let's login and start the system configuration.
User: root
Password: welcome1

IMPORTANT!!!!

THIS IS NOT AN OFFICIAL INSTALLATION, PLEASE SEE ORACLE DOCS FOR PRODUCTION INSTALL

Operational System Configuration.

First of all, lets change oracle user password, so do this:

[root@localhost ~]# passwd oracle

I will use oracle/welcome1 as username and password.

Update /etc/hosts file

[root@localhost ~]# vi /etc/hosts

# Do not remove the following line, or various programs

# that require network functionality will fail.

127.0.0.1             localhost.localdomain      localhost

192.168.56.101   obiee.hostonly.domain     obiee

~

~

Create the application directory and grant privileges:

[root@localhost /]# mkdir -p /u01/app

[root@localhost /]# chown -R oracle:oinstall /u01/app

[root@localhost /]# chmod -R 775 /u01/app

Install and Configure Java JDK 1.6.0_45

[root@localhost ~]# rpm -ivh /u01/download/jdk-6u45-linux-amd64.rpm

[root@localhost ~]# alternatives --install /usr/bin/java java /usr/java/jdk1.6.0_45/bin/java 17000

[root@localhost ~]# /usr/sbin/alternatives --config java

There are 2 programs which provide Java

  Selection    Command

-----------------------------------------------

 + 1           /usr/lib/jvm/jre-1.4.2-gcj/bin/java

*  2           /usr/java/jdk1.6.0_45/bin/java

Enter to keep the current selection[+], or type selection number: 2

Press Enter. Verifies if Java are correct.

[root@localhost ~]# java -version

java version "1.6.0_45"

Java(TM) SE Runtime Environment (build 1.6.0_45-b06)

Java HotSpot(TM) 64-Bit Server VM (build 20.45-b01, mixed mode)

Now we are done with root user. Change to oracle user and let's proceed.

Config the bash_profile file to set all required system variables for oracle database installation.

[oracle@localhost ~]$ vi ~/.bash_profile

#add the folloing

TMP=/tmp; export TMP^M

TMPDIR=$TMP; export TMPDIR^M

ORACLE_HOSTNAME=obiee; export ORACLE_HOSTNAME ^M

ORACLE_UNQNAME=orcl; export ORACLE_UNQNAME ^M

ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE^M

ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME^M

ORACLE_SID=orcl; export ORACLE_SID^M

ORACLE_TERM=xterm; export ORACLE_TERM^M

PATH=/usr/sbin:$PATH; export PATH^M

PATH=$ORACLE_HOME/bin:$PATH; export PATH^M

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH^M

CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

All clear... proceed to the oracle database installation!!

Oracle 11gR2 Database Install

Unzip the files

[oracle@localhost database]$ unzip V17530-01_1of2.zip

[oracle@localhost database]$ unzip V17530-01_2of2.zip

[oracle@localhost database]$ cd database/

[oracle@localhost database]$ ./runInstaller

In Part 2, I'll configure the listener and create one database.

Please Comment!

[] 'S