Wednesday, June 01, 2011

Oracle 11g R2 Installation on Oracle Enterprise Linux 5.4

1    Hardware Requirements

----CHECK PHYSICAL RAM
We need at least 1GB of physical RAM.
# grep MemTotal /proc/meminfo

----CHECK SWAP SPACE
RAM between 1GB and 2GB then swap=1.5 times of RAM.
RAM between 2GB and 16GB then swap=equal to the size of RAM.
RAM is more than 16GB then swap size=16GB.
Note:If we have 2GB RAM,the swap size is 3GB.
#grep SwapTotal /proc/meminfo

----CHECK SPACE AVAILABLE IN /tmp
We need at least 1GB of space in /tmp directory.
#df –h /tmp

----CHECK RESOLUTION
To install Oracle 11g R2 in your system should be running on at least 1024*768 screen resolution.

#xdpyinfo | grep ‘dimensions:’

----CHECK KERNEL VRSION
We need the kernel version 2.6.18 or above
#uname -r

2    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
 
 
Regards,
Sukhwinder singh

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

There was an error in this gadget