Cent Os Oracle 11g 설치전 준비사항

Cent Os Oracle 설치

0. ORACLE 다운로드
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
http://www.oracle.com -> Downloads -> DataBase -> DataBase 11g Enterprise/Standard Edition

 

1. 오라클 계정 설정
# groupadd oinstall
# groupadd dba
# useradd –m –g oinstall –G dba oracle
# passwd oracle
# mkdir /oracle
# chown –R oracle.dba /oracle
# chmod –R 755 /oracle

2. Oracle 설치를 위한 Kernel Parameter 설정
# vi cat /etc/sysctl.conf 아래 추가
# -------------------------------------------------
# oracle 11gR2 Setting
# -------------------------------------------------
kernel.shmmni = 4096
fs.aio-max-nr = 1048576
fs.file-max = 6815744
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
kernel.msgmni = 2878
# -------------------------------------------------
* Kernel Parameter 수정 후 System Reboot 없이 적용
# /sbin/sysctl –p

3. Oracle 계정의 Shell Limit 설정
- /etc/security/limits.conf 아래 추가
# -------------------------------------------------
# oracle 11gR2 Setting
# -------------------------------------------------
#<domain> <type> <item> <value>
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
# -------------------------------------------------

- /etc/pam.d/login 아래 추가
# -------------------------------------------------
# oracle 11gR2 Setting
# -------------------------------------------------
session required /lib/security/pam_limits.so
 # -------------------------------------------------

4. oracle 계정의 환경 변수 변경
- /homd/oracle/.bash_profile
# -------------------------------------------------
# oracle 11gR2 Setting
# -------------------------------------------------
ORACLE_BASE=/oracle; export ORACLE_BASE
ORACLE_HOME=/oracle/11g; export ORACLE_HOME
ORACLE_SID=ora11g; export ORACLE_SID
PATH=$PATH:$ORACLE_HOME/bin
# export PATH
# -------------------------------------------------

5. ORACLE 11g 설치 시 필요 패키지 설치
 compat-libstdc++-33-3.2.3-61
 elfutils-libelf-0.125-3.el5
 elfutils-libelf-devel-0.125-3.el5
 glibc-2.5-12
 glibc-devel-2.5-12
 glibc-common-2.5-12
 gcc-4.1.1-52.el5
 gcc-c++-4.1.1-52.el5
 kernel-headers
 libgcc-4.1.1-52.el5
 libaio-0.3.106-3.2
 libaio-devel-0.3.106-3.2
 libstdc++-4.1.1-52.el5
 libstdc++-devel-4.1.1-52.el5
 unixODBC-2.2.11-7.1
 unixODBC-devel-2.2.11-7.1
 sysstat-7.0.0-3.el5
 binutils-2.17.50.0.6-2.el5
 make-3.81-1.1

  * 오라클 관련 Package 설치 명령
 # yum -y install binutils-*
 # yum -y install compat-db-*
 # yum -y install control-center-*
 # yum -y install gcc-*
 # yum -y install gcc-c++-*
 # yum -y install glibc-*
 # yum -y install glibc-common-*
 # yum -y install gnome-libs-*
 # yum -y install libstdc++-*
 # yum -y install libstdc++-*
 # yum -y install make-*
 # yum -y install pdksh-*
 # yum -y install sysstat-*
 # yum -y install xscreensaver-*

6. VNC Server 설정 변경 (오라클 패키지 GUI환경에서 설치를 위하여 VNC설치)
- VNCSERVERS의 ID 를 oracle로 변경한다.
# vi /etc/sysconfig/vncservers
# su – oracle
# vncpasswd  (패스워드 설정)

7. oracle 계정으로 VNC 접속

8. Oracle 패키지 설치