Tuesday 11 September 2018

ORA-29783: GPnP attribute SET failed with error in RAC

Error while setting ASM_DISKSTRING parameter
SQL> alter system set ASM_DISKSTRING='ORCL:ORA_DATA*','ORCL:ORA_INDEX*','ORCL:ORA_FRA*' scope=both sid='*';
alter system set ASM_DISKSTRING='ORCL:ORA_DATA*','ORCL:ORA_INDEX*','ORCL:ORA_FRA*' scope=both sid='*'
*
ERROR at line 1:
ORA-29783: GPnP attribute SET failed with error [CLSGPNP_NOT_FOUND]
Issue: GI gpnpd is unhealthy
We can find below error in log
[ GPNP]clsgpnp_crs_ensuredSignAndPush: [at clsgpnp_crs.c:663] Result: (5) CLSGPNP_NOT_FOUND. discovery failed for 8 nodes
[ GPNP]clsgpnp_crs_ensuredSignAndPush: [at clsgpnp_crs.c:757] Result: (5) CLSGPNP_NOT_FOUND. Error(s) occurred while trying to push GPnP profile op=(remote gpnpd discovery). State may be inconsistent.

Solution:Kill unhealthy gpnpd.bin from all nodes, it’ll auto restarted by GI                                                         
Node 1:
root:# ps -ef | grep gpnpd
grid 19446 1 0 Aug08 ? 00:12:40 /u01/app/grid/11.2.0.4/bin/gpnpd.bin
grid 64810 34831  0 00:15 pts/1 00:00:00 grep --color=auto gpnpd
root:# kill -9 19446
root:# ps -ef | grep gpnpd
grid 2462 1 0 00:15 ? 00:00:00 /u01/app/grid/11.2.0.4/bin/gpnpd.bin
root 4295 31796  0 00:15 pts/1 00:00:00 grep --color=auto gpnpd

Node 2:
root:# ps -ef | grep gpnpd
grid 56456 1 0 Aug08 ? 00:11:59 /u01/app/grid/11.2.0.4/bin/gpnpd.bin
root 57877 56781  0 00:16 pts/0 00:00:00 grep --color=auto gpnpd
root:# kill -9 56456
root:# ps -ef | grep gpnpd
grid 58454 1 0 00:16 ? 00:00:00 /u01/app/grid/11.2.0.4/bin/gpnpd.bin
root 58738 56781  0 00:16 pts/0  00:00:00 grep --color=auto gpnpd
                                                           
SQL> alter system set ASM_DISKSTRING='ORCL:ORA_DATA*','ORCL:ORA_INDEX*','ORCL:ORA_FRA*' scope=both sid='*';

System altered.

No comments:

Post a Comment