本站文章除注明转载外，均为本站原创： 转载自love wife & love life —Roger 的Oracle技术博客
本文链接地址: ocssd.log:clssgmpcBuildNodeList: nodename for node x is NULL
之前2个客户的环境中，我们按照了11.2.0.4.6这个最新PSU，都发现ocssd.log的信息比较异常。总的来讲，没有什么影响，但是由于日志输出非常快，每5秒一次，这导致ocssd.log的其他信息可能都被这些无关紧要的信息给淹没了，不便于日后的问题分析。我们发现，目前在Solaris Sparc，Linux都存在这个问题。大家可以看到ocssd.log的信息更新时间都很短，如下：
oracle@xxxxdb1:/u01/app/11.2.0/grid/log/xxxxdb1/cssd $ls -ltr total 1100608 -rw-rw-r-- 1 grid oinstall 222656 Jun 7 00:38 cssdOUT.log -rw-r--r-- 1 grid oinstall 52496701 Jun 11 06:15 ocssd.l10 -rw-r--r-- 1 grid oinstall 52501775 Jun 11 09:19 ocssd.l09 -rw-r--r-- 1 grid oinstall 52503902 Jun 11 12:20 ocssd.l08 -rw-r--r-- 1 grid oinstall 52505495 Jun 11 15:21 ocssd.l07 -rw-r--r-- 1 grid oinstall 52503384 Jun 11 18:22 ocssd.l06 -rw-r--r-- 1 grid oinstall 52501464 Jun 11 21:24 ocssd.l05 -rw-r--r-- 1 grid oinstall 52500024 Jun 12 00:28 ocssd.l04 -rw-r--r-- 1 grid oinstall 52497327 Jun 12 03:35 ocssd.l03 -rw-r--r-- 1 grid oinstall 52497206 Jun 12 06:42 ocssd.l02 -rw-r--r-- 1 grid oinstall 52501370 Jun 12 09:45 ocssd.l01 -rw-r--r-- 1 grid oinstall 37051612 Jun 12 11:53 ocssd.log
如下是ocssd.log的信息输出：
oracle@xxxxdb1:/u01/app/11.2.0/grid/log/xxxxdb1/cssd $more ocssd.log Oracle Database 11g Clusterware Release 11.2.0.4.0 - Production Copyright 1996, 2011 Oracle. All rights reserved. 2015-06-12 09:45:13.898: [ CSSD][5]clssgmpcBuildNodeList: nodename for node 177 is NULL 2015-06-12 09:45:13.898: [ CSSD][5]clssgmpcBuildNodeList: nodename for node 178 is NULL 2015-06-12 09:45:13.898: [ CSSD][5]clssgmpcBuildNodeList: nodename for node 179 is NULL ...... ...... 2015-06-12 09:45:13.898: [ CSSD][5]clssgmpcBuildNodeList: nodename for node 250 is NULL 2015-06-12 09:45:13.898: [ CSSD][5]clssgmpcBuildNodeList: nodename for node 251 is NULL 2015-06-12 09:45:13.898: [ CSSD][5]clssgmpcBuildNodeList: nodename for node 252 is NULL 2015-06-12 09:45:13.898: [ CSSD][5]clssgmpcBuildNodeList: nodename for node 253 is NULL 2015-06-12 09:45:13.898: [ CSSD][5]clssgmpcBuildNodeList: nodename for node 254 is NULL 2015-06-12 09:45:13.898: [ CSSD][5]clssgmpcBuildNodeList: nodename for node 255 is NULL 2015-06-12 09:45:15.391: [ CSSD][45]clssnmSendingThread: sending status msg to all nodes 2015-06-12 09:45:15.392: [ CSSD][45]clssnmSendingThread: sent 4 status msgs to all nodes 2015-06-12 09:45:18.900: [ CSSD][5]clssgmpcBuildNodeList: nodename for node 0 is NULL 2015-06-12 09:45:18.901: [ CSSD][5]clssgmpcBuildNodeList: nodename for node 3 is NULL 2015-06-12 09:45:18.901: [ CSSD][5]clssgmpcBuildNodeList: nodename for node 4 is NULL 2015-06-12 09:45:18.901: [ CSSD][5]clssgmpcBuildNodeList: nodename for node 5 is NULL 2015-06-12 09:45:18.901: [ CSSD][5]clssgmpcBuildNodeList: nodename for node 6 is NULL 2015-06-12 09:45:18.901: [ CSSD][5]clssgmpcBuildNodeList: nodename for node 7 is NULL 2015-06-12 09:45:18.901: [ CSSD][5]clssgmpcBuildNodeList: nodename for node 8 is NULL 2015-06-12 09:45:18.901: [ CSSD][5]clssgmpcBuildNodeList: nodename for node 9 is NULL 2015-06-12 09:45:18.901: [ CSSD][5]clssgmpcBuildNodeList: nodename for node 10 is NULL 2015-06-12 09:45:18.901: [ CSSD][5]clssgmpcBuildNodeList: nodename for node 11 is NULL 2015-06-12 09:45:18.901: [ CSSD][5]clssgmpcBuildNodeList: nodename for node 12 is NULL ..... ..... 2015-06-12 09:45:18.901: [ CSSD][5]clssgmpcBuildNodeList: nodename for node 249 is NULL 2015-06-12 09:45:18.901: [ CSSD][5]clssgmpcBuildNodeList: nodename for node 250 is NULL 2015-06-12 09:45:18.901: [ CSSD][5]clssgmpcBuildNodeList: nodename for node 251 is NULL 2015-06-12 09:45:18.901: [ CSSD][5]clssgmpcBuildNodeList: nodename for node 252 is NULL 2015-06-12 09:45:18.901: [ CSSD][5]clssgmpcBuildNodeList: nodename for node 253 is NULL 2015-06-12 09:45:18.901: [ CSSD][5]clssgmpcBuildNodeList: nodename for node 254 is NULL 2015-06-12 09:45:18.901: [ CSSD][5]clssgmpcBuildNodeList: nodename for node 255 is NULL
Oracle的解释是如果你的环境是从pre-11.2版本升级上来的，那么这里看到的node numer则是从0开始，否则不是。
不过据我检查一个客户的环境，完全是一个我们新按照的11.2.0.4.6的环境，ocssd.log信息也给上面几乎一致。
总的来讲，这个问题影响不大，甚至可以直接忽略之。Oracle的解释是说在解决bug 17046460的时候引入了这个问题。将该问题确认为一个新的bug:Bug# 21171934 – REPEATED MESSAGES “CLSSGMPCBUILDNODELIST: NODENAME FOR NODE XX IS NULL” IN OCSSD
比较遗憾的是，目前Oracle 还并没有出出相关的patch，我相信在7月份的psu中应该会fixed.
Related posts:
