检查ocssd.log发现以下问题

最新推荐文章于 2021-04-06 07:26:03 发布

congqianpin9096

最新推荐文章于 2021-04-06 07:26:03 发布

阅读量226

点赞数

文章标签：数据库

在一个两个节点的RAC环境中，进行日常维护，在ocssd.log中发现

rac1:
22:36:42.284 [151810688] >TRACE: clssnmPollingThread: node rac1 (1) missed(2) checkin(s)
rac2:
23:07:48.833 [151810688] >TRACE: clssnmPollingThread: node rac1 (1) missed(2) checkin(s)

Oracle版本如下：

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Release 10.2.0.1.0 - Production
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

google了一下，得到如下结果

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.2
This problem can occur on any platform.
SymptomsThe ocssd.log contains irregular messages about missed checkins from the remote nodes(s) or the local node. The missed checkins are not increasing.

Extract from ocssd.log:

14:10:25.138 [10] >TRACE: clssgmClientConnectMsg: Connect from con(100aca070) proc(100acd0f0) pid() proto(10:2:1:1)

14:11:24.288 [14] >TRACE: clssnmPollingThread: node myrac2 (2) missed(2) checkin(s)

14:11:25.547 [10] >TRACE: clssgmClientConnectMsg: Connect from con(100aca070) proc(100ae74e0) pid() proto(10:2:1:1)

14:11:50.468 [14] >TRACE: clssnmPollingThread: node myrac1 (1) missed(2) checkin(s)

14:12:25.960 [10] >TRACE: clssgmClientConnectMsg: Connect from con(100acd800) proc(100acd0f0) pid() proto(10:2:1:1)

Changes Install/upgrade to 10.2.
CauseThe missed checkins are printed for diagnostic purpose only.
SolutionThe harmless messages can be ignored. It has been removed with the patch for bug 5037871, which will be included in 10.2.0.3.

metalink:

Subject:	Irregular ClssnmPollingThread Missed Checkins Messages in CSSD log
	Doc ID:	372463.1	Type:	PROBLEM
	Modified Date:	06-JUN-2006	Status:	MODERATED

In this Document
  Symptoms
  Changes
  Cause
  Solution
  References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.2
This problem can occur on any platform.

Symptoms

The ocssd.log contains irregular messages about missed checkins from the remote nodes(s) or the local node. The missed checkins are not increasing.

Extract from ocssd.log:

[ CSSD]2006-06-01 14:10:25.138 [10] >TRACE: clssgmClientConnectMsg: Connect from con(100aca070) proc(100acd0f0) pid() proto(10:2:1:1)
[ CSSD]2006-06-01 14:11:24.288 [14] >TRACE: clssnmPollingThread: node myrac2 (2) missed(2) checkin(s)
[ CSSD]2006-06-01 14:11:25.547 [10] >TRACE: clssgmClientConnectMsg: Connect from con(100aca070) proc(100ae74e0) pid() proto(10:2:1:1)
[ CSSD]2006-06-01 14:11:50.468 [14] >TRACE: clssnmPollingThread: node myrac1 (1) missed(2) checkin(s)
[ CSSD]2006-06-01 14:12:25.960 [10] >TRACE: clssgmClientConnectMsg: Connect from con(100acd800) proc(100acd0f0) pid() proto(10:2:1:1)