꾸러기

1. root 계정으로 작업하세요.

# groupadd dba
# useradd -g dba oracle
# passwd oracle

- /etc/sysctl.conf 커널 설정하기
# vi /etc/sysctl.conf

kernel.shmmax=536870912
kernel.shmmni=4096
kernel.shmall=2097152
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.rmem_max=262144
net.core.wmem_default=262144
net.core.wmem_max=262144

- /etc/security/limits.conf 커널 설정하기
# vi /etc/security/limits.conf

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

- /etc/pam.d/login 커널 설정하기
# vi /etc/pam.d/login

session    required     pam_limits.so

- 패치 rpm 설치 (리눅스 3번 CD 사용)
# umount /media/cdrom (또는 /media/cdrecorder)
# mount /media/cdrom (또는 /media/cdrecorder)
# cd /media/cdrom/RedHat/RPMS
# rpm -ivh libaio-devel-0.3.103-3.i386.rpm (또는 libaio-devel-0.3.105-2.i386.rpm)
# cd /home/oracle/patch
# unzip p4198954_40_LINUX.zip
# rpm -ivh compat-libcwait-2.1-1.i386.rpm
# rpm -ivh compat-oracle-rhel4-1.0-5.i386.rpm

- 환경설정
# su - oracle (오라클 계정으로 옮김)

$ vi .bash_profile

export EDITOR=vi
export LD_ASSUME_KERNEL=2.4.19
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/10g
export ORACLE_SID=testdb
export LANG=ko_KR.eucKR
export ORACLE_TERM=xterm
export NLS_LANG=AMERICAN_AMERICA.KO16KSC5601
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib
export PATH=$PATH:$ORACLE_HOME/bin
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

-오라클 10g 압푹 풀기
$ exit (root로 전환)

# mkdir -p /u01/app/oracle
# unzip 10201_database_linux32.zip
# chown -R oracle.dba /u01

- 완전히 로그아웃하고 oracle 계정으로 접속

- database 디렉토리 안에 있는 runInstaller 실행
$ ./runInstaller