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
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
5 comments:
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
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
Thank you Sandeep for your help and reply
i really appreciate it
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 ? "."
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
Post a Comment