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
- 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
- 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
- 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
