OCR, VOTE ASM Disk에서 RawDevice로 Disk 변경 TEST

  • 해당 TEST 내역은 개인적인 RAC 환경에서 진행한 내역으로 참고적으로 판단하여 사용하길 바란다.

   

1.OCR ASM Disk에서 RawDevice로 변경

OCR 상태조회

[root@rac1 bin]# ./ocrcheck

   

OCR Disk 변경

[root@rac1 bin]# ./ocrconfig -add /dev/OCR/ocr1

[root@rac1 bin]# ./ocrconfig -add /dev/OCR/ocr2

[root@rac1 bin]# ./ocrcheck

   

③ OCR ASM Disk 제거

[root@rac1 bin]# ./ocrconfig -delete +DATA

[root@rac1 bin]# ./ocrcheck

   

2.Vote ASM Disk에서 RawDevice로 변경

Vote ASM DISK Replace 진행(에러)

[root@rac1 bin]# ./crsctl replace votedisk /dev/VOTE/vote1

Now formatting voting disk: /dev/VOTE/vote1.

CRS-4256: Updating the profile

CRS-4602: Failed 27 to add voting file 2448120a036d4f11bf362b1db9d6ff0f.

Failure 27 with Cluster Synchronization Services while deleting voting disk.

Failure 27 with Cluster Synchronization Services while deleting voting disk.

Failure 27 with Cluster Synchronization Services while deleting voting disk.

CRS-4000: Command Replace failed, or completed with errors.

[root@rac1 bin]#

   

에러발생시에 아래와 동일하게 진행

   

Vote ASM DISK Replace 진행 (RAC1,RAC2 모두 STOP 이후 진행)

[CRS 재기동]

[root@rac1 bin]# ./crsctl start crs -excl -nocrs (crsctl stop crs 를 진행 이후)

CRS-4123: Oracle High Availability Services has been started.

CRS-2672: Attempting to start 'ora.mdnsd' on 'rac1'

CRS-2676: Start of 'ora.mdnsd' on 'rac1' succeeded

CRS-2672: Attempting to start 'ora.gpnpd' on 'rac1'

CRS-2676: Start of 'ora.gpnpd' on 'rac1' succeeded

CRS-2672: Attempting to start 'ora.cssdmonitor' on 'rac1'

CRS-2672: Attempting to start 'ora.gipcd' on 'rac1'

CRS-2676: Start of 'ora.cssdmonitor' on 'rac1' succeeded

CRS-2676: Start of 'ora.gipcd' on 'rac1' succeeded

CRS-2672: Attempting to start 'ora.cssd' on 'rac1'

CRS-2672: Attempting to start 'ora.diskmon' on 'rac1'

CRS-2676: Start of 'ora.diskmon' on 'rac1' succeeded

CRS-2676: Start of 'ora.cssd' on 'rac1' succeeded

[root@rac1 bin]#

[root@rac1 bin]#

   

[Vote disk 상태 확인]

[root@rac1 bin]# ./crsctl query css votedisk

[root@rac1 bin]#

[root@rac1 bin]#

   

[Vote Disk Replace, RawDevice로 변경]

[root@rac1 bin]# ./crsctl replace votedisk /dev/VOTE/vote1

[root@rac1 bin]# ./crsctl replace votedisk /dev/VOTE/vote2

[root@rac1 bin]# ./crsctl replace votedisk /dev/VOTE/vote3

   

CRS 정상 기동 확인

[root@rac1 bin]# ./crsctl stop crs

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac1'

CRS-2673: Attempting to stop 'ora.cssd' on 'rac1'

CRS-2673: Attempting to stop 'ora.mdnsd' on 'rac1'

CRS-2677: Stop of 'ora.cssd' on 'rac1' succeeded

CRS-2673: Attempting to stop 'ora.gipcd' on 'rac1'

CRS-2677: Stop of 'ora.mdnsd' on 'rac1' succeeded

CRS-2677: Stop of 'ora.gipcd' on 'rac1' succeeded

CRS-2673: Attempting to stop 'ora.gpnpd' on 'rac1'

CRS-2677: Stop of 'ora.gpnpd' on 'rac1' succeeded

CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac1' has completed

CRS-4133: Oracle High Availability Services has been stopped.

[root@rac1 bin]#
[root@rac1 bin]# ./crsctl start crs

(생략)

..

[root@rac1 bin]# ./crsctl query css votedisk

 

   

[RAC 1번 작업 이후 2번에서도 해주어야 된다!]


블로그 이미지

운명을바꾸는자

IT와 함께 살아가는 삶

,

   

ODA 기본 OS 상태에서 Grid & DB Installation

   

  • ODA 구성에 있어 Bare Metal,OVM 2가지 구성 방식이 있는대 해당 설치는 OVM을 활용한 ODA 세팅에 대한 내역을 기술하였다.
  • ODA 설치 순서 : DOM0(CPU, Memory 할당) -> ODA_BASE(oakcli 구성) -> oakDom1(GRID, DB 구성)

   

1.XM list 확인

  • XM List로 현재 ODA장비에서 사용 가능한 VMWARE 내역을 확인할 수 있다.

[root@demo0 ~]# xm list

Name ID Mem VCPUs State Time(s)

Domain-0 0 4096 24 r----- 51006.4

oakDom1 1 40960 12 r----- 110634.9

[root@demo0 ~]#

   

2.XM list 접근

  • OVM의 경우에 dom0에서 이동이 가능하며, 추가적으로 OVM을 구성하여 다양한 OS, WAS, DB등을 구성하여 OS Resource를 나누어 구성할 수 있다.

[root@demo0 ~]# xm console oakDom1

   

Oracle Linux Server release 5.11

Kernel 2.6.39-400.245.1.el5uek on an x86_64

   

base0 login: root

Password:

Last login: Fri Aug 14 01:13:00 from 192.168.16.24

[root@base0 ~]# id

uid=0(root) gid=0(root) groups=0(root),1(bin),2(daemon),3(sys),4(adm),6(disk),10(wheel)

[root@base0 ~]# df -k

   

3.Network 설정

  • 초기 Network 설정 시에 아래 명령어를 통하여 설정할 경우에 OS의 Network 설정을 자동으로 해준다.

[root@demo1 ~]# oakcli

Usage: oakcli <command><object>[<options>]

<command>: [show | configure | deploy | start | stop | restart | create | delete]

<object>: [firstnet | oda_base | env_hw | vlan | -changeNetCard | -publicNet]

[<options>]: [force]

   

Examples:

oakcli [show|configure][firstnet]

The command is used to configure | show the firstnet, the dom0 network.

   

oakcli [configure|show|deploy|start|stop|restart][oda_base][force]

The command is used to configure|show|deploy|start|stop|restart the oda_base domain.

You can also use force option with stop command to forceful shutdown of oda_base domain

   

For detailed help on each command use:

oakcli <command><object> -h or

oakcli <command><object> -help

   

[root@demo1 ~]# oakcli configure firstnet

Configure the network for the node(s)(local, global) [global]:

 

4.GRID 설치 및 ASM Disk 구성

  • ODA 장비에서 Grid 및 ASM Disk 구성을 하기 위하여 아래 명령어로 설치를 진행한다. (Xmanager를 활용하여 GUI 실행)
  • 설치 시 세부 설정만 해준다면 자동으로 설치가 완료된다.

[root@base0 ~]# export DISPLAY=192.168.0.9:0.0

[root@base0 ~]# xclock

[root@base0 ~]#

[root@base0 ~]#

[root@base0 ~]# oakcli deploy

Log messages in /tmp/oak_1439487879310.log

Running Oracle Appliance Manager

   

[ODA oakcli deploy Start]

   

   

   

-Database Backup Location (Local, External, REPO 공간)

   

   

   

-사용할 Network 설정 진행, ILOM의 경우에는 DOM0와 동일한 IP로 설정해준다.

-/etc/hosts에도 자동으로 IP 내역이 설정 된다.

   

   

   

   

   

   

   

   

5.DBCA

  • DBCA를 통하여 RAC DB 생성 진행한다

[oracle@base0 ~]$ export DISPLAY=192.168.0.9:0.0

[oracle@base0 ~]$ xclock

   

[oracle@base0 ~]$

[oracle@base0 ~]$

[oracle@base0 ~]$ dbca

   

   

   

   

-Oracle Real Application Clusters (RAC) database 선택

   

   

-GSID 설정

   

   

   

   

   

-ASM Disk 선택

   

   

   

   

   

   

6.DB 상태 확인

  • Oracle 12c가 되면서 부과적인 기능들이 많이 추가 되었다. Oracle 12c 이론 및 기능 테스트를 별도로 포스팅할 예정이다.

[grid@base0 ~]$ crsctl stat res -t

--------------------------------------------------------------------------------

Name Target State Server State details

--------------------------------------------------------------------------------

Local Resources

--------------------------------------------------------------------------------

ora.ASMNET1LSNR_ASM.lsnr

ONLINE ONLINE base0 STABLE

ONLINE ONLINE base1 STABLE

ora.DATA.WIN7.advm

ONLINE ONLINE base0 STABLE

ONLINE OFFLINE base1 STABLE

ora.DATA.WINDOW7.advm

ONLINE ONLINE base0 STABLE

ONLINE OFFLINE base1 STABLE

ora.DATA.dg

ONLINE ONLINE base0 STABLE

ONLINE OFFLINE base1 STABLE

ora.LISTENER.lsnr

ONLINE ONLINE base0 STABLE

ONLINE ONLINE base1 STABLE

ora.RECO.DATAFSVOL.advm

ONLINE ONLINE base0 Volume device /dev/asm/datafsvol-480 is online,STABLE

ONLINE OFFLINE base1 STABLE

ora.RECO.dg

ONLINE ONLINE base0 STABLE

ONLINE OFFLINE base1 STABLE

ora.REDO.AWIN7.advm

ONLINE ONLINE base0 STABLE

ONLINE OFFLINE base1 STABLE

ora.REDO.AWINDOW7.advm

ONLINE ONLINE base0 STABLE

ONLINE OFFLINE base1 STABLE

ora.REDO.dg

ONLINE ONLINE base0 STABLE

ONLINE OFFLINE base1 STABLE

ora.data.win7.acfs

ONLINE ONLINE base0 mounted on /u01/app/sharedrepo/win7,STABLE

ONLINE OFFLINE base1 STABLE

ora.data.window7.acfs

ONLINE ONLINE base0 mounted on /u01/app/sharedrepo/window7,STABLE

ONLINE OFFLINE base1 STABLE

ora.net0.network

ONLINE ONLINE base0 STABLE

ONLINE ONLINE base1 STABLE

ora.net1.network

ONLINE ONLINE base0 STABLE

ONLINE ONLINE base1 STABLE

ora.ons

ONLINE ONLINE base0 STABLE

ONLINE ONLINE base1 STABLE

ora.proxy_advm

ONLINE ONLINE base0 STABLE

ONLINE ONLINE base1 STABLE

ora.reco.datafsvol.acfs

ONLINE ONLINE base0 mounted on /odadatafs,STABLE

ONLINE OFFLINE base1 volume /odadatafs offline,STABLE

--------------------------------------------------------------------------------

Cluster Resources

--------------------------------------------------------------------------------

ora.LISTENER_SCAN1.lsnr

1 ONLINE ONLINE base0 STABLE

ora.MGMTLSNR

1 ONLINE ONLINE base0 169.254.66.185 192.168.16.27,STABLE oserial8250: too much work for irq4

ra.asm

1 ONLINE ONLINE base0 Started,STABLE

2 ONLINE ONLINE base1 Started,STABLE

ora.base0.vip

1 ONLINE ONLINE base0 STABLE

ora.base1.vip

1 ONLINE ONLINE base1 STABLE

ora.cvu

1 ONLINE ONLINE base0 STABLE

ora.havip_0.havip

1 ONLINE ONLINE base0 STABLE

ora.havip_1.havip

1 OFFLINE OFFLINE STABLE

ora.mgmtdb

1 ONLINE ONLINE base0 Open,STABLE

ora.oc4j

1 ONLINE ONLINE base0 STABLE

ora.scan1.vip

1 ONLINE ONLINE base0 STABLE

ora.win7_0.export

1 ONLINE ONLINE base0 STABLE

ora.window7_0.export

1 ONLINE ONLINE base0 STABLE

--------------------------------------------------------------------------------

   

7.ILOM

-현재 ODA에 설치된 OS 및 Grid, DB를 모니터링 할 수 있으며 ISO 파일을 가상으로 삽입하여 설치 및 추가적인 작업을 편하게 진행할 수 있다.

   

-ILOM의 세부 기능을 하나씩 확인할 필요가 있을 것으로 보여진다.

   

[참고 문서 및 사이트]

  • Oracle Database Appliance - 12.1.2 and 2.X Supported ODA Versions & Known Issues (문서 ID 888888.1)


블로그 이미지

운명을바꾸는자

IT와 함께 살아가는 삶

,