복사되었습니다!
EXADATA Image : 22.1.33.0.0.250304
OS 환경 : Oracle Linux 7.9 (64bit)
DB 환경 : Oracle Database 19.31.0.0
방법 : 오라클 Exadata cellcli, dcli alerthistory 확인 명령
본문에서는 exadata에서 셀노드의 alerthistory를 확인하는 명령을 설명함
셀 서버에서 직접 확인
|
1
|
# cellcli -e list alerthistory
|
db 서버에서 dcli로 원격 확인
|
1
|
# dcli -g cell_group -l root "cellcli -e list alerthistory"
|
최근 24시간 동안 발생한 Critical 알람 조회
|
1
|
# dcli -g cell_group -l root "cellcli -e \"list alerthistory where ageInMinutes < 1440 and severity='critical' detail\""
|
특정일자 이후 발생한 alerthistory 조회(날짜 조건)
|
1
|
# dcli -g cell_group -l root "cellcli -e \"list alerthistory where begintime > '2026-06-08T00:00:00+09:00'\""
|
최근 한 달(30일)치 alerthistory 조회
|
1
|
# dcli -g cell_group -l root "cellcli -e 'list alerthistory where ageInMinutes < 43200 detail'"
|
최근 한 달(30일) 동안 발생한 Critical 알람 조회
|
1
|
# dcli -g cell_group -l root "cellcli -e \"list alerthistory where ageInMinutes < 43200 and severity='critical' detail\""
|
특정 하드웨어(예: disk) 관련 알람만 조회
|
1
|
# dcli -g cell_group -l root "cellcli -e \"list alerthistory where alertDescription like '(?i).*disk.*' detail\""
|
명령어 설명 :
(?i) : 대소문자 구분 없이 검색
모든 종류의 물리 디스크(HardDisk, FlashDisk 등) 한 번에 확인
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
|
# dcli -g cell_group -l root "cellcli -e list physicaldisk"
exa7celadm01: 252:0 RAMKKD normal
exa7celadm01: 252:1 RD59VV normal
exa7celadm01: 252:2 RASJMN normal
exa7celadm01: 252:3 RAADDN normal
exa7celadm01: 252:4 RB132N normal
exa7celadm01: 252:5 RW2SED normal
exa7celadm01: FLASH_10_1 PHLE8120006G6P4BGN-1 normal
exa7celadm01: FLASH_10_2 PHLE8120006G6P4BGN-2 normal
exa7celadm01: FLASH_5_1 PHLE812000836P4BGN-1 normal
exa7celadm01: FLASH_5_2 PHLE812000836P4BGN-2 normal
exa7celadm01: M2_SYS_0 PHDW818102CC150A normal
exa7celadm01: M2_SYS_1 PHDW818102FG150A normal
exa7celadm02: 252:0 RUXAUN normal
exa7celadm02: 252:1 RAWWTN normal
exa7celadm02: 252:2 RDE7DV normal
exa7celadm02: 252:3 RAVB9N normal
exa7celadm02: 252:4 RAU90N normal
exa7celadm02: 252:5 R9X4VN normal
exa7celadm02: FLASH_10_1 PHLE8110019K6P4BGN-1 normal
exa7celadm02: FLASH_10_2 PHLE8110019K6P4BGN-2 normal
exa7celadm02: FLASH_5_1 PHLE814100836P4BGN-1 normal
exa7celadm02: FLASH_5_2 PHLE814100836P4BGN-2 normal
exa7celadm02: M2_SYS_0 PHDW818101M8150A normal
exa7celadm02: M2_SYS_1 PHDW818101C8150A normal
exa7celadm03: 252:0 RARDEN normal
exa7celadm03: 252:1 R1AKRK normal
exa7celadm03: 252:2 RASA1N normal
exa7celadm03: 252:3 RAPP1N normal
exa7celadm03: 252:4 RAV0MN normal
exa7celadm03: 252:5 RB1LTN normal
exa7celadm03: FLASH_10_1 PHLE816500GT6P4BGN-1 normal
exa7celadm03: FLASH_10_2 PHLE816500GT6P4BGN-2 normal
exa7celadm03: FLASH_5_1 PHLE816500EQ6P4BGN-1 normal
exa7celadm03: FLASH_5_2 PHLE816500EQ6P4BGN-2 normal
exa7celadm03: M2_SYS_0 PHDW818004XT150A normal
exa7celadm03: M2_SYS_1 PHDW818004VC150A normal
|
HardDisk만 확인
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
# dcli -g cell_group -l root "cellcli -e list physicaldisk where diskType='HardDisk'"
exa7celadm01: 252:0 RAMKKD normal
exa7celadm01: 252:1 RD59VV normal
exa7celadm01: 252:2 RASJMN normal
exa7celadm01: 252:3 RAADDN normal
exa7celadm01: 252:4 RB132N normal
exa7celadm01: 252:5 RW2SED normal
exa7celadm02: 252:0 RUXAUN normal
exa7celadm02: 252:1 RAWWTN normal
exa7celadm02: 252:2 RDE7DV normal
exa7celadm02: 252:3 RAVB9N normal
exa7celadm02: 252:4 RAU90N normal
exa7celadm02: 252:5 R9X4VN normal
exa7celadm03: 252:0 RARDEN normal
exa7celadm03: 252:1 R1AKRK normal
exa7celadm03: 252:2 RASA1N normal
exa7celadm03: 252:3 RAPP1N normal
exa7celadm03: 252:4 RAV0MN normal
exa7celadm03: 252:5 RB1LTN normal
|
Griddisk만 확인
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
|
# dcli -g cell_group -l root "cellcli -e list griddisk"
exa7celadm01: DATADG_CD_00_exa7celadm01 active
exa7celadm01: DATADG_CD_01_exa7celadm01 active
exa7celadm01: DATADG_CD_02_exa7celadm01 active
exa7celadm01: DATADG_CD_03_exa7celadm01 active
exa7celadm01: DATADG_CD_04_exa7celadm01 active
exa7celadm01: DATADG_CD_05_exa7celadm01 active
exa7celadm01: RECODG_CD_00_exa7celadm01 active
exa7celadm01: RECODG_CD_01_exa7celadm01 active
exa7celadm01: RECODG_CD_02_exa7celadm01 active
exa7celadm01: RECODG_CD_03_exa7celadm01 active
exa7celadm01: RECODG_CD_04_exa7celadm01 active
exa7celadm01: RECODG_CD_05_exa7celadm01 active
exa7celadm02: DATADG_CD_00_exa7celadm02 active
exa7celadm02: DATADG_CD_01_exa7celadm02 active
exa7celadm02: DATADG_CD_02_exa7celadm02 active
exa7celadm02: DATADG_CD_03_exa7celadm02 active
exa7celadm02: DATADG_CD_04_exa7celadm02 active
exa7celadm02: DATADG_CD_05_exa7celadm02 active
exa7celadm02: RECODG_CD_00_exa7celadm02 active
exa7celadm02: RECODG_CD_01_exa7celadm02 active
exa7celadm02: RECODG_CD_02_exa7celadm02 active
exa7celadm02: RECODG_CD_03_exa7celadm02 active
exa7celadm02: RECODG_CD_04_exa7celadm02 active
exa7celadm02: RECODG_CD_05_exa7celadm02 active
exa7celadm03: DATADG_CD_00_exa7celadm03 active
exa7celadm03: DATADG_CD_01_exa7celadm03 active
exa7celadm03: DATADG_CD_02_exa7celadm03 active
exa7celadm03: DATADG_CD_03_exa7celadm03 active
exa7celadm03: DATADG_CD_04_exa7celadm03 active
exa7celadm03: DATADG_CD_05_exa7celadm03 active
exa7celadm03: RECODG_CD_00_exa7celadm03 active
exa7celadm03: RECODG_CD_01_exa7celadm03 active
exa7celadm03: RECODG_CD_02_exa7celadm03 active
exa7celadm03: RECODG_CD_03_exa7celadm03 active
exa7celadm03: RECODG_CD_04_exa7celadm03 active
exa7celadm03: RECODG_CD_05_exa7celadm03 active
|
Celldisk만 확인
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
|
# dcli -g cell_group -l root "cellcli -e list celldisk"
exa7celadm01: CD_00_exa7celadm01 normal
exa7celadm01: CD_01_exa7celadm01 normal
exa7celadm01: CD_02_exa7celadm01 normal
exa7celadm01: CD_03_exa7celadm01 normal
exa7celadm01: CD_04_exa7celadm01 normal
exa7celadm01: CD_05_exa7celadm01 normal
exa7celadm01: FD_00_exa7celadm01 normal
exa7celadm01: FD_01_exa7celadm01 normal
exa7celadm02: CD_00_exa7celadm02 normal
exa7celadm02: CD_01_exa7celadm02 normal
exa7celadm02: CD_02_exa7celadm02 normal
exa7celadm02: CD_03_exa7celadm02 normal
exa7celadm02: CD_04_exa7celadm02 normal
exa7celadm02: CD_05_exa7celadm02 normal
exa7celadm02: FD_00_exa7celadm02 normal
exa7celadm02: FD_01_exa7celadm02 normal
exa7celadm03: CD_00_exa7celadm03 normal
exa7celadm03: CD_01_exa7celadm03 normal
exa7celadm03: CD_02_exa7celadm03 normal
exa7celadm03: CD_03_exa7celadm03 normal
exa7celadm03: CD_04_exa7celadm03 normal
exa7celadm03: CD_05_exa7celadm03 normal
exa7celadm03: FD_00_exa7celadm03 normal
exa7celadm03: FD_01_exa7celadm03 normal
|
디스크 상태가 Normal이 아닌 HardDisk 찾기
|
1
|
# dcli -g cell_group -l root "cellcli -e list physicaldisk where diskType='HardDisk' and status!='normal'"
|
디스크 상태가 Active가 아닌 Griddisk 찾기
|
1
|
# dcli -g cell_group -l root "cellcli -e list griddisk where status!='active'"
|
디스크 상태가 Normal이 아닌 Celldisk 찾기
|
1
|
# dcli -g cell_group -l root "cellcli -e list celldisk where status!='normal'"
|
물리 디스크 별 이름, 디스크 타입, 상태 확인
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
|
# dcli -g cell_group -l root "cellcli -e list physicaldisk attributes name, diskType, status"
exa7celadm01: 252:0 HardDisk normal
exa7celadm01: 252:1 HardDisk normal
exa7celadm01: 252:2 HardDisk normal
exa7celadm01: 252:3 HardDisk normal
exa7celadm01: 252:4 HardDisk normal
exa7celadm01: 252:5 HardDisk normal
exa7celadm01: FLASH_10_1 FlashDisk normal
exa7celadm01: FLASH_10_2 FlashDisk normal
exa7celadm01: FLASH_5_1 FlashDisk normal
exa7celadm01: FLASH_5_2 FlashDisk normal
exa7celadm01: M2_SYS_0 M2Disk normal
exa7celadm01: M2_SYS_1 M2Disk normal
exa7celadm02: 252:0 HardDisk normal
exa7celadm02: 252:1 HardDisk normal
exa7celadm02: 252:2 HardDisk normal
exa7celadm02: 252:3 HardDisk normal
exa7celadm02: 252:4 HardDisk normal
exa7celadm02: 252:5 HardDisk normal
exa7celadm02: FLASH_10_1 FlashDisk normal
exa7celadm02: FLASH_10_2 FlashDisk normal
exa7celadm02: FLASH_5_1 FlashDisk normal
exa7celadm02: FLASH_5_2 FlashDisk normal
exa7celadm02: M2_SYS_0 M2Disk normal
exa7celadm02: M2_SYS_1 M2Disk normal
exa7celadm03: 252:0 HardDisk normal
exa7celadm03: 252:1 HardDisk normal
exa7celadm03: 252:2 HardDisk normal
exa7celadm03: 252:3 HardDisk normal
exa7celadm03: 252:4 HardDisk normal
exa7celadm03: 252:5 HardDisk normal
exa7celadm03: FLASH_10_1 FlashDisk normal
exa7celadm03: FLASH_10_2 FlashDisk normal
exa7celadm03: FLASH_5_1 FlashDisk normal
exa7celadm03: FLASH_5_2 FlashDisk normal
exa7celadm03: M2_SYS_0 M2Disk normal
exa7celadm03: M2_SYS_1 M2Disk normal
|
cellcli에서 attributes를 사용하면 sql에서 select 절에 컬럼을 나열하는것 처럼 확인 가능함
그리고 where 절을 사용해서 조건도 지정할 수 있음
physicaldisk 중에서 diskType이 flashdisk인 디스크의 name, diskType, status 확인
|
1
2
3
4
5
6
7
8
9
10
11
12
13
|
# dcli -g cell_group -l root "cellcli -e list physicaldisk attributes name, diskType, status where diskType = 'flashdisk'"
exa7celadm01: FLASH_10_1 FlashDisk normal
exa7celadm01: FLASH_10_2 FlashDisk normal
exa7celadm01: FLASH_5_1 FlashDisk normal
exa7celadm01: FLASH_5_2 FlashDisk normal
exa7celadm02: FLASH_10_1 FlashDisk normal
exa7celadm02: FLASH_10_2 FlashDisk normal
exa7celadm02: FLASH_5_1 FlashDisk normal
exa7celadm02: FLASH_5_2 FlashDisk normal
exa7celadm03: FLASH_10_1 FlashDisk normal
exa7celadm03: FLASH_10_2 FlashDisk normal
exa7celadm03: FLASH_5_1 FlashDisk normal
exa7celadm03: FLASH_5_2 FlashDisk normal
|
physicaldisk 중에서 diskType이 flash라는 단어가 들어간 디스크의 name, diskType, status 확인
|
1
2
3
4
5
6
7
8
9
10
11
12
13
|
# dcli -g cell_group -l root "cellcli -e \"list physicaldisk attributes name, diskType, status where diskType like '(?i).*flash.*'\""
exa7celadm01: FLASH_10_1 FlashDisk normal
exa7celadm01: FLASH_10_2 FlashDisk normal
exa7celadm01: FLASH_5_1 FlashDisk normal
exa7celadm01: FLASH_5_2 FlashDisk normal
exa7celadm02: FLASH_10_1 FlashDisk normal
exa7celadm02: FLASH_10_2 FlashDisk normal
exa7celadm02: FLASH_5_1 FlashDisk normal
exa7celadm02: FLASH_5_2 FlashDisk normal
exa7celadm03: FLASH_10_1 FlashDisk normal
exa7celadm03: FLASH_10_2 FlashDisk normal
exa7celadm03: FLASH_5_1 FlashDisk normal
exa7celadm03: FLASH_5_2 FlashDisk normal
|
like를 사용하려면 list 절을 ""로 묶어 줘야함
명령어 설명 :
(?i) : 대소문자 구분 없이 검색
참고1. dcli help
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
|
# dcli -h
Distributed Shell for Oracle Storage
This script executes commands on multiple cells in parallel threads.
The cells are referenced by their domain name or ip address.
Local files can be copied to cells and executed on cells.
This tool does not support interactive sessions with host applications.
Use of this tool assumes ssh is running on local host and cells.
The -k option should be used initially to perform key exchange with
cells. User may be prompted to acknowledge cell authenticity, and
may be prompted for the remote user password. This -k step is serialized
to prevent overlayed prompts. After -k option is used once, then
subsequent commands to the same cells do not require -k and will not require
passwords for that user from the host.
Command output (stdout and stderr) is collected and displayed after the
copy and command execution has finished on all cells.
Options allow this command output to be abbreviated.
Return values:
0 -- file or command was copied and executed successfully on all cells
1 -- one or more cells could not be reached or remote execution
returned non-zero status.
2 -- An error prevented any command execution
Examples:
dcli -g mycells -k
dcli -c stsd2s2,stsd2s3 vmstat
dcli -g mycells cellcli -e alter iormplan active
dcli -g mycells -x reConfig.scl
Usage: dcli [options] [command]
Options:
--version show program's version number and exit
--batchsize=MAXTHDS limit the number of target cells on which to run the
command or file copy in parallel
-c CELLS comma-separated list of cells
--ctimeout=CTIMEOUT Maximum time in seconds for initial cell connect
-d DESTFILE destination directory or file
-f FILE files to be copied
-g GROUPFILE file containing list of cells
-h, --help show help message and exit
--hidestderr hide stderr for remotely executed commands in ssh
-k push ssh key to cell's authorized_keys file
--key-with-one-password
apply one credential for pushing ssh key to
authorized_keys files
-l USERID user to login as on remote cells (default: celladmin)
--root-exadatatmp root user login using directory /var/log/exadatatmp/
--maxlines=MAXLINES limit output lines from a cell when in parallel
execution over multiple cells (default: 100000)
-n abbreviate non-error output
-r REGEXP abbreviate output lines matching a regular expression
-s SSHOPTIONS string of options passed through to ssh
--scp=SCPOPTIONS string of options passed through to scp if different
from sshoptions
--serial serialize execution over the cells
--showbanner show banner of the remote node in ssh
-t list target cells
--unkey drop keys from target cells' authorized_keys file
-v print extra messages to stdout
--vmstat=VMSTATOPS vmstat command options
-x EXECFILE file to be copied and executed
|
참고2. cellcli help
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
|
# cellcli -e help
HELP [topic]
Available Topics:
ALTER
ALTER ALERTHISTORY
ALTER CELL
ALTER CELLDISK
ALTER FLASHCACHE
ALTER GRIDDISK
ALTER IBPORT
ALTER IORMPLAN
ALTER LUN
ALTER METRICDEFINITION
ALTER OFFLOADGROUP
ALTER PHYSICALDISK
ALTER PMEMCACHE
ALTER QUARANTINE
ALTER SOFTWAREUPDATE
ALTER THRESHOLD
ALTER USER
ASSIGN KEY
CALIBRATE
CREATE
CREATE CELL
CREATE CELLDISK
CREATE DIAGPACK
CREATE FLASHCACHE
CREATE FLASHLOG
CREATE GRIDDISK
CREATE KEY
CREATE PMEMCACHE
CREATE PMEMLOG
CREATE QUARANTINE
CREATE ROLE
CREATE THRESHOLD
CREATE USER
DESCRIBE
DROP
DROP ALERTHISTORY
DROP CELL
DROP CELLDISK
DROP FLASHCACHE
DROP FLASHLOG
DROP GRIDDISK
DROP PMEMCACHE
DROP PMEMLOG
DROP QUARANTINE
DROP ROLE
DROP SOFTWAREHISTORY
DROP THRESHOLD
DROP USER
EXPORT CELLDISK
GRANT
GRANT PRIVILEGE
GRANT ROLE
IMPORT CELLDISK
LIST
LIST ACTIVEREQUEST
LIST ALERTDEFINITION
LIST ALERTHISTORY
LIST CELL
LIST CELLDISK
LIST DATABASE
LIST DIAGPACK
LIST FLASHCACHE
LIST FLASHCACHECONTENT
LIST FLASHLOG
LIST GRIDDISK
LIST IBPORT
LIST IORMPLAN
LIST IORMPROFILE
LIST KEY
LIST LUN
LIST METRICCURRENT
LIST METRICDEFINITION
LIST METRICHISTORY
LIST METRICSTREAM
LIST OFFLOADGROUP
LIST PHYSICALDISK
LIST PLUGGABLEDATABASE
LIST PMEMCACHE
LIST PMEMLOG
LIST QUARANTINE
LIST ROLE
LIST SOFTWAREHISTORY
LIST SOFTWAREUPDATE
LIST THRESHOLD
LIST USER
REVOKE
REVOKE PRIVILEGE
REVOKE ROLE
SET
SPOOL
START
|
참고3. cellcli list alerthistory help
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
# cellcli -e help list alerthistory
Usage: LIST ALERTHISTORY [<name> | <filters>] [<attribute_list>] [DETAIL]
Purpose: Displays specified attributes for alerts.
Arguments:
<name>: The id of the alert to be displayed.
<filters>: an expression which determines which alerts should
be displayed.
<attribute_list>: The attributes that are to be displayed.
ATTRIBUTES {ALL | attr1 [, attr2]... }
Options:
[DETAIL]: Formats the display as an attribute on each line, with
an attribute descriptor preceding each value.
Examples:
LIST ALERTHISTORY DETAIL
|
결론 :
cellcli 명령으로 exadata cell node에서 발생한 에러들을 간편하게 확인할 수 있음
참조 :
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/sagug/overview-dcli-utility.html
https://docs.oracle.com/en/engineered-systems/exadata-database-machine/sagug/attribute-filters-list-and-alter-commands.html
'ORACLE > Exadata' 카테고리의 다른 글
| 오라클 Exadata dcli ssh password-less(패스워드 없는 SSH 통신) 설정 (0) | 2026.06.30 |
|---|