RAC 2 - RAC 구성하기 (패치 및 에러조치)

1. 패치를 위해서는 해당 서비스를 종료해야 한다.
 

1) ASM패치
 
① 패치를 위해 ASM정지 후 상태확인
 
** 노드1 

$ srvctl stop asm -n rac1
$ srvctl stop asm -n rac2
$ crs_stat -t
Name           Type           Target    State     Host
------------------------------------------------------------
ora....SM1.asm application    OFFLINE   OFFLINE  ◀
ora....C1.lsnr application    ONLINE    ONLINE    rac1
ora.rac1.gsd   application    ONLINE    ONLINE    rac1
ora.rac1.ons   application    ONLINE    ONLINE    rac1
ora.rac1.vip   application    ONLINE    ONLINE    rac1
ora....SM2.asm application    OFFLINE   OFFLINE  ◀
ora....C2.lsnr application    ONLINE    ONLINE    rac2
ora.rac2.gsd   application    ONLINE    ONLINE    rac2
ora.rac2.ons   application    ONLINE    ONLINE    rac2
ora.rac2.vip   application    ONLINE    ONLINE    rac2

  
② OFFLINE확인 후 패치 실행
 
③ 패치 완료후 서비스 재시작

** 노드1

$ srvctl start asm -n rac1
$ srvctl start asm -n rac2
$ crs_stat -t
Name           Type           Target    State     Host
------------------------------------------------------------
ora....SM1.asm application    ONLINE    ONLINE    rac1 ◀
ora....C1.lsnr application    ONLINE    ONLINE    rac1
ora.rac1.gsd   application    ONLINE    ONLINE    rac1
ora.rac1.ons   application    ONLINE    ONLINE    rac1
ora.rac1.vip   application    ONLINE    ONLINE    rac1
ora....SM2.asm application    ONLINE    ONLINE    rac2 ◀
ora....C2.lsnr application    ONLINE    ONLINE    rac2
ora.rac2.gsd   application    ONLINE    ONLINE    rac2
ora.rac2.ons   application    ONLINE    ONLINE    rac2
ora.rac2.vip   application    ONLINE    ONLINE    rac2

 ASM 패치 완료
 
 
 

※ 참고 : equivalence 설정

$ cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized.keys

$ cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized.keys

$ ssh rac2 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized.keys

The authenticity of host 'rac2 (192.168.204.129)' can't be established.

RSA key fingerprint is c1:42:e7:90:b0:63:40:92:7f:21:ad:ed:65:60:0b:18.

Are you sure you want to continue connecting (yes/no)? yes

Warning: Permanently added 'rac2,192.168.204.129' (RSA) to the list of known hosts.

oracle@rac2's password:

$ ssh rac2 cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys

oracle@rac2's password:

$ scp ~/.ssh/authorized_keys rac2:~/.ssh/authorized_keys

oracle@rac2's password:

authorized_keys                                      100% 1644     1.6KB/s   00:00

$ ssh rac1 date

2012. 03. 07. (수) 00:16:49 KST

$ ssh rac1-priv date

2012. 03. 07. (수) 00:16:52 KST

$ ssh rac2 date

2012. 03. 07. (수) 00:16:57 KST

$ ssh rac2-priv date

2012. 03. 07. (수) 00:16:59 KST

암호 묻지 않으면 성공 

 
 
2. RAC 설치중 에러
 : CRS-1006, CRS-0215
   → Clusterware 설치 후 스크립트 실행 후 VIP를 구성하기 위해 node2에서 vipca 실행 중 에러
 
 
1) 증상
: CRS-1006: No more members to consider
  CRS-0215: Could not start resource 'ora.rac1.vip'
 

2) 원인
: 네트워크 구성 중 ping 168.126.63.1 에서 Unreachable 오류 무시하고 계속 진행시 해당 오류 발생
 

3) 해결1
: 해당 에러 무시하고 넘어가도 결국 처음부터 다시 설치해야 함.

① CRS-1006: No more members to consider
 : IP 체크 다시 하기 - ping 확인해보기
   # ping 168.126.63.1
 

② CRS-0215: Could not start resource 'ora.rac1.vip'
 : /etc/hosts 파일수정
   127.0.0.1 localhost 추가 후
   # crs_start -all
 
 

4) 해결2
: 모든 설치 취소 후 Clusterware 삭제후 재설치

※ Clusterware 삭제법
(원본출처 : http://jigi.net/4270)
 
 
1. 삭제 스크립트 실행

$ $ORA_CRS_HOME/install/rootdelete.sh
$ $ORA_CRS_HOME/install/rootdeinstall.sh

  
2. 노드 application 프로세스 중단

$ srvctl stop nodeapps -n <node name>

  

3. 부팅 시 노드 application 자동 실행 방지(root 권한으로 실행)
Sun:

# rm /etc/init.d/init.cssd
# rm /etc/init.d/init.crs
# rm /etc/init.d/init.crsd
# rm /etc/init.d/init.evmd
# rm /etc/rc3.d/K96init.crs
# rm /etc/rc3.d/S96init.crs
# rm -Rf /var/opt/oracle/scls_scr
# rm -Rf /var/opt/oracle/oprocd
# rm /etc/inittab.crs
# cp /etc/inittab.orig /etc/inittab

Linux:

# rm -f /etc/init.d/init.cssd
# rm -f /etc/init.d/init.crs
# rm -f /etc/init.d/init.crsd
# rm -f /etc/init.d/init.evmd
# rm -f /etc/rc2.d/K96init.crs
# rm -f /etc/rc2.d/S96init.crs
# rm -f /etc/rc3.d/K96init.crs
# rm -f /etc/rc3.d/S96init.crs
# rm -f /etc/rc5.d/K96init.crs
# rm -f /etc/rc5.d/S96init.crs
# rm -Rf /etc/oracle/scls_scr
# rm -f /etc/inittab.crs
# cp /etc/inittab.orig /etc/inittab

HP-UX:

# rm /sbin/init.d/init.cssd
# rm /sbin/init.d/init.crs
# rm /sbin/init.d/init.crsd
# rm /sbin/init.d/init.evmd
# rm /sbin/rc3.d/K960init.crs
# rm /sbin/rc3.d/S960init.crs
# rm -Rf /var/opt/oracle/scls_scr
# rm -Rf /var/opt/oracle/oprocd
# rm /etc/inittab.crs
# cp /etc/inittab.orig /etc/inittab

HP Tru64:

# rm /sbin/init.d/init.cssd
# rm /sbin/init.d/init.crs
# rm /sbin/init.d/init.crsd
# rm /sbin/init.d/init.evmd
# rm /sbin/rc3.d/K96init.crs
# rm /sbin/rc3.d/S96init.crs
# rm -Rf /var/opt/oracle/scls_scr
# rm -Rf /var/opt/oracle/oprocd
# rm /etc/inittab.crs
# cp /etc/inittab.orig /etc/inittab

IBM AIX:

# rm /etc/init.cssd
# rm /etc/init.crs
# rm /etc/init.crsd
# rm /etc/init.evmd
# rm /etc/rc.d/rc2.d/K96init.crs
# rm /etc/rc.d/rc2.d/S96init.crs
# rm -Rf /etc/oracle/scls_scr
# rm -Rf /etc/oracle/oprocd
# rm /etc/inittab.crs
# cp /etc/inittab.orig /etc/inittab

  
5. Oracle Universal Installer에서 CRS home을 선택 후 "설치해제"
 
 
6. dd 명령으로 OCR 및 Voting File을 제거
 
예제:

# dd if=/dev/zero of=/dev/raw/raw1 bs=8192
# dd if=/dev/zero of=/dev/raw/raw2 bs=8192
# dd if=/dev/zero of=/dev/rdsk/V1064_vote_01_20m.dbf bs=8192 count=2560
# dd if=/dev/zero of=/dev/rdsk/ocrV1064_100m.ora bs=8192 count=12800

만약 RDBMS 설치를 제거한다면, 사용중이던 ASM 디스크도 정리한다.
CRS를 재 설치하고자 하면, RAC 설치 매뉴얼에 기술된 순서대로 설치를 다시 진행한다.

※ 참고 : 프로세스가 살아 있다면 EVM, CRS 및 CSS 프로세스를 kill 시키거나 노드를 재부팅 한다

ps -ef | grep crs
ps -ef | grep evm
ps -ef | grep css