Oracle Database Discussions

Oracle 11g R2 installtion in Linux



Author: Arun




For Reference:

http://www.morganslibrary.org/reference/linux_oracle_inst11gR2.html














Operating System Configuration



1.As root: Install RPM’s


For RHEL 5 (32-bit):

rpm -Uvih binutils-2*
rpm -Uvih compat-libstdc++-33*
rpm -Uvih elfutils-libelf-0*
rpm -Uvih elfutils-libelf-devel-0*
rpm -Uvih elfutils-libelf-devel-static-0*
rpm -Uvih gcc-4*
rpm -Uvih gcc-c++-4*
rpm -Uvih glibc-2*`uname -p`*
rpm -Uvih glibc-common-2*
rpm -Uvih glibc-devel-2*
rpm -Uvih glibc-headers-2*
rpm -Uvih kernel-headers-2*
rpm -Uvih ksh-20*
rpm -Uvih libaio-0*
rpm -Uvih libaio-devel-0*
rpm -Uvih libgcc-4*
rpm -Uvih libgomp-4*
rpm -Uvih libstdc++-4*
rpm -Uvih libstdc++-devel-4*
rpm -Uvih make-3*
rpm -Uvih numactl-devel-0*
rpm -Uvih sysstat-7*
rpm -Uvih unixODBC-2*
rpm -Uvih unixODBC-devel-2*

For RHEL 5 (64-bit):

rpm -Uvih binutils-2*`uname -p`*
rpm -Uvih compat-libstdc++-33*`uname -p`*
rpm -Uvih compat-libstdc++-33*i386*
rpm -Uvih elfutils-libelf-0*`uname -p`*
rpm -Uvih elfutils-libelf-devel-0*`uname -p`*
rpm -Uvih gcc-4*`uname -p`*
rpm -Uvih gcc-c++-4*`uname -p`*
rpm -Uvih glibc-2*`uname -p`*
rpm -Uvih glibc-2*i686*
rpm -Uvih glibc-common-2*`uname -p`*
rpm -Uvih glibc-devel-2*`uname -p`*
rpm -Uvih glibc-devel-2*i386*
rpm -Uvih glibc-headers-2*`uname -p`*
rpm -Uvih ksh-20*`uname -p`*
rpm -Uvih libaio-0*`uname -p`*
rpm -Uvih libaio-0*i386*
rpm -Uvih libaio-devel-0*`uname -p`*
rpm -Uvih libaio-devel-0*i386*
rpm -Uvih libgcc-4*`uname -p`*
rpm -Uvih libgcc-4*i386*
rpm -Uvih libstdc++-4*`uname -p`*
rpm -Uvih libstdc++-4*i386*
rpm -Uvih libstdc++-devel-4*`uname -p`*
rpm -Uvih make-3*`uname -p`*
rpm -Uvih numactl-devel-0*`uname -p`*
rpm -Uvih sysstat-7*`uname -p`*
rpm -Uvih unixODBC-2*`uname -p`*
rpm -Uvih unixODBC-2*i386*
rpm -Uvih unixODBC-devel-2*`uname -p`*
rpm -Uvih unixODBC-devel-2*i386*


2.As root: Create DBA Group and Oracle User

/usr/sbin/groupadd -g 500 oinstall
/usr/sbin/groupadd -g 501 dba
/usr/sbin/groupadd -g 502 oper
/usr/sbin/useradd -u 500 -m -g oinstall -G dba,oper oracle
id oracle

-- set the password to oracle1
passwd oracle


3.As root: Create Installation Directories

mkdir -p /app/oracle
chown -R oracle:dba /app/oracle
chmod -R 775 /app/oracle

mkdir /stage
chown -R oracle:dba /stage

4.As root: Alter Kernel Parameters

Vi /etc/sysctl.conf

Place this parameters in the end of the file.

fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.core.rmem_default = 4194304
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.tcp_wmem = 262144 262144 262144
net.ipv4.tcp_rmem = 4194304 4194304 4194304
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500
EOF

-- Activate changes
/sbin/sysctl -p

5.As root: Set Shell Limits

-- Modify limits.conf
Vi /etc/security/limits.conf

Place these lines in the end of the file.


oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
EOF

6.As root:set Logins

-- Modify /etc/pam.d/login
Vi /etc/pam.d/login

session required pam_limits.so


7.As root: Change Default Profile


Vi /etc/profile

if [ $USER = "oracle" ]; then
if [ \$SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
umask 022
fi
EOF



8.As root: Append servers to hosts file

Vi /etc/hosts

Add this lines

127.0.0.1 localhost.localadmin localhost
10.0.0.33 insight33.acolade.com.au insight33

9.As root: Modify .bashrc

# cd /home/oracle

vi .bashrc

-- append the following:
umask 022

ORACLE_HOSTNAME=?.mlib.org
ORACLE_BASE=/app/oracle/product
ORACLE_HOME=/app/oracle/product/11.2.0/db_1
ORACLE_SID=?
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
TMP=/tmp
TEMP=/tmp
TMPDIR=/tmp
PATH=$ORACLE_HOME/bin:$PATH
export PATH ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH
export TMP TEMP TMPDIR

alias oh='cd $ORACLE_HOME'
alias sql='sqlplus "/ as sysdba"'

-- close all open terminal windows and open new ones

$ set

-- validate the environment

10.Run the file for to start Installation

Unzip the oracle file in “tmp” folder.
After unzipping the installation files, change the user as “oracle” and take “database” folder.
Su oracle
cd /tmp/database/
./runInstaller


Note:If any one of the checking is failed during installation starting,take new terminal and use
Su root
Xhost +SI:localuser:oracle