Creation of ASM spfile in disk group failed. Following error occured: ORA-29783: GPnP attribute SET failed with error [CLSGPNP_NOT_FOUND]
报错信息如下:
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.
/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]
[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]
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]
[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]