OBIEE 11g Installation on Linux Operating System

Installation of OBIEE 11g on Linux OS

Steps Involve

• Configuring Linux
• Configuring VMWare
• Installing Oracle 11gR2
• Post DB Creation Task
• Installing OBI RCU (Repository Creation Utility)
• Installing OBIEE 11.x 

Configuring Linux

• Log in as gaurav (or whatever user you created, other than root or oracle) - I changed my session to KDE, as it's my preferred windowing environment.
• Open a terminal
• su to root

su root

• edit /etc/hosts and add the viper fixed IP address.

vi /etc/hosts

• create user area

mkdir /u01

• Change ownership and permissions on u01

chown -R oracleoinstall /u01

chmod 775 /u01

• Set up sudo by editing the configuration file

vi /etc/sudoers

• Add

gaurav ALL=(ALL) NOPASSWDALL

oracle ALL=(ALL) NOPASSWDALL

Configuring VMWare

• You will receive warnings re VMWare tools needing installing...it's a good idea to install them, if only to get the messages to disappear.
• From VM menu, choose Install VMWare Tools
• From the window showing the VMWare Tools files, extract the TAR to /u01, keeping folder structure.
• Open a terminal
• su to root

su root

• navigate to the VMWare Tools directory

cd /u01/vmwware-tools-distrib

• run the perl script to install VMWare Tools

./vmware-config-tools.pl

• Take all defaults for answers to questions
• Don't install experimental vsync
• Use 1024x768 resolution for X test.
• When it finishes, reboot the VM.

Installing Oracle RDBMS 11gR2 (11.2.0.1.0)

• NOTE - I use the excellent guides on Oracle BASE run by Tim Hall, for installing Oracle on various flavours of Unix..to a certain extent, I followed the one Tim wrote on installing 11gR2 on Oracle Enterprise Linux 5.0, so thanks to Tim for his help there.
• Login to KDE as oracle (the password defaults to oracle)
• navigate to the /u01 directory

cd /u01

• create directory for software

mkdir software

• Navigate to the software directory

cd software

• Download software from technet...11gR2 RDBMS Enterprise Edition...to /u01/software
• Unzip the files

unzip linux.x64_11gR2_database_1of2.zip

unzip linux.x64_11gR2_database_2of2.zip

• Make Oracle directories

 mkdir -p /u01/app/oracle/product/11.2.0/db_1

 chown -R oracleoinstall /u01/app

 chmod -R 775 /u01/app

• Add xhost - the hostname in this example is viper

 xhost +viper

• Set up oracle profile. As oracle, vi ~/.bash_profile, then add this text

# Oracle Settings

TMP=/tmp; export TMP

TMPDIR=$TMP; export TMPDIR

ORACLE_HOSTNAME=viper; export ORACLE_HOSTNAME

ORACLE_UNQNAME=DB11G; export ORACLE_UNQNAME

ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE

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

ORACLE_SID=DB11G; export ORACLE_SID

ORACLE_TERM=xterm; export ORACLE_TERM

PATH=/usr/sbin$PATH; export PATH

PATH=$ORACLE_HOME/bin$PATH; export PATH

LD_LIBRARY_PATH=$ORACLE_HOME/lib/lib/usr/lib; export LD_LIBRARY_PATH

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

if [ $USER = "oracle" ]; then

  if [ $SHELL = "/bin/ksh" ]; then

    ulimit -p 16384

    ulimit -n 65536

  else

    ulimit -u 16384 -n 65536

  fi

fi

• Run the Oracle installer

cd /u01/software/database

./runInstaller

Now Installer Dialog Box will Pop Up. Follow the Steps below:

• Step 1 of 9 [Configure Security Updates]: Enter your email address and if you want, your Oracle Support password (I don't). Then click Next

• Step 2 of 9 [Installation Option]: Choose Install Software only. Then click Next

• Step 3 of 9 [Grid Options]: Choose Single Instance. Then click Next

• Step 4 of 11 [Product Languages]: Leave default of English. Then click Next

• Step 5 of 11 [Database Edition]: Choose Enterprise edition. Then click Next

• Step 6 of 11 [Installation Location]: Accept the default /u01/app/oracle for Oracle Base. Set the Software Location to /u01/app/oracle/product/11.2.0/db_1. Then click Next

• Step 7 of 11 [Create Inventory]: If this is first install, set Inventory Directory - accept default of /u01/app/oraInventory. Accept oraInventory Group Nmae of oinstall. Then click Next

• Step 8 of 12 [Operating System Groups]: Leave defaults of dba/oinstall.
• Step 9 of 12 [Prerequisite Checks]: Click Next

• Step 10 of 12 [Summary]: Click Finish...software installs

• Step 11 of 12 [Install Product]: Now on to the root scripts

• Open a terminal and su to root
• Copy each of the indicated scripts and execute them in the terminal

• running orainstRoot.sh

• running root.sh

• Step 12 of 12 [Finish]: Software installed

Post DB Create Tasks

• Edit oratab to ensure auto start of the database on boot up

vi /etc/oratab

• Change N to Y at end of the line for T112

T112/u01/app/oracle/product/11.2.0/db_1Y

• Reboot the VM
• Now Login to DB using SQL Plus

Install OBI Repository Creation Utility (RCU)

• Log in as oracle and run Database Creation Assistant
• Download software from technet...RCU
• Unzip the file

unzip ofm_rcu_linux_11.1.1.3.3.disk1_1of1.zip

• navigate to the bin directory and start the RCU

cd rcuHome/bin

./rcu

• [Welcome]: Click Next
• Step 1 of 7 [Create Repository]: Accept default of Create. Click Next
• Step 2 of 7 [Database Connection Details]: Leave default of Oracle Database:
• Set hostname to viper
• Set port to 1521
• Set service name to T112
• Set username to SYS
• Set password
• Leave Role as SYSDBA
• Click Next

• Click OK (in RCU Checking Prerequisites Dialog box)
• Step 3 of 7 [Select Components]:  Leave prefix of DEV
• Check Oracle AS Repository Components - they all become checked.
• Click Next
• Click OK (in RCU Checking Prerequisites Dialog box)
• Step 4 of 7 [Schema Password]: Use same password for all users, for simplicity
• Click Next
• Step 5 of 7 [Custom Variables]: Set passwords and defaults for other variables
• Click Next
• Step 6 of 7 [Map Tablespaces]: Click Next – OK – OK
• Step 7 of 7 [Summary]: Click Create

• Repository creation occurs.
• Click Close

Install Oracle Business Intelligence Enterprise Edition (11.1.1.3.0)

• Log in as oracle and run Database Creation Assistant
• Download software from technet...OBIEE 11.1.1.3.0
• Unzip the files

unzip bi_linux_x86_111130_64_disk1_1of2.zip

unzip bi_linux_x86_111130_64_disk1_2of2.zip

unzip bi_linux_x86_111130_64_disk2_1of2.zip

unzip bi_linux_x86_111130_64_disk2_2of2.zip

• Navigate to the installer directory

cd bishiphome/Disk1

• Run the installer

./runInstaller

• Step 1 of 12 [Welcome]: Click Next

• Step 2 of 12 [Simple install] : Choose Simple install and click Next (Installation Types : Simple / Enterprise / Software Only)
• Step 3 of 12 [Prerequisite Checks] : Prerequisite checks should all pass.
• Click Next
• Step 4 of 12 [Specify Installation Location] : select /u01/app/oracle/product/11.1.1/obi/middleware
• Click Next
• Step 5 of 12 [Administrator Details] : Accept weblogic as username
• Set password and confirm it. (boxer999)
• Click Next
• Step 6 of 12 [Configure Components] : Click Next

• Step 7 of 12 [Database Details] : Set BIPLATFORM Schema Username to DEV_BIPLATFORM.
• Set a password (boxer99)
• Click Next
• Step 8 of 12 [Security Updates] : Enter email and password for My Oracle Support
• Click Next
• Step 9 of 12 [Summary]: Click Install
• Step 10 of 12 [Installation Process]: Installing components - just watch
• Step 11 of 12 [Configuration Process]: Configuring components - just watch
• Step 12 of 12 [Complete]: Click Finish