[CentOS] Oracle 10g

gcc,make,binutils,libaioをインストールしておく。

% grep MemTotal /proc/meminfo
MemTotal:1034104 kB
% grep SwapTotal /proc/meminfo
SwapTotal:2031608 kB
% grep oinstall /etc/group
% grep dba /etc/group
% grep nobody /etc/group
nobody:x:99:
% id oracle
id: oracle: そのようなユーザは存在しません
% id nobody
uid=99(nobody) gid=99(nobody) 所属グループ=99(nobody)
% sudo /usr/sbin/groupadd oinstall
% sudo /usr/sbin/groupadd dba
% sudo /usr/sbin/useradd -g oinstall -G dba -p passwd -d /home/oracle oracle
% sudo mkdir -p /u01/app/oracle
% sudo mkdir -p /u02/oradata
% sudo chown -R oracle:oinstall /u01 /u02
% sudo chmod -R 775 /u01 /u02
% sudo /sbin/sysctl -a | grep sem
kernel.sem = 250        32000   32      128
% sudo /sbin/sysctl -a | grep shm
kernel.shmmni = 4096
kernel.shmall = 2097152
kernel.shmmax = 33554432
% sudo /sbin/sysctl -a | grep file-max
fs.file-max = 102440
% sudo /sbin/sysctl -a | grep ip_local_port_range
net.ipv4.ip_local_port_range = 32768    61000
% sudo vi /etc/sysctl.conf
#for Oracle 10g
kernel.sem    = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 2097152
kernel.shmmax = 2147483648
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
% sudo /sbin/sysctl -p
% sudo vi /etc/security/limits.conf
 *               soft    nproc   2047
 *               hard    nproc   16384
 *               soft    nofile  1024
 *               hard    nofile  65536
% sudo vi /etc/pam.d/login
session    required     /lib/security/pam_limits.so
% sudo vi /etc/pam.d/su
session    required     /lib/security/pam_limits.so
% sudo 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
fi