[Ubuntu Hardy Heron] Oracle 11g 설치.

02.Oracle/DataBase2008. 7. 14. 13:27

[Ubuntu Hardy Heron] Oracle 11g 설치.

*설치전 사전 작업*

1.필수 패키지 설치 및 기본 쉘(bash) 심볼릭 링크 설정.

sudo apt-get install build-essential libaio1 gawk ksh libmotif3 alien libtool lsb-rpm
sudo ln -sf bash /bin/sh

2.오라클 유저 및 그룹 추가.

sudo addgroup oinstall
sudo addgroup dba
sudo addgroup nobody
sudo usermod -g nobody nobody
sudo useradd -m oracle -g oinstall -G dba -s /bin/bash
sudo passwd oracle
sudo mkdir -p /oracle/11g
sudo chown -R oracle:dba /oracle
sudo chown -R oracle:dba /home/oracle

3.심볼릭 링크 설정.

###루트 권한획득.
sudo su -
mkdir /etc/rc.d
ln -s /usr/bin/awk /bin/awk
ln -s /usr/bin/rpm /bin/rpm
ln -s /usr/bin/basename /bin/basename
ln -s /etc/rc0.d /etc/rc.d/rc0.d
ln -s /etc/rc0.d /etc/rc.d/rc1.d
ln -s /etc/rc2.d /etc/rc.d/rc2.d
ln -s /etc/rc3.d /etc/rc.d/rc3.d
ln -s /etc/rc4.d /etc/rc.d/rc4.d
ln -s /etc/rc5.d /etc/rc.d/rc5.d
ln -s /etc/rc6.d /etc/rc.d/rc6.d
ln -s /etc/rcS.d /etc/rc.d/rcS.d

4.커널 변수 및 시스템 설정.

cat >> /etc/sysctl.conf << EOF
fs.file-max = 65535
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 1024 65535
net.core.rmem_default = 1048576
net.core.rmem_max = 1048576
net.core.wmem_default = 262144
net.core.wmem_max = 262144
EOF
cat >> /etc/security/limits.conf << EOF
oracle soft nproc 2047
oracle hard nproc 16383
oracle soft nofile 1023
oracle hard nofile 65535
EOF
cat >> /etc/pam.d/login << EOF
session required /lib/security/pam_limits.so
session required pam_limits.so
EOF

sysctl -p

5.오라클 환경변수 설정.

vi /etc/profile
export ORACLE_BASE=/oracle
export ORACLE_HOME=/oracle/product/11.1.0/db_1
export ORACLE_SID=orcl11
export PATH=$PATH:$ORACLE_HOME/bin

6.레드햇 버전 추가.

echo "Red Hat Linux release 4" > /etc/redhat-release

*설치*

1.시스템 재부팅 후 oracle 유저로 접속.

2.오라클 11g 다운로드 및 압축 해제.