1.필요 패키지 확인
Setarch와 compat-libstdc++은 없어도 됨.
# rpm -q(a) gcc make binutils openmotif setarch compat-db libaio compat-libstdc++
1.유저 추가(계정생성)
groupadd oinstall
groupadd dba
useradd -m -g oinstall -G dba oracle
passwd oracle
1.디렉토리 생성
mkdir -p /oracle/product/11.2.0/db_1
chown -R oracle:oinstall /oracle
chmod –R 775 /oracle
1.IP 설정.
127.0.0.1 localhost.localdomain localhost
192.168.2.181 oracle
1.커널 파라미터 수정
Add or amend the following lines in the "/etc/sysctl.conf" file.
fs.suid_dumpable = 1
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default=4194304
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=1048586
1.커널 수정 내역 적용
/sbin/sysctl –p
1.오라클 사용자 계정 Shell Limit 설정
Add the following lines to the "/etc/security/limits.conf" file.
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 4096
oracle hard nofile 65536
oracle soft stack 10240
1./etc/pam.d/login 파일 수정
session required pam_limits.so
추가.
1.Selinux 비활성화
/etc/selinux/config
SELINUX=disabled
1.환경변수
Login as the oracle user and add the following lines at the end of the ".bash_profile" file, remembering to adjust them for your specific installation.
# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_HOSTNAME=ol5-112.localdomain; export ORACLE_HOSTNAME
ORACLE_UNQNAME=DB11G; export ORACLE_UNQNAME
ORACLE_BASE=/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME
ORACLE_SID=DB11G; export ORACLE_SID
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
1.설치
Log into the oracle user. If you are using X emulation then set the DISPLAY environmental variable.
DISPLAY=<machine-name>:0.0; export DISPLAY
Start the Oracle Universal Installer (OUI) by issuing the following command in the database directory.
su – oracle
./runInstaller
7.7 자동실행 설정
[root@centos ~]$ vi /etc/oratab |
1 | ora11:/oracle/product/11g:Y
|
[root@centos ~]$ vi /etc/init.d/dbora |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 | #!/bin/sh
ORACLE_BASE=/oracle
ORACLE_HOME=$ORACLE_BASE/product/11g
ORACLE_OWNER=oracle
LOG=$ORACLE_HOME/startup.log
touch $LOG
chmod a+r $LOG
chown oracle:oinstall $LOG
case "$1" in
'start')
date >> $LOG
echo "Oracle Start Up..." >> $LOG
su - $ORACLE_OWNER -c $ORACLE_HOME/bin/dbstart $ORACLE_HOME >> $LOG 2>$1 &
;;
'stop')
date >> $LOG
echo "Oracle Shutdown..." >> $LOG
su - $ORACLE_OWNER -c $ORACLE_HOME/bin/dbshut $ORACLE_HOME >> $LOG 2>$1 &
;;
esac
|
[root@centos ~]$ chmod +x /etc/init.d/dbora
[root@centos ~]$ ln -s /etc/init.d/dbora /etc/rc5.d/S99dbora
[root@centos ~]$ ln -s /etc/init.d/dbora /etc/rc5.d/K11dbora |
7.8 정상적으로 기동되었는지 확인
[oracle@centos ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Wed Apr 4 23:48:43 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select instance_name from v$instance;
INSTANCE_NAME
----------------
ora11
SQL> |
ORACLE~1.DOC