Centos에서 oracle 11g 설치

패키지 설치하기

$> 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
$> yum install -y binutils-2.* compat-libstdc++-33* elfutils* gcc-4.* gcc-c++-4.* glibc-2.* glibc* ksh* libaio* libgomp* libgcc* libstdc++* unixODBC-2* unixODBC-devel* numactl-devel* sysstat* pdksh*

Centos6 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 "fs.suid_dumpable = 1
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default=4194304
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=1048586" >> /etc/sysctl.conf
$> sysctl -p

계정 설정

$> echo "oracle              soft    nproc   2047
oracle              hard    nproc   16384
oracle              soft    nofile  4096
oracle              hard    nofile  65536
oracle              soft    stack   10240" >> /etc/security/limits.conf
$> groupadd oinstall
$> useradd -g oinstall oracle
$> passwd oracle
{{ 패스워드 입력 2번 }}
$> 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_HOSTNAME=orcl.localdomain; export ORACLE_HOSTNAME
ORACLE_UNQNAME=DB11G; export ORACLE_UNQNAME
ORACLE_BASE=/usr/local/oracle; export ORACLE_BASE
ORACLE_HOME=\$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME
ORACLE_SID=orcl; export ORACLE_SID
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/jlib:\$ORACLE_HOME/rdbms/jlib; export CLASSPATH" >> /etc/profile

시스템 구동시 오라클 구동

$> 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-11g

Centos에서 oracle 11g 설치 | igoni.kr