ITPub博客

首页 > 数据库 > Oracle > RAC 数据库 ORA-32700错误解决一例

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

原创 Oracle 作者:ddba 时间:2019-07-13 20:09:05 0 删除 编辑
修改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博客 ” ,链接:https://blog.itpub.net/7794469/viewspace-956501/ ,如需转载,请注明出处,否则将追究法律责任。

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

注册时间:2006-09-21

  • 博文量
    31
  • 访问量
    33960