'Oda'에 해당되는 글 3건

2015.12.30 Oracle Database Appliance(X5-2) Disk Online replacement
2015.08.26 ODA 기본 OS 상태(OVM환경)에서 Grid & DB Installation
2015.07.30 Oracle Database Appliance(X5-2)

Oracle Database Appliance(X5-2) Disk Online replacement

1. IT Story/DB 2015. 12. 30. 14:42

Oracle Database Appliance(X5-2) Disk Online replacement

ODA 장비의 Disk 교체작업을 Online으로 하기 위하여 수행했던 내역을 정리하여 공유합니다.

0.기존의 Disk Group에서 삭제 및 분리

alter diskgroup DATA drop disk 'HDD_E0_S04_1463938000P1' force ;

alter diskgroup RECO drop disk 'HDD_E0_S04_1463938000P2' force ;

TEST를 위하여 정상인 Disk 1개를 분리시켜 Disk 교체 작업을 진행하였다.

1.ODA Disk 상태 확인

① OAKCLI 명령어

[root@base0 mapper]# oakcli show disk

NAME PATH TYPE STATE STATE_DETAILS

e0_pd_00 /dev/sda HDD ONLINE Good

e0_pd_01 /dev/sdb HDD ONLINE Good

e0_pd_02 /dev/sdaa HDD ONLINE Good

e0_pd_03 /dev/sdab HDD ONLINE Good

e0_pd_04 /dev/sdac HDD UNKNOWN NewDiskInserted

e0_pd_05 /dev/sdad HDD ONLINE Good

e0_pd_06 /dev/sdae HDD ONLINE Good

e0_pd_07 /dev/sdaf HDD ONLINE Good

e0_pd_08 /dev/sdag HDD ONLINE Good

e0_pd_09 /dev/sdah HDD ONLINE Good

e0_pd_10 /dev/sdai HDD ONLINE Good

e0_pd_11 /dev/sdaj HDD ONLINE Good

e0_pd_12 /dev/sdak HDD ONLINE Good

e0_pd_13 /dev/sdal HDD ONLINE Good

e0_pd_14 /dev/sdam HDD ONLINE Good

e0_pd_15 /dev/sdan HDD ONLINE Good

e0_pd_16 /dev/sdao HDD ONLINE Good

e0_pd_17 /dev/sdap HDD ONLINE Good

e0_pd_18 /dev/sdaq HDD ONLINE Good

e0_pd_19 /dev/sdar HDD ONLINE Good

e0_pd_20 /dev/sdas SSD ONLINE Good

e0_pd_21 /dev/sdat SSD ONLINE Good

e0_pd_22 /dev/sdau SSD ONLINE Good

e0_pd_23 /dev/sdav SSD ONLINE Good

[root@base0 mapper]#

② ASM DISK 상태 확인

col GN format 99

col DN format 99

col NAME format a23

SELECT

group_number GN,disk_number DN,name,state,mode_status,mount_status

FROM v$asm_disk

ORDER BY group_number, disk_number;

GN DN NAME STATE MODE_ST MOUNT_S

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

0 0 NORMAL ONLINE CLOSED <- 4번 disk 제거

0 1 NORMAL ONLINE CLOSED <- 4번 disk 제거

1 0 HDD_E0_S17_1463722132P1 NORMAL ONLINE CACHED

1 1 HDD_E0_S05_1463725856P1 NORMAL ONLINE CACHED

1 2 HDD_E0_S12_1463726544P1 NORMAL ONLINE CACHED

1 3 HDD_E0_S10_1463726716P1 NORMAL ONLINE CACHED

1 4 HDD_E0_S16_1463726756P1 NORMAL ONLINE CACHED

1 5 HDD_E0_S08_1463754440P1 NORMAL ONLINE CACHED

1 6 HDD_E0_S15_1463852252P1 NORMAL ONLINE CACHED

1 7 HDD_E0_S19_1463885988P1 NORMAL ONLINE CACHED

1 8 HDD_E0_S01_1463911124P1 NORMAL ONLINE CACHED

GN DN NAME STATE MODE_ST MOUNT_S

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

1 9 HDD_E0_S07_1463917036P1 NORMAL ONLINE CACHED

1 10 HDD_E0_S02_1463917808P1 NORMAL ONLINE CACHED

1 11 HDD_E0_S18_1463929152P1 NORMAL ONLINE CACHED

1 12 HDD_E0_S13_1463929180P1 NORMAL ONLINE CACHED

1 13 HDD_E0_S14_1463929248P1 NORMAL ONLINE CACHED

1 14 HDD_E0_S11_1463935128P1 NORMAL ONLINE CACHED

1 16 HDD_E0_S00_1463938068P1 NORMAL ONLINE CACHED

1 17 HDD_E0_S03_1463941008P1 NORMAL ONLINE CACHED

1 18 HDD_E0_S09_1463967484P1 NORMAL ONLINE CACHED

1 19 HDD_E0_S06_1463969744P1 NORMAL ONLINE CACHED

2 0 HDD_E0_S17_1463722132P2 NORMAL ONLINE CACHED

GN DN NAME STATE MODE_ST MOUNT_S

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

2 1 HDD_E0_S05_1463725856P2 NORMAL ONLINE CACHED

2 2 HDD_E0_S12_1463726544P2 NORMAL ONLINE CACHED

2 3 HDD_E0_S10_1463726716P2 NORMAL ONLINE CACHED

2 4 HDD_E0_S16_1463726756P2 NORMAL ONLINE CACHED

2 5 HDD_E0_S08_1463754440P2 NORMAL ONLINE CACHED

2 6 HDD_E0_S15_1463852252P2 NORMAL ONLINE CACHED

2 7 HDD_E0_S19_1463885988P2 NORMAL ONLINE CACHED

2 8 HDD_E0_S01_1463911124P2 NORMAL ONLINE CACHED

2 9 HDD_E0_S07_1463917036P2 NORMAL ONLINE CACHED

2 10 HDD_E0_S02_1463917808P2 NORMAL ONLINE CACHED

2 11 HDD_E0_S18_1463929152P2 NORMAL ONLINE CACHED

GN DN NAME STATE MODE_ST MOUNT_S

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

2 12 HDD_E0_S13_1463929180P2 NORMAL ONLINE CACHED

2 13 HDD_E0_S14_1463929248P2 NORMAL ONLINE CACHED

2 14 HDD_E0_S11_1463935128P2 NORMAL ONLINE CACHED

2 16 HDD_E0_S00_1463938068P2 NORMAL ONLINE CACHED

2 17 HDD_E0_S03_1463941008P2 NORMAL ONLINE CACHED

2 18 HDD_E0_S09_1463967484P2 NORMAL ONLINE CACHED

2 19 HDD_E0_S06_1463969744P2 NORMAL ONLINE CACHED

3 0 SSD_E0_S20_805971985P1 NORMAL ONLINE CACHED

3 1 SSD_E0_S21_805972008P1 NORMAL ONLINE CACHED

3 2 SSD_E0_S22_805972069P1 NORMAL ONLINE CACHED

3 3 SSD_E0_S23_805972099P1 NORMAL ONLINE CACHED

44 rows selected.

③ ISOF 상태 확인

[root@base0 mapper]# lsof | grep HDD_E0_S04 <- 비정상

[root@base0 mapper]# lsof | grep HDD_E0_S03 <- 정상

asm_dbw0_ 21756 grid 257u BLK 252,36 0t0 20941 /dev/mapper/HDD_E0_S03_1463941008p1

asm_rbal_ 21768 grid 286u BLK 252,37 0t0 20942 /dev/mapper/HDD_E0_S03_1463941008p2

asm_rbal_ 21768 grid 287u BLK 252,36 0t0 20941 /dev/mapper/HDD_E0_S03_1463941008p1

asm_gmon_ 21770 grid 272u BLK 252,36 0t0 20941 /dev/mapper/HDD_E0_S03_1463941008p1

asm_gmon_ 21770 grid 291u BLK 252,37 0t0 20942 /dev/mapper/HDD_E0_S03_1463941008p2

apx_rbal_ 22990 grid 286u BLK 252,37 0t0 20942 /dev/mapper/HDD_E0_S03_1463941008p2

oracle 26343 oracle 273u BLK 252,36 0t0 20941 /dev/mapper/HDD_E0_S03_1463941008p1

oracle 26345 oracle 273u BLK 252,36 0t0 20941 /dev/mapper/HDD_E0_S03_1463941008p1

oracle 26347 oracle 264u BLK 252,36 0t0 20941 /dev/mapper/HDD_E0_S03_1463941008p1

oracle 26349 oracle 269u BLK 252,36 0t0 20941 /dev/mapper/HDD_E0_S03_1463941008p1

oracle 26349 oracle 282u BLK 252,37 0t0 20942 /dev/mapper/HDD_E0_S03_1463941008p2

oracle 26351 oracle 272u BLK 252,36 0t0 20941 /dev/mapper/HDD_E0_S03_1463941008p1

oracle 26351 oracle 291u BLK 252,37 0t0 20942 /dev/mapper/HDD_E0_S03_1463941008p2

oracle 26357 oracle 272u BLK 252,36 0t0 20941 /dev/mapper/HDD_E0_S03_1463941008p1

oracle 26357 oracle 291u BLK 252,37 0t0 20942 /dev/mapper/HDD_E0_S03_1463941008p2

oracle 48681 oracle 263u BLK 252,36 0t0 20941 /dev/mapper/HDD_E0_S03_1463941008p1

2.기존 Disk 제거 및 신규 Disk 삽입

① ODA 장비에서 해당 Disk 를 확인하기 위하여 Disk Light ON

oakcli locate disk e0_pd_04 on/off

해당 명령어를 수행하면 ODA장비의 Disk 영역에 불빛이 들어온다.

② 신규 Disk 삽입 및 신규 정보 등록

(동일한 Disk를 다시 삽입(정상인 Disk)하면 Data Rebalancing이 자동 수행되어 Disk가 삽입될 수 있다.)

- Data Rebalancing 확인 명령어

select * from gv$asm_operation; -- Data rebalancing 확인

- 1번 node(Master Node)에서만 작업이 가능하다

[root@base0 mapper]# oakcli add disk e0_pd_04

Choose any of following option

0 : Exit add disk operation

1 : Try to add disk only to OAKD not to ASM

2 : Try to add disk to OAKD and ASM

Enter number between 0-2 : 2

INFO: 2015-12-13 01:16:08: adddisk operation takes about 7-8 minutes, so be patience and don't abort early

INFO: 2015-12-13 01:16:08: Setting up root ssh across the private network

Please enter the 'root' password : --(중요) 특수 문자 안됨, SSH 22번 포트만 가능

Please re-enter the 'root' password: --(중요) 특수 문자 안됨, SSH 22번 포트만 가능

...........done

INFO: 2015-12-13 01:17:08: Executing function dump_var_values. Dumping variable values passed to storage adapters code

INFO: 2015-12-13 01:17:08: resourceName=e0_pd_04, expander=e0, slotnum=04

INFO: 2015-12-13 01:17:08: slotnumMinusLeadingZero=4, disk=HDD, _OAK_AsmDiskList=e0_data_04 e0_reco_04

INFO: 2015-12-13 01:17:08: output=/dev/sdac /dev/sde

INFO: 2015-12-13 01:17:08: _OAK_MultiPathList=/dev/sdac /dev/sde, _OAK_DiskId=35000cca05741ebd0, OAK_UsrDevName=HDD_E0_S04_1463938000

INFO: 2015-12-13 01:17:08: DevName=HDD_E0_S04_1463938000, last8byet=5741ebd0, last8byetInDecimal=1463938000

INFO: 2015-12-13 01:17:08: dataDgRatio=86, recoDgRatio=14, OAK_PartitionMap=86,14

INFO: 2015-12-13 01:17:08: _OAK_OSUserType=userType:Multiuser, _OAK_Size=900185481216, _OAK_TotalSectors=1758174768

INFO: 2015-12-13 01:17:08: Executing function check_resource_status_in_asm

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

INFO: 2015-12-13 01:17:09: Executing function: Setting up variable for node1

INFO: 2015-12-13 01:17:09: Executing function: Calling CleanPDisk on node1

INFO: Found the HDD_E0_S04 already present in the config, will remove it for 35000cca05741ebd0

INFO: Removing entry for HDD_E0_S04 and old diskName is HDD_E0_S04_1463938000

INFO: Running /sbin/kpartx -d /dev/mapper/HDD_E0_S04_1463938000

Warning: Disk has a valid GPT signature but invalid PMBR.

Assuming this disk is *not* a GPT disk anymore.

Use gpt kernel option to override. Use GNU Parted to correct disk.

INFO: Updated /etc/multipath.conf file

INFO: Calling function removePartitionMapping

INFO: Running /sbin/kpartx -d /dev/mapper/HDD_E0_S04_1463938000

Warning: Disk has a valid GPT signature but invalid PMBR.

Assuming this disk is *not* a GPT disk anymore.

Use gpt kernel option to override. Use GNU Parted to correct disk.

INFO: Calling function flushMultipathDiskPath

INFO: Running /sbin/multipath -f HDD_E0_S04_1463938000

INFO: Calling function removeDevMapPath

INFO: Running /sbin/dmsetup remove -f HDD_E0_S04_1463938000

device-mapper: table ioctl failed: No such device or address

device-mapper: reload ioctl failed: No such device or address

device-mapper: remove ioctl failed: No such device or address

Command failed

ERROR: Failure in running /sbin/dmsetup remove -f HDD_E0_S04_1463938000, system command return status 256

INFO: 2015-12-13 01:17:09: Executing function: Calling AddPDisk on node1

INFO: addPDisk function with ResetDisk set to true

INFO: Calling function checkDiskReadyNess

INFO: Running /usr/bin/sg_turs /dev/sdac

INFO: Running /bin/dd if=/dev/sdac iflag=direct of=/dev/null count=100 bs=1024k 2>&1

100+0 records in

100+0 records out

104857600 bytes (105 MB) copied, 0.570512 seconds, 184 MB/s

INFO: Running /bin/dd if=/dev/zero of=/dev/sdac oflag=direct count=100 bs=1024k 2>&1

100+0 records in

100+0 records out

104857600 bytes (105 MB) copied, 1.16047 seconds, 90.4 MB/s

INFO: adding the 35000cca05741ebd0 to the config at the end

INFO: Updated /etc/multipath.conf file

INFO: Running /sbin/multipath -v2 in reloadMultipathDevMap

create: HDD_E0_S04_1463938000 (35000cca05741ebd0) undef HITACHI,H109090SESUN900G

size=838G features='0' hwhandler='0' wp=undef

`-+- policy='round-robin 0' prio=1 status=undef

|- 3:0:26:0 sde 8:64 undef ready running

`- 2:0:26:0 sdac 65:192 undef ready running

INFO: Running /sbin/kpartx -a /dev/mapper/HDD_E0_S04_1463938000 in reloadMultipathDevMap

Warning: Disk has a valid GPT signature but invalid PMBR.

Assuming this disk is *not* a GPT disk anymore.

Use gpt kernel option to override. Use GNU Parted to correct disk.

INFO: running parted -s /dev/mapper/HDD_E0_S04_1463938000 unit % print

….

문제 없이 Disk 삽입에 따른 환경 설정이 완료된다.

3.Disk 삽입 완료 후 상태확인

① OAKCLI 명령어

[root@base0 mapper]# oakcli show disk

=> e0_pd_04 /dev/sdac HDD UNKNOWN NewDiskInserted 상태가 good로 변경

NAME PATH TYPE STATE STATE_DETAILS

e0_pd_00 /dev/sda HDD ONLINE Good

e0_pd_01 /dev/sdb HDD ONLINE Good

e0_pd_02 /dev/sdaa HDD ONLINE Good

e0_pd_03 /dev/sdab HDD ONLINE Good

e0_pd_04 /dev/sdac HDD ONLINE Good

e0_pd_05 /dev/sdad HDD ONLINE Good

-> Disk 인식 완료

② ASM Disk 상태 확인

SQL> col GN format 99

SQL> col DN format 99

SQL> col NAME format a23

SQL>

SQL> SELECT

2 group_number GN,disk_number DN,name,state,mode_status,mount_status

3 FROM v$asm_disk

4 ORDER BY group_number, disk_number;

GN DN NAME STATE MODE_ST MOUNT_S

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

1 0 HDD_E0_S17_1463722132P1 NORMAL ONLINE CACHED

1 1 HDD_E0_S05_1463725856P1 NORMAL ONLINE CACHED

1 2 HDD_E0_S12_1463726544P1 NORMAL ONLINE CACHED

1 3 HDD_E0_S10_1463726716P1 NORMAL ONLINE CACHED

1 4 HDD_E0_S16_1463726756P1 NORMAL ONLINE CACHED

1 5 HDD_E0_S08_1463754440P1 NORMAL ONLINE CACHED

1 6 HDD_E0_S15_1463852252P1 NORMAL ONLINE CACHED

1 7 HDD_E0_S19_1463885988P1 NORMAL ONLINE CACHED

1 8 HDD_E0_S01_1463911124P1 NORMAL ONLINE CACHED

1 9 HDD_E0_S07_1463917036P1 NORMAL ONLINE CACHED

1 10 HDD_E0_S02_1463917808P1 NORMAL ONLINE CACHED

GN DN NAME STATE MODE_ST MOUNT_S

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

1 11 HDD_E0_S18_1463929152P1 NORMAL ONLINE CACHED

1 12 HDD_E0_S13_1463929180P1 NORMAL ONLINE CACHED

1 13 HDD_E0_S14_1463929248P1 NORMAL ONLINE CACHED

1 14 HDD_E0_S11_1463935128P1 NORMAL ONLINE CACHED

1 15 HDD_E0_S04_1463938000P1 NORMAL ONLINE CACHED

1 16 HDD_E0_S00_1463938068P1 NORMAL ONLINE CACHED

1 17 HDD_E0_S03_1463941008P1 NORMAL ONLINE CACHED

1 18 HDD_E0_S09_1463967484P1 NORMAL ONLINE CACHED

1 19 HDD_E0_S06_1463969744P1 NORMAL ONLINE CACHED

2 0 HDD_E0_S17_1463722132P2 NORMAL ONLINE CACHED

2 1 HDD_E0_S05_1463725856P2 NORMAL ONLINE CACHED

GN DN NAME STATE MODE_ST MOUNT_S

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

2 2 HDD_E0_S12_1463726544P2 NORMAL ONLINE CACHED

2 3 HDD_E0_S10_1463726716P2 NORMAL ONLINE CACHED

2 4 HDD_E0_S16_1463726756P2 NORMAL ONLINE CACHED

2 5 HDD_E0_S08_1463754440P2 NORMAL ONLINE CACHED

2 6 HDD_E0_S15_1463852252P2 NORMAL ONLINE CACHED

2 7 HDD_E0_S19_1463885988P2 NORMAL ONLINE CACHED

2 8 HDD_E0_S01_1463911124P2 NORMAL ONLINE CACHED

2 9 HDD_E0_S07_1463917036P2 NORMAL ONLINE CACHED

2 10 HDD_E0_S02_1463917808P2 NORMAL ONLINE CACHED

2 11 HDD_E0_S18_1463929152P2 NORMAL ONLINE CACHED

2 12 HDD_E0_S13_1463929180P2 NORMAL ONLINE CACHED

GN DN NAME STATE MODE_ST MOUNT_S

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

2 13 HDD_E0_S14_1463929248P2 NORMAL ONLINE CACHED

2 14 HDD_E0_S11_1463935128P2 NORMAL ONLINE CACHED

2 15 HDD_E0_S04_1463938000P2 NORMAL ONLINE CACHED

2 16 HDD_E0_S00_1463938068P2 NORMAL ONLINE CACHED

2 17 HDD_E0_S03_1463941008P2 NORMAL ONLINE CACHED

2 18 HDD_E0_S09_1463967484P2 NORMAL ONLINE CACHED

2 19 HDD_E0_S06_1463969744P2 NORMAL ONLINE CACHED

3 0 SSD_E0_S20_805971985P1 NORMAL ONLINE CACHED

3 1 SSD_E0_S21_805972008P1 NORMAL ONLINE CACHED

3 2 SSD_E0_S22_805972069P1 NORMAL ONLINE CACHED

3 3 SSD_E0_S23_805972099P1 NORMAL ONLINE CACHED

③ ISOF 상태 확인

정상적으로 해당 프로세스들이 올라오는 것을 확인할 수 있다.

[root@base0 mapper]# lsof | grep HDD_E0_S04

asm_dbw0_ 38776 grid 280u BLK 252,38 0t0 5509236 /dev/mapper/HDD_E0_S04_1463938000p1

asm_rbal_ 38788 grid 256u BLK 252,39 0t0 5505972 /dev/mapper/HDD_E0_S04_1463938000p2

asm_rbal_ 38788 grid 257u BLK 252,38 0t0 5509236 /dev/mapper/HDD_E0_S04_1463938000p1

apx_rbal_ 40507 grid 256u BLK 252,39 0t0 5505972 /dev/mapper/HDD_E0_S04_1463938000p2

mdb_dbw0_ 41381 grid 275u BLK 252,38 0t0 5509236 /dev/mapper/HDD_E0_S04_1463938000p1

mdb_ckpt_ 41385 grid 259u BLK 252,38 0t0 5509236 /dev/mapper/HDD_E0_S04_1463938000p1

mdb_smon_ 41389 grid 258u BLK 252,38 0t0 5509236 /dev/mapper/HDD_E0_S04_1463938000p1

mdb_rbal_ 41397 grid 257u BLK 252,38 0t0 5509236 /dev/mapper/HDD_E0_S04_1463938000p1

oracle 41476 oracle 274u BLK 252,38 0t0 5509236 /dev/mapper/HDD_E0_S04_1463938000p1

oracle 41478 oracle 265u BLK 252,38 0t0 5509236 /dev/mapper/HDD_E0_S04_1463938000p1

oracle 41480 oracle 266u BLK 252,38 0t0 5509236 /dev/mapper/HDD_E0_S04_1463938000p1

oracle 41486 oracle 272u BLK 252,38 0t0 5509236 /dev/mapper/HDD_E0_S04_1463938000p1

oracle 41490 oracle 294u BLK 252,38 0t0 5509236 /dev/mapper/HDD_E0_S04_1463938000p1

oracle 41490 oracle 295u BLK 252,39 0t0 5505972 /dev/mapper/HDD_E0_S04_1463938000p2

oracle_41 41564 grid 257u BLK 252,39 0t0 5505972 /dev/mapper/HDD_E0_S04_1463938000p2

asm_x000_ 87135 grid 271u BLK 252,38 0t0 5509236 /dev/mapper/HDD_E0_S04_1463938000p1

4.Parameter File

/etc/multipath.conf -> oakcli 확인 명령어

/opt/oracle/extapi/asmappl.config -> SQL 확인 명령어

multipath -r; multipath -F; multipath -v2

2번의 명령어를 통한 작업이 정상적으로 수행되지 않을 경우에 해당 파라미터 파일을 조작하여 작업을 진행할 수도 있음.

'1. IT Story > DB' 카테고리의 다른 글

Amazon AWS Aurora DB 구축 Q&A 정리(2020) (0)	2020.12.24
Oracle MySQL 운영관리 Q&A 정리(2020) (0)	2020.12.24
Oracle 11G RAC Engine,OCR,VOTE Backup/Recovery(백업/복구) (0)	2020.12.24
대량 데이터 변경 세션 KILL 수행 후, ROLLBACK 모니터링 방법 (0)	2020.12.24
Adding MySQL Cluster Data Nodes Online (0)	2015.12.24
MySQL Monitor Tool Install (0)	2015.12.24
Oracle 서비스지원(SR) 신청 방법 (0)	2015.10.07
IBM SPSS Statistics 22 Installation on Windows7 32bit (0)	2015.10.06

운명을바꾸는자

IT와 함께 살아가는 삶

ODA 기본 OS 상태(OVM환경)에서 Grid & DB Installation

1. IT Story/DB 2015. 8. 26. 22:50

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>]

[<options>]: [force]

Examples:

oakcli [show|configure][firstnet]

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

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 ~]# 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 ~]$ 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)

'1. IT Story > DB' 카테고리의 다른 글

Oracle Flashback (0)	2015.09.04
Oracle RAC 11gR2 Management (0)	2015.09.04
Oracle RAC 11gR2 Failover 구성 (0)	2015.09.04
OCR, VOTE ASM Disk에서 RawDevice로 Disk 변경 TEST (0)	2015.08.26
Oracle Exadata TEST Single Database Installation : Install Database S/W & TEST Database (1)	2015.08.21
Oracle Exadata TEST Single Database Installation : Install Grid Infrastructure (1)	2015.08.21
Oracle Exadata TEST Single Database Installation : Storage Cell disk (3)	2015.08.21
Oracle Exadata TEST Single Database Installation : OVM TEST Environment (2)	2015.08.21

운명을바꾸는자

IT와 함께 살아가는 삶

Oracle Database Appliance(X5-2)

1. IT Story/DB 2015. 7. 30. 22:10

Oracle Database Applicance(ODA X5-2)

1.ODA 장비 전면 부 모습

2. ODA 장비 후면 부 모습

3. ODA 세부 규격

4. ODA 환경 확인 Command

oakcli show asr	Displays the Oracle Auto Service Request configuration
oakcli show cooling	Displays the status of the cooling units
oakcli show controller	Displays information about the disk controllers
oakcli show core_config_key	Displays information a bout the core deploy ment
oakcli show cpupool	Displays information about mappings between cores and virtual machines
oakcli show databases	Displays information about the databases
oakcli show dbhomes	Displays information about the database homes
oakcli show db_config_params	Displays configuration file names and parameters
oakcli show disk	Displays information about shared or local disks
oakcli show diskgroup	Displays information about Oracle ASM disk groups.
oakcli show env_hw	Displays the current server's environment type and hardware version
oakcli show expander	Displays information about the expanders
oakcli show enclosure	Displays information about the storage enclosure
oakcli show memory	Displays information about the memory subsystem
oakcli show network on	Displays information about the network subsystem
oakcli show power on p	Displays the status of the power supply subsystem
oakcli show processor	Displays processor (CPU) information
oakcli show repo on pa	Displays information about virtual machine repositories
oakcli show server on	Displays information about the server subsystem
oakcli show storage	Displays in formation about the storage
oakcli show validation storage	Displays status (enabled or disabled) of validation storage error reporting
oakcli show validation storag	eerrors Displays hard storage errors
oakcli show validation storage	failures Displays soft storage errors
oakcli show version	Displays version information for the software and firmware
oakcli show vlan	Displays version information about virtual local area networks
oakcli show vm	Displays version information about virtual machines
oakcli show vmtemplate	Displays information about virtual machine templates

'1. IT Story > DB' 카테고리의 다른 글

11gR2 RAC ASM환경에서 Controlfile mirror, Redolog 변경 및 기타 TEST (0)	2015.08.07
Oracle 11g Upgrade 11.2.0.1 -> 11.2.0.4 (DB생성된 후 패치) SILENT MODE (0)	2015.08.06
Oracle 서버 버전별 기능비교(12c New Features) (0)	2015.08.04
AWR Report 기초 (0)	2015.08.04
Function 수행횟수 확인 TEST (0)	2015.07.30
DECODE Function Test (0)	2015.07.29
RAC& ASM to Single& Filesystem Clone DB Create (0)	2015.07.29
Oracle Data Masking TEST2 추가내용 (0)	2013.04.30