Oracle 설치 in CentOs

설치전 주의사항

1. 도커에서 하면 어떤 이유인지 설치가 실패한다.

1. 디스크 용량 확보
2. swap 디스크 용량 확보

네트워크 설정

# vim /etc/sysconfig/network-scripts/ifcfg-enp0s3 BOOTPROTO=”static” IPADDR=192.168.0.x NETMASK=255.255.255.0 # vim /etc/sysconfig/network NETWORKING=yes HOSTNAME=centos7 GATEWAY=192.168.0.1 # /etc/init.d/network restart # vim /etc/resolv.conf  ( 이부분은 network restart 하면 자동으로 생김) nameserver 168.126.63.1 nameserver 168.126.63.2 # /etc/init.d/network restart

Oracle 설치

xrdp 원격설치

• yum groupinstall “X Window System” “Fonts” “Korean Support” -y
• yum install gnome-classic-session gnome-terminal nautilus-open-terminal control-center liberation-mono-fonts -y
• //rpm -Uvh https://dl.fedoraproject.org/pub/epel/7/x86_64/e/epel-release-7-8.noarch.rpm
• rpm -Uvh https://dl.fedoraproject.org/pub/epel/7/x86_64/Packages/e/epel-release-7-11.noarch.rpm
• rpm -Uvh http://li.nux.ro/download/nux/dextop/el7/x86_64/nux-dextop-release-0-1.el7.nux.noarch.rpm
• yum -y install xrdp tigervnc-server
• systemctl enable xrdp.service
• firewall-cmd –permanent –zone=public –add-port=3389/tcp
• firewall-cmd –reload
• chcon –type=bin_t /usr/sbin/xrdp
• chcon –type=bin_t /usr/sbin/xrdp-sesman
• systemctl start xrdp.service
• systemctl status xrdp.service
• netstat -antup |grep xrdp

oracle 설치준비

• groupadd oinstall
• groupadd dba
• useradd -g oinstall -G dba oracle
• passwd oracle
• mkdir /home/oracle/db
• chown -R oracle:oinstall /home/oracle/db
• chmod -R 775 /home/oracle/db
• chmod g+s /home/oracle/db

# vi /home/oracle/.bash_profile  ← 아래 추가

• export TMP=/tmp
• export TMPDIR=/tmp
• export ORACLE_BASE=/home/oracle/db
• export ORACLE_SID=ora12c
• export ORACLE_HOME=$ORACLE_BASE/product/12.1.0/dbhome_1
• export ORACLE_HOME_LISTNER=$ORACLE_HOME/bin/lsnrctl
• export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
• PATH=$PATH:$HOME/.local/bin:$HOME/bin
• export PATH=$ORACLE_HOME/bin:$PATH

# vi /etc/sysctl.conf   <- 아래 추가

• fs.aio-max-nr = 1048576
• fs.file-max = 6815744
• kernel.shmall = 2097152
• kernel.shmmax = 1987162112
• kernel.shmmni = 4096
• kernel.sem = 250 32000 100 128
• net.ipv4.ip_local_port_range = 9000 65500
• net.core.rmem_default = 262144
• net.core.rmem_max = 4194304
• net.core.wmem_default = 262144
• net.core.wmem_max = 1048586

# vi /etc/security/limits.conf

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

# vi /etc/rc.d/rc.local <- 추가

• swapon /home/swapfile

oracle 설치2

# yum update -y

# yum install -y binutils compat-libcap1 gcc gcc-c++ glibc glibc glibc-devel glibc-devel ksh compat-libstdc++-33 libaio libaio libaio-devel libaio-devel libgcc libgcc libstdc++ libstdc++ libstdc++-devel libstdc++-devel libXi libXi libXtst libXtst make sysstat

// swap 추가 (설치시 용량부족일경우를 위해 : http://chmodi.tistory.com/81 )

# dd if=/dev/zero of=/home/swapfile bs=1024 count=5000000

# mkswap /home/swapfile

# chmod 600 /home/swapfile

# swapon /home/swapfile

# chmod +x /etc/rc.d/rc.local

# su – oracle

xwindow 로 켜서 oracle 계정으로 로그인하고

ftp에서 오라클을 다운로드 받아 압축풀고

마운트

virtualbox 에서 cdrom 마운트

virtualbox 설정 -> 저장소 -> IDE 에  iso파일 로딩

# mkdir /mnt/cdroom

# mount -t auto /dev/cdrom /mnt/cdroom

virtualbox 에 공유폴더 마운트하기

virtualbox 설정-> 공유폴더 -> 폴더를 공유한다.

# yum update -y

# yum groupinstall “Development Tools” -y

# reboot

# ./VBoxLinuxAddtions.run

# mount -t vboxsf shareFolder /mnt/shareFolder/

참고사이트

http://chmodi.tistory.com/82 // DB 설치

http://antworld.tistory.com/19    // DB user생성

• docker 내부에  oracle install 시 참조 (swap 메모리가 작아서 안됨 따라서 메모리 확보 필요)

https://confluence.curvc.com/pages/viewpage.action?pageId=11927710

http://ksmk.tistory.com/73