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