签到成功

知道了

CNDBA社区CNDBA社区

Creation of ASM spfile in disk group failed. Following error occured: ORA-29783: GPnP attribute SET failed with error [CLSGPNP_NOT_FOUND]

2021-04-22 15:11 2501 0 原创 oracle
作者: Anshen

报错信息如下:
RS-2672: Attempting to start ‘ora.mdnsd’ on ‘drach1’
CRS-2676: Start of ‘ora.mdnsd’ on ‘drach1’ succeeded
CRS-2672: Attempting to start ‘ora.gpnpd’ on ‘drach1’
CRS-2676: Start of ‘ora.gpnpd’ on ‘drach1’ succeeded
CRS-2672: Attempting to start ‘ora.cssdmonitor’ on ‘drach1’
CRS-2672: Attempting to start ‘ora.gipcd’ on ‘drach1’
CRS-2676: Start of ‘ora.cssdmonitor’ on ‘drach1’ succeeded
CRS-2676: Start of ‘ora.gipcd’ on ‘drach1’ succeeded
CRS-2672: Attempting to start ‘ora.cssd’ on ‘drach1’
CRS-2672: Attempting to start ‘ora.diskmon’ on ‘drach1’
CRS-2676: Start of ‘ora.diskmon’ on ‘drach1’ succeeded
CRS-2676: Start of ‘ora.cssd’ on ‘drach1’ succeeded
Creation of ASM spfile in disk group failed. Following error occured: ORA-29783: GPnP attribute SET failed with error [CLSGPNP_NOT_FOUND
Configuration of ASM … failed
see asmca logs at /u01/app/grid/cfgtoollogs/asmca for details
Did not succssfully configure and start ASM at /u01/app/11.2.4/grid/crs/install/crsconfig_lib.pm line 6912.http://www.cndba.cn/redhat/article/4482http://www.cndba.cn/redhat/article/4482http://www.cndba.cn/redhat/article/4482

/u01/app/11.2.4/grid/perl/bin/perl -I/u01/app/11.2.4/grid/perl/lib -I/u01/app/11.2.4/grid/crs/install /u01/app/11.2.4/grid/crs/install/rootcrs.pl execution failed

查看asmca日志:
[main] [ 2021-04-22 22:06:55.907 CST ] [UsmcaLogger.logInfo:143] CREATE DISKGROUP SQL: CREATE DISKGROUP OCR NORMAL REDUNDANCY DISK ‘/dev/oracleasm/disks/asmdata1’,
‘/dev/oracleasm/disks/asmdata2’,
‘/dev/oracleasm/disks/asmdata3’ ATTRIBUTE ‘compatible.asm’=’11.2.0.0.0’,’au_size’=’1M’
[main] [ 2021-04-22 22:07:03.847 CST ] [UsmcaLogger.logInfo:143] Disk Group OCR created successfully.
[main] [ 2021-04-22 22:07:03.847 CST ] [UsmcaLogger.logExit:124] Exiting oracle.sysman.assistants.usmca.backend.USMDiskGroupManager Method : createDiskGroups
[main] [ 2021-04-22 22:07:03.847 CST ] [UsmcaLogger.logInfo:143] Diskgroups created
[main] [ 2021-04-22 22:07:03.847 CST ] [UsmcaLogger.logInfo:143] create spfile from pfile: /u01/app/11.2.4/grid/dbs/init+ASM1.ora
[main] [ 2021-04-22 22:07:03.848 CST ] [UsmcaLogger.logInfo:143] Final SPFile location +OCR
[main] [ 2021-04-22 22:07:03.848 CST ] [UsmcaLogger.logInfo:143] create spfile=’+OCR’ FROM pfile=’/u01/app/11.2.4/grid/dbs/init+ASM1.ora’
[main] [ 2021-04-22 22:07:03.848 CST ] [UsmcaLogger.logInfo:143] 1619100423848
[main] [ 2021-04-22 22:07:34.755 CST ] [SQLEngine.done:2189] Done called
[main] [ 2021-04-22 22:07:34.755 CST ] [UsmcaLogger.logException:173] SEVERE:method oracle.sysman.assistants.usmca.backend.USMInstance:configureLocalASM
[main] [ 2021-04-22 22:07:34.756 CST ] [UsmcaLogger.logException:174] ORA-29783: GPnP attribute SET failed with error [CLSGPNP_NOT_FOUND]http://www.cndba.cn/redhat/article/4482

[main] [ 2021-04-22 22:07:34.756 CST ] [UsmcaLogger.logException:175] oracle.sysman.assistants.util.sqlEngine.SQLFatalErrorException: ORA-29783: GPnP attribute SET failed with error [CLSGPNP_NOT_FOUND]http://www.cndba.cn/redhat/article/4482http://www.cndba.cn/redhat/article/4482

http://www.cndba.cn/redhat/article/4482

oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeImpl(SQLEngine.java:1658)
oracle.sysman.assistants.util.sqlEngine.SQLEngine.executeSql(SQLEngine.java:1925)
oracle.sysman.assistants.usmca.backend.USMInstance.createSPFileInDiskGroup(USMInstance.java:3552)
oracle.sysman.assistants.usmca.backend.USMInstance.configureLocalASM(USMInstance.java:3134)
oracle.sysman.assistants.usmca.service.UsmcaService.configureLocalASM(UsmcaService.java:1049)
oracle.sysman.assistants.usmca.model.UsmcaModel.performConfigureLocalASM(UsmcaModel.java:944)
oracle.sysman.assistants.usmca.model.UsmcaModel.performOperation(UsmcaModel.java:797)
oracle.sysman.assistants.usmca.Usmca.execute(Usmca.java:174)
oracle.sysman.assistants.usmca.Usmca.main(Usmca.java:369)
[main] [ 2021-04-22 22:07:34.756 CST ] [UsmcaLogger.logInfo:143] Creation of ASM spfile in disk group failed. Following error occured: ORA-29783: GPnP attribute SET failed with error [CLSGPNP_NOT_FOUND]http://www.cndba.cn/redhat/article/4482http://www.cndba.cn/redhat/article/4482

http://www.cndba.cn/redhat/article/4482

[main] [ 2021-04-22 22:07:34.760 CST ] [OsUtilsBase.deleteFile:1863] OsUtilsBase.deleteFile: /u01/app/11.2.4/grid/dbs/init+ASM1.ora
[main] [ 2021-04-22 22:07:34.760 CST ] [UsmcaLogger.logInfo:143] deleting temp ora file. for sid: /u01/app/11.2.4/grid/dbs/init+ASM1.ora
[main] [ 2021-04-22 22:07:34.760 CST ] [UsmcaLogger.logExit:124] Exiting oracle.sysman.assistants.usmca.backend.USMInstance Method : configureLocalASM
[main] [ 2021-04-22 22:07:34.760 CST ] [UsmcaLogger.logExit:124] Exiting oracle.sysman.assistants.usmca.model.UsmcaModel Method : performConfigureLocalASM

[main] [ 2021-04-22 22:07:34.760 CST ] [UsmcaLogger.logExit:124] Exiting oracle.sysman.assistants.usmca.model.UsmcaModel Method : performOperation

看到我们的ASM磁盘组是创建成功的,但是由于
ORA-29783: GPnP attribute SET failed with error [CLSGPNP_NOT_FOUND] 获取失败
然后:OsUtilsBase.deleteFile:
deleting temp ora file
解决方式:
关闭selinux
setenforce 0
编辑/etc/selinux/config 设置SELINUX=disabled
2.检查iptables
iptables -L
iptables -X
iptables -Z
iptables -F

版权声明:本文为博主原创文章,未经博主允许不得转载。

ORA-29783: GPnP attribute SET failed with error [CLSGPNP_NOT_FOUND]

用户评论
* 以下用户言论只代表其个人观点,不代表CNDBA社区的观点或立场
Anshen

Anshen

关注

成功不是将来才有的,而是从决定去做的那一刻起,持续累积而成。

  • 69
    原创
  • 0
    翻译
  • 5
    转载
  • 8
    评论
  • 访问:287107次
  • 积分:326
  • 等级:中级会员
  • 排名:第13名
精华文章
    最新问题
    查看更多+
    热门文章
      热门用户
      推荐用户
        Copyright © 2016 All Rights Reserved. Powered by CNDBA · 皖ICP备2022006297号-1·

        QQ交流群

        注册联系QQ