ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ASM Instance Crashing with ORA-29702 [ID 445023.1]

ASM Instance Crashing with ORA-29702 [ID 445023.1]

原创 Linux操作系统 作者:spider0283 时间:2011-08-21 10:20:35 0 删除 编辑
修改时间 10-AUG-2011     类型 PROBLEM     状态 ARCHIVED  

In this Document
  Symptoms
  Cause
  Solution
  References


Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.4 - Release: 10.1 to 10.2
Information in this document applies to any platform.

Symptoms

In the ASM's alert.log file we see the following errors:

Errors in file /u01/app/oracle/admin/+ASM/bdump/+asm_gmon_14159.trc:
ORA-29702: error occurred in Cluster Group Service operation
ORA-29702: error occurred in Cluster Group Service operation
Wed Jun 27 07:17:41 2007
GMON: terminating instance due to error 29702

.

Cause

CSS actually missed checkins for itself and then evicted itself. This  kind of problem is often associated with heavy load on the machine and CSS not being able to get scheduled. CSSD daemon aborts due to lack of resources. BUG 6059429 has documented this might happen due to memory crunch.


CSSD LOG:
=========

CSSD]2007-06-28 01:22:52.452 [1166059840] >TRACE: clssnmLocalDeleteEvent: Removing local
node from cluster
[ CSSD]2007-06-28 01:22:52.452 [1166059840] >ERROR: ###################################
[ CSSD]2007-06-28 01:22:52.452 [1166059840] >ERROR: clssscExit: CSSD aborting
[ CSSD]2007-06-28 01:22:52.452 [1166059840] >ERROR: ###################################
[ CSSD]2007-06-28 01:22:52.445 [3359506736] >TRACE: clssgmStartNMMon: node 0 active,
birth 1
[ CSSD]2007-06-28 01:22:52.498 [3359506736] >USER: NMEVENT_SUSPEND [00][00][00][01]
[ CSSD]2007-06-28 01:22:52.498 [3359506736] >TRACE: clssgmUpdateEventValue: CmInfo State
val
5, changes 10
[ CSSD]2007-06-28 01:22:52.551 [3359506736] >TRACE: clssgmSuspendAllGrocks: Issue SUSPEND



Available Physical Memory 198 MB
Swap: Max Size 4102 MB
Swap: Available 3157 MB
Swap: In Use 944 MB




Solution

Increase the physical memory and SWAP accordingly as per following rules.

If RAM = 1024MB to 2048Mb
then 1.5 times RAM
elseif RAM > 2048MB and < 8192MB
then match RAM
else RAM > 8192MB
then .75 times RAM



OR

Move some databases/grid control (if on the same server) to another server.


References

BUG:6059429 - OCSSD DAEMON CRASHES, RESULTS IN ASM AND ASM DB CRASH

显示相关信息 相关的


产品
  • Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition
关键字
ASM; INSTANCE TERMINATED
错误
GMON; ORA-29702; ERROR 29702

返回页首返回页首

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/38267/viewspace-705476/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-03-29

  • 博文量
    194
  • 访问量
    719191