夜里硬件升级过程中,启动instance时,在mount这一步报ORA-32700错误,对应的错误信息为:
Error: ORA-32700
Text: Error occurred in DIAG Group Service
-------------------------------------------------------------------------------
Cause: An unexpected error occurred while performing a DIAG Group Service
operation.
Action: Verify that the DIAG process is still active. Also, check the
Oracle DIAG trace files for errors.
检查diag进程日志:
*** SESSION ID:(2.1) 2006-02-17 03:52:51.421
kjzcprt:rcv port created
kjzmreg2: slos err[1 1 [HA_GS_NOT_OK] sskgxn_gs_in 1]
[kjzmreg2]: Error [category=1] is encountered
Node monitor problem:[32700][kjzmreg2]
Membership is lost in DIAG group
*** 2006-02-17 04:02:24.595
DIAG is exiting
可以大致判断该问题与操作系统HA有关,在检查系统错误日志发现:
A7250F53 0217035506 I O grpsvcs User is not allowed to use Group Service
A7250F53 0217035506 I O grpsvcs User is not allowed to use Group Service
LABEL: GS_AUTH_DENIED_ST
IDENTIFIER: A7250F53
Date/Time: Fri Feb 17 03:55:51 BEIS
Sequence Number: 26075
Machine Id: 003CF3AF4C00
Node Id: ltrz_db1
Class: O
Type: INFO
Resource Name: grpsvcs
Description
User is not allowed to use Group Services daemon
Probable Causes
The user is not the root user
The user is not a member of hagsuser group
Failure Causes
Group Services does not allow the user
Recommended Actions
Check whether the user is the root
Check whether the user is a member of hagsuser group
Detail Data
DETECTING MODULE
RSCT,SSuppConnSocket.C,1.27,708
ERROR ID
6HxE7b05XBx1/Dqw.0E4e.1...................
REFERENCE CODE
DIAGNOSTIC EXPLANATION
User oracle is not a supplementary user of group 103. Connection refused.
检查发现oracle用户果然不在hagsuser组里,不知是否跟之前的一次HA同步有关。将oracle用户重新加入到hagsuser组后,问题解决。同时,之前频繁出现的ORA-29702 error occurred in Cluster Group Service operation
的错误也没有再出现。
阅读(2859) | 评论(0) | 转发(0) |