Oracle 11G 설치

# GUI 설치

yum -y groupinstall "Server with GUI"

startx

# 부팅시 GUI로 부팅

sudo ln -sf /lib/systemd/system/runlevel5.target /etc/systemd/system/default.target

# 필수 패키지 설치

sudo yum -y install binutils compat-libstdc++-33 compat-libstdc++-33.i686 ksh

sudo yum -y install elfutils-libelf elfutils-libelf-devel glibc glibc-common

sudo yum -y install glibc-devel gcc gcc-c++ libaio libaio.i686 libaio-devel

sudo yum -y install libaio-devel.i686 libgcc libstdc++ libstdc++.i686

sudo yum -y install libstdc++-devel libstdc++-devel.i686 make sysstat

sudo yum -y install unixODBC unixODBC-devel

#환경설정 (아래처럼 주석처리)

sudo vi /usr/lib/sysctl.d/00-system.conf

# Disable netfilter on bridges.

#net.bridge.bridge-nf-call-ip6tables = 0

#net.bridge.bridge-nf-call-iptables = 0

#net.bridge.bridge-nf-call-arptables = 0

# 환경설정 수정

sudo vi /etc/sysctl.conf

net.ipv4.ip_local_port_range = 9000 65500

fs.file-max = 6815744

kernel.shmall = 10523004

kernel.shmmax = 6465333657

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

net.core.rmem_default=262144

net.core.wmem_default=262144

net.core.rmem_max=4194304

net.core.wmem_max=1048576

fs.aio-max-nr = 1048576

# 적용

sudo sysctl -p

# 그룹생성

sudo groupadd -g 200 oinstall

sudo groupadd -g 201 dba

sudo useradd -u 440 -g oinstall -G dba -d /home/oracle oracle

sudo passwd oracle

# 환경설정 (add line추가)

sudo vi /etc/pam.d/login

# pam_selinux.so open should only be followed by sessions to be executed in the user context

session    required     pam_selinux.so open

session    required     pam_namespace.so

# add line start

session    required     pam_limits.so

# add line end

session    optional     pam_keyinit.so force revoke

session    include      system-auth

-session   optional     pam_ck_connector.so

# 환경설정

sudo vi /etc/security/limits.conf

oracle   soft   nproc    2047

oracle   hard   nproc    16384

oracle   soft   nofile   1024

oracle   hard   nofile   65536

# 환경설정

sudo vi /etc/profile

if [ $USER = "oracle" ]; then

      if [ $SHELL = "/bin/ksh" ]; then

           ulimit -p 16384

           ulimit -n 65536

      else

           ulimit -u 16384 -n 65536

      fi

fi

# 디렉토리생성

sudo mkdir -p /usr/oracle/app

sudo mkdir /usr/oracle/oradata

sudo chmod -R 755 /usr/oracle

sudo chown -R oracle:oinstall /usr/oracle

# 환경설정

sudo vi /home/oracle/.bash_profile

umask 022

export ORACLE_BASE=/usr/oracle/app

umask 022

export TMP=/tmpexport ORACLE_BASE=/usr/oracle/app

export TMPDIR=/tmp

export ORACLE_SID=orcl

export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1

export ORACLE_HOME_LISTNER=$ORACLE_HOME/bin/lsnrctl

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

export PATH=$ORACLE_HOME/bin:$PATH

export NLS_LANG=KOREAN_KOREA.AL32UTF8 

★ 설치시 한글깨질때 

./runinstaller -jreloc /usr/lib/jvm/jre

 

 

 

★ Oracle 11G 설치시  Semmni 파라메터 설정해도 Fail 발생시 아래블로그 확인

http://wookoa.tistory.com/79

1. Semmni 설정 후 오류 발생시 스킵하고 넘어감

2. 첫번째 오류발생시 해당위치로 가 빨간줄추가 후 retry

3.  두번째오류 빨간줄 추가 후 retry

위처럼 하면 정상설치됨

아~이것땜에 이틀 개고생했네