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
- Centos6 64비트에서는 추가 패키지 설치
- 커널 파라미터 적용
$> 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