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 패키지 설치
'DB > ORACLE' 카테고리의 다른 글
Oracle OCP 10g자격증 만료 / 업그레이드 시험 (1) | 2015.10.22 |
---|---|
오라클 sys.props$ 테이블 정보 변경 (NLS_LANGUAGE, NLS_CHARACTERSET 등) (0) | 2015.10.01 |