Tuesday, June 16, 2009

ORACLE Installation

Have you ever tried to install ORACLE on Linux. Well, its a bit of struggle if you don't know the correct settings.Believe me, I had a hard time installing ORACLE for the first time on Linux. But I think, you guys shouldn't waste time. So, here we go:

First of all you need to have the required packages and RPMs. You can find these easily from manual.
After installing all the packages, begin with the following steps:

Step 1: Add/Modify the following lines to /etc/sysctl.conf

kernel.shmmni =4096
kernel.sem=250 32000 100 128
fs.file_max=65536
net.ip_local_port_range= 1024 65000
net.core.rmem_default=1048576
net.core.rmem_max=1048576
net.core.wmem_default=262144
net.core.wmem_max=262144
net.ipv4.tcp_wmem=262144 262144 262144
net.ipv4.tcp_rmem=4194304 4194304 4194304

Step 2: #sysctl -p
So that changes take place effectively.

Step 3: Create oracle user and groups
#groupadd oinstall
#groupadd dba
#useradd -g oinstall -a dba oracle -- This server as username.
#passwd

Step 4: Create required directories
#mkdir -p /home/oracle
#
chown -R oracle:oinstall /home/oracle
#chmod -R 755 /home/oracle

Step 5: Add the following lines to /etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16348
oracle soft nofile 1024
oracle hard nofile 65536

Step 6: Add the following lines to /etc/passwd/login
session required pam_limits.so

Step 7: Add following to /etc/profile
if[$USER="oracle"]; then
ulimit -u 16384
ulimit -n 65536

Step 8: Add/modify /home/oracle/.bash_profile
umask 022
export ORACLE_BASE=/home/oracle
export ORACLE_SID=orcl
export ORACLE_HOME= $ORACLE_HOME/oracle/product/10.2.0/db_1
LD_LIBRARY_PATH=$ORACLE_HOME/bin:$PATH
export PATH

Step 9:
xhost +
xclock

Step 10: Run the GUI Installer
./runInstaller

There you go, now just do a couple of nexts and ull have oracle installed... CHEERS :)

2 comments:

  1. Hey great work ........but..i am using ubuntu ( debian ) , it doesnt support rpm....what do i do ?

    ReplyDelete
  2. Ubuntu supports .deb packges... Find the required .deb packages for your oracle

    ReplyDelete