RedHat Enterprise Linux 4에 Oracle 9i 엔진 설치 및 패치셋

(LEE) — Fri, 03 Jul 2009 02:58:51 +0900

엔진만 설치 하고 수동생성은 내일~

OS
RedHat Enterprise Linux 4

설치된 패키지 목록
Desktops
• X Windows System
• GNOME Desktop Environment
Applications
• Editors
Development
• Development Tools
• X Software Development
• Legacy Software Development

기타 패키지
compat-oracle-rhel4-1.0-5.i386.rpm
(Make Error 발생 시 의존성 무시하고 위 rpm 설치)

참고 사이트
• http://oss.oracle.com/projects/compat-oracle/
• http://www.oracle.com/technology/documentation/oracle9i.html

P3006854.ZIP

시스템 파라미터 값 및 사용자 변수
(파라미터 값은 설치 요구 사항을 확인 후 해당 시스템 환경에 맞게 변경)
# groupadd dba
# useradd -g dba oracle
# passwd oracle

# cat >> /etc/sysctl.conf <<EOF
kernel.sem = 250 32000 100 128
kernel.shmmax = 1073741824
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 1048576
net.core.rmem_max = 1048576
net.core.wmem_default = 262144
net.core.wmem_max = 262144
EOF

# /sbin/sysctl -p

# cat >> /etc/security/limits.conf <<EOF
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
EOF

# cat >> /etc/pam.d/login <<EOF
session required pam_limits.so
EOF

export PATH
export EDITOR=vi
export ORACLE_BASE=/home/oracle
export ORACLE_HOME=$ORACLE_BASE/product/9i
export ORACLE_SID=leebydb
export LANG=ko_KR.eucKR
export ORACLE_TERM=xterm
export THREADS_FLAG=native
export ORACLE_OWNER=oracle
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
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/lib
export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/bin:$PATH
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib