RAC 数据库 ORA-32700错误解决一例

修改hagsuser id后 数据库无法启动，报ORA-32700错：error occurred in DIAG Group Service。以下是解决过程。

[@more@]

OS：AIX 5300-05

DB：Oracle9206

HA：Hacmp 5.3.0.3

DR:oracle:/oracle>sqlplus "/as sysdba"

SQL*Plus: Release 9.2.0.6.0 - Production on Tue Aug 14 17:00:47 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 4365196552 bytes
Fixed Size 748808 bytes
Variable Size 2214592512 bytes
Database Buffers 2147483648 bytes
Redo Buffers 2371584 bytes
ORA-32700: error occurred in DIAG Group Service

ORA-32700 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.

*** SESSION ID:(2.1) 2007-08-14 17:00:53.908
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

IDENTIFIER TIMESTAMP T C RESOURCE_NAME DESCRIPTION
A7250F53 0814172807 I O grpsvcs User is not allowed to use Group Service
A7250F53 0814171607 I O grpsvcs User is not allowed to use Group Service
A7250F53 0814170007 I O grpsvcs User is not allowed to use Group Service

查看详细错误：
LABEL: GS_AUTH_DENIED_ST
IDENTIFIER: A7250F53

Date/Time: Tue Aug 14 17:28:09 2007
Sequence Number: 1760
Machine Id: 00CD9FCB4C00
Node Id: ISDB1_DR
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.28,668
ERROR ID
6HxE7b0dKLk4/qf8.bnUP8....................
REFERENCE CODE

DIAGNOSTIC EXPLANATION
No info for group 502 found. Connection refused.
---------------------------------------------------------------------------
LABEL: GS_AUTH_DENIED_ST
IDENTIFIER: A7250F53

Date/Time: Tue Aug 14 17:16:26 2007
Sequence Number: 1759
Machine Id: 00CD9FCB4C00
Node Id: ISDB1_DR
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.28,668
ERROR ID
6HxE7b0e9Lk4/9sy/bnUP8....................
REFERENCE CODE

DIAGNOSTIC EXPLANATION
No info for group 502 found. Connection refused.

之前的hagsuser的group id就是502，现在改成了501。

可以看出由于hagsuser的group id发生了改变，此时hacmp已经找不到原先的502的group了，所以报错，导致oracle无法启动。

这样的话可以对hacmp进行重启，让其知道新的hagsuser group id即可。

重启ha后数据库能够正常启动。

呵呵 可以看出os的知识还是很重要的，努力学习ing～

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

转载于:http://blog.itpub.net/7794469/viewspace-956501/