Oracle Database 11g R2 - Configure2011/06/25

	Install Oracle Database 11g R2. Desktop Environment is required because installation proceeds on GUI. Before Installing, Change some settings for requirement of installing Oracle.
[1]	Install some packages

[root@db01 ~]#

yum -y install binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel glibc glibc-common glibc-devel gcc gcc-c++ libaio libaio-devel libgcc libstdc++ libstdc++-devel make sysstat unixODBC unixODBC-devel pdksh

[2]	Edit Kernel parameter.

[root@db01 ~]#

vi /etc/sysctl.conf

# add at the last

net.ipv4.ip_local_port_range = 9000 65500
fs.file-max = 6815744
kernel.sem = 250 32000 100 128
net.core.rmem_default=262144
net.core.wmem_default=262144
net.core.rmem_max=4194304
net.core.wmem_max=1048576
fs.aio-max-nr = 1048576

[root@db01 ~]#

sysctl -p

net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.conf.default.accept_source_route = 0
kernel.sysrq = 0
kernel.core_uses_pid = 1
net.ipv4.tcp_syncookies = 1
kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.shmmax = 68719476736
kernel.shmall = 4294967296
net.ipv4.ip_local_port_range = 9000 65500
fs.file-max = 6815744
kernel.sem = 250 32000 100 128
net.core.rmem_default = 262144
net.core.wmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_max = 1048576
fs.aio-max-nr = 1048576

[3]	Create a user for Oracle.

[root@db01 ~]#

groupadd -g 200 oinstall

[root@db01 ~]#

groupadd -g 201 dba

[root@db01 ~]#

useradd -u 440 -g oinstall -G dba -d /usr/oracle oracle

[root@db01 ~]#

vi /etc/pam.d/login

# near line 9: add

session required pam_selinux.so close

session required pam_limits.so

session optional pam_keyinit.so force revoke

[root@db01 ~]#

vi /etc/security/limits.conf

# add at the last

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

[root@db01 ~]#

vi /etc/profile

# add at the last

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

[4]	Switch to a user "Oracle" and configure some settings.

[oracle@db01 ~]$

chmod 755 /usr/oracle

[oracle@db01 ~]$

mkdir /usr/oracle/app

[oracle@db01 ~]$

chmod 775 /usr/oracle/app

[oracle@db01 ~]$

mkdir /usr/oracle/oradata

[oracle@db01 ~]$

chmod 775 /usr/oracle/oradata

[oracle@db01 ~]$

vi ~/.bash_profile

# add at the last

umask 022
export ORACLE_BASE=/usr/oracle/app

[oracle@db01 ~]$

mkdir tmp

# create a temporary dir for installation

Matched Content