내맘대로긍정이 알려주는
Oracle 23ai 신기능
무료 세미나 발표자료
다운로드
trending_flat
OS환경 : Oracle Linux 6.8 (64bit)
DB 환경 : Oracle Database 11.2.0.4, 12.2.0.2
에러 : ocssd.log에 clssgmpcBuildNodeList: nodename for node 0 is NULL 발생
1번노드 최근 cssd log 확인
|
1
2
3
4
5
6
7
8
9
|
$ cd $GRID_HOME/log/rac1/cssd
$ vi ocssd.log
2018-07-31 10:32:10.270: [ CSSD][4213798656]clssgmpcBuildNodeList: nodename for node 0 is NULL
2018-07-31 10:32:11.268: [ CSSD][4181890816]clssnmSendingThread: sending status msg to all nodes
2018-07-31 10:32:11.268: [ CSSD][4181890816]clssnmSendingThread: sent 5 status msgs to all nodes
2018-07-31 10:32:15.271: [ CSSD][4213798656]clssgmpcBuildNodeList: nodename for node 0 is NULL
2018-07-31 10:32:16.269: [ CSSD][4181890816]clssnmSendingThread: sending status msg to all nodes
2018-07-31 10:32:16.270: [ CSSD][4181890816]clssnmSendingThread: sent 5 status msgs to all nodes
2018-07-31 10:32:20.273: [ CSSD][4213798656]clssgmpcBuildNodeList: nodename for node 0 is NULL
|
crsctl 상태 확인
|
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
|
$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.FRA.dg
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.LISTENER.lsnr
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.OCR_VOTE.dg
ONLINE OFFLINE rac1
ONLINE ONLINE rac2
ora.asm
ONLINE ONLINE rac1 Started
ONLINE ONLINE rac2 Started
ora.gsd
OFFLINE OFFLINE rac1
OFFLINE OFFLINE rac2
ora.net1.network
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.ons
ONLINE ONLINE rac1
ONLINE ONLINE rac2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac2
ora.cvu
1 ONLINE ONLINE rac2
ora.oc4j
1 ONLINE ONLINE rac2
ora.orac.db
1 ONLINE ONLINE rac1 Open
2 ONLINE ONLINE rac2 Open
ora.rac1.vip
1 ONLINE ONLINE rac1
ora.rac2.vip
1 ONLINE ONLINE rac2
ora.scan1.vip
1 ONLINE ONLINE rac2
|
=> 정상
=> ocssd 로그에만 저런 내용이 나오는듯 함
해결 방법 : 17374271 임시패치 적용또는 11.2.0.4.8 PSU 적용 또는 12c로 업그레이드
clssgmpcBuildNodeList: nodename for node 0 is NULL 에대한 패치
아래 방법은 임시패치를 적용함
메타링크에서 패치 17374271: "CRSCTL GET NODE ROLE STATUS -ALL" IS NOT RETURNING INFORMATION ON LEAF NODES 를 다운로드
/home/oracle/patch 에 패치파일 넣기
1번노드 db 종료
|
1
2
3
4
|
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
|
패치파일 unzip
|
1
|
$ unzip p17374271_112040_Linux-x86-64.zip
|
패치파일 적용
grid 권한있는 계정으로 접속
|
1
2
3
|
# export PATH=$PATH:/oracle/app/11.2.0/grid/OPatch
# cd /home/oracle/patch/
$ opatch apply 17374271/
|
1번노드 db 기동
|
1
|
SQL> startup
|
2번노드 db 종료
|
1
2
3
4
|
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
|
패치파일 unzip
|
1
|
$ unzip p17374271_112040_Linux-x86-64.zip
|
패치파일 적용
grid 권한있는 계정으로 접속
|
1
2
3
|
# export PATH=$PATH:/oracle/app/11.2.0/grid/OPatch
# cd /home/oracle/patch/
$ opatch apply 17374271/
|
2번노드 db 기동
|
1
|
SQL> startup
|
원인 : oracle 버그
11gR2에서 발생하는 clssgmpcBuildNodeList: nodename for node 0 is NULL 메세지는 oracle 버그임
|
1
|
2018-07-31 10:32:10.270: [ CSSD][4213798656]clssgmpcBuildNodeList: nodename for node 0 is NULL
|
sending status msg to all nodes 는 grid 의 정상적인 동작임
|
1
2
|
2018-07-31 10:32:11.268: [ CSSD][4181890816]clssnmSendingThread: sending status msg to all nodes
2018-07-31 10:32:11.268: [ CSSD][4181890816]clssnmSendingThread: sent 5 status msgs to all nodes
|
참조 : 2023159.1, 2535941.1