July 11, 2009

Installing Oracle on Linux

Installing Oracle  on Linux

Requirements

  1. Create Users and groups

  2. Creating directories for installing oracle

  3. Change Kernel Parameters

  4. Install Oracle

  1. Create User and groups

#groupadd oinstall

#groupadd dba

#useradd –m –g oinstall –G dba oracle

#passwd oracle

  1. Creating directories for installing oracle

For Applicaiton

#Mkdir –p /u01/app/oracle

#Chown –R oracle:oinstall /u01/app/oracle

For data

#mkdir -p /u02/oradata

#chown –R oracle:oinstall /u02/

  1. Change Kernel Parameters

Sysctl file

# vi /etc/sysctl.conf

kernel.shmall = 2097152

kernel.shmmax = 536870912

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

fs.file-max = 65536

net.ipv4.ip_local_port_range = 1024 65000

net.core.rmem_default=262144

net.core.wmem_default=262144

net.core.rmem_max=262144

net.core.wmem_max=262144

Limits file

#vi /etc/security/limits.conf

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft nofile 1024

oracle hard nofile 65536

Login file

#vi /etc/pam.d/login

session required /lib/security/pam_limits.so

profile file

#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

  1. Install Oracle

# cd /opt/database

#./runInstaller

  1. Advance installation

  2. Enterprise edition

  3. Application path ÃÃâ  /u01/app/oracle/product/10.2.0/db_1

  4. Create database

  5. Transaction processing

  6. Global database (gtldev.localdomain sid gtldev)

  7. Unicode standard utf-8 AL32F8

  8. File system storage ( /u02/oradata/

  9. Do not enable backup

  10. Password

  11. Install

After installation run two scripts

  1. # cd /home/orainventory

  2. #./orainstroot.sh

  3. #cd /u01/app/oracle/product/10.2.0_db1/

  4. #./root.sh

Web Console

http://192.168.*.*/em

Click Here!