[오라클]11g RAC 설치

6155910_기술노트_60회_Oracle_Database_11gR2_RAC_Install_Step_by_Step_on_vSphere.pdf

VMware 공유 디스크 생성

Vmfkstools.pl –server 192.168.0.100 –c 5g –d eagerzeroedthick –a lsilogic

/vmfs/volumes/datastore1/ordata/crs.vmdk

Vmfkstools.pl –server 192.168.0.100 –c 20g –d eagerzeroedthick –a lsilogic

/vmfs/volumes/datastore1/ordata/data.vmdk

1. 양쪽 노드에 호스트 파일 등록

   [root@rac1]# cat /etc/hosts

   223.1.1.18 rac1

   223.1.1.19 rac2
   
   #Private LAN For Oracle RAC Interconnection

   10.1.1.18 rac1-priv1

   10.1.1.19 rac2-priv1

   
   # Public Oracle Virtual IP

   223.1.1.20 rac1-vip

   223.1.1.21 rac2-vip

   
   223.1.1.22 rac-scan

2. 커널 설정
   fs.aio-max-nr = 1048576

   fs.file-max = 6815744

   kernel.shmall = 2097152

   kernel.shmmni = 4096

   kernel.sem = 2700 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.shmmax = 8589934592

3. /etc/limits.conf 파일에 설정
   oracle soft nofile 131072
   oracle hard nofile 131072
   oracle soft nproc 131072
   oracle hard nproc 131072
   oracle soft core unlimited
   oracle hard core unlimited
   oracle soft memlock 3500000
   oracle hard memlock 3500000
4. /etc/pam.d/login 파일에 다음을 등록
   session required /lib/security/pam_limits.so
5. User 쉘 등록 작업
   PATH=$PATH:$HOME/bin
   export PATH
   stty erase ^H
   export ORACLE_BASE=/app/oracle
   export ORACLE_HOME=$ORACLE_BASE/11.2.0.2
   export ORACLE_SID=RAC2
   export ORACLE_UNQNAME=RAC
   export ORACLE_TERM=xterm
   export PATH=/usr/sbin:$PATH
   export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH
   export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
   export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
   export DISPLAY=192.168.6.40:0.0
   if [ $USER = "oracle" ] || [ $USER = "grid" ]; then
   if [ $SHELL = "/bin/ksh" ]; then
   ulimit -p 16384
   ulimit -n 65536
   else
   ulimit -u 16384 -n 65536
   fi
   umask 022
   fi
6. ASM Rawdevice 를 사용하기 위해 패키지 설치
   http://www.oracle.com/technetwork/server-storage/linux/downloads/rhel5-084877.html
7. Oracle ASM을 이용하여 디스크 설정
   fdisk 설정
   #> oracleasm createdisk CRS /dev/sdb1
   #> oracleasm createdisk DATA /dev/sdc1
   #> oracleasm listdisks
   #> oracleasm scandisks
8. SSH DSA 키 생성 후 패스워드 없이 로그인
   #> ssh-keygen -t dsa
   #> vi authorized_keys
9. Grid Infrastructure 관련 설치 전 사전 확인
   #> ./runcluvfy.sh stage -pre crsinst -n rac1,rac2 -verbose
   6155898_verify.txt

<meta http-equiv="content-type" content="text/html; charset=utf-8">

raw device 연동

/etc/sysconfig/rawdevices

# format: <rawdev> <major> <minor>

# <rawdev> <blockdev>

# example: /dev/raw/raw1 /dev/sda1

# /dev/raw/raw2 8 5

/dev/raw/raw1 dev/sdb1

/dev/raw/raw2 dev/sdb2

/dev/raw/raw3 dev/sdb3

/dev/raw/raw4 dev/sdb4

/dev/raw/raw5 dev/sdc1

/dev/raw/raw6 dev/sdc2

/dev/raw/raw7 dev/sdc3

/dev/raw/raw8 dev/sdc4

 

raw 관련 서비스 재시작

service rawdevices restart

 

권한 관련 설정
/etc/udev/permissions.d/50-udev.permissions (4버전대)

/etc/udev/rules.d/60-raw.rules (5버전대)

ACTION=="add", KERNEL=="raw*", OWNER=="oracle", GROUP=="oinstall", MODE=="0660"