Centos에서 Oracle 10G 설치

패키지 설치

$> yum -y groupinstall "Desktop" "X Window System" "GNOME Desktop Environment" "Desktop Platform Development" "Desktop Platform"
$> yum -y install glibc* libaio* compat-libstdc* compat-gcc* gcc* libXp* openmotif* compat-db* xorg-x11-deprecated-libs compat-lib*
$> yum install kde-i18n-Korean -y
$> yum install fonts-korean -y

Centos 6 64비트만

$> yum install -y xorg-x11-xauth.x86_64 xorg-x11-apps.x86_64
$> yum install -y libXp libXtst binutils compat-db compat-libstdc++-33 glibc glibc-devel glibc-headers gcc gcc-c++ libstdc++ cpp make libaio ksh elfutils-libelf sysstat libaio libaio-devel setarch  libXp.i686 libXtst-1.0.99.2-3.el6.i686 glibc-devel.i686 libgcc-4.4.4-13.el6.i686 compat-libstdc++* compat-libf2c* compat-gcc* compat-libgcc* libXt.i686 libXtst.i686
$> yum install -y glibc-2.12-1.7.el6_0.5.i686

커널 파라미터 설정

$> echo "kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
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/sysctl.conf
$> sysctl -p

계정설정

$> echo "#Oracle setting
*               soft    nproc   2047
*               hard    nproc   16384
*               soft    nofile  1024
*               hard    nofile  65536" >> /etc/security/limits.conf
$> echo "session    required     pam_limits.so" >> /etc/pam.d/login
$> groupadd oinstall
$> useradd -g oinstall oracle
$> passwd oracle
{{ 패스워드 입력 두번 }}
$> mkdir /usr/local/oracle
$> chown oracle.oinstall /usr/local/oracle

설치시 OS정보 변경

$> mv /etc/redhat-release /etc/redhat-release_ori
$> echo "redhat-4" > /etc/redhat-release

시스템 설정 적용

$> echo "
# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_BASE=/usr/local/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME
ORACLE_SID=orcl; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

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

시스템 기동시 Oracle 구동을 위한 적용

echo "
source /etc/profile
su - oracle -c \"\$ORACLE_HOME/bin/lsnrctl start\"
su - oracle -c \"\$ORACLE_HOME/bin/dbstart\"
" >> /etc/rc.d/rc.local

 

출처 - http://igoni.kr/books/dbms/page/centos-oracle-10g

Centos에서 Oracle 10G 설치 | igoni.kr