[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