ORA-29786: SIHA attribute GET failed with error [Attribute ‘SPFILE’ sts[200] lsts[0]]

Recently while performing fresh ASM installation, I was trying to create spfile from pfile , I encountered this issue:

ORA-29786: SIHA attribute GET failed with error [Attribute ‘SPFILE’ sts[200] lsts[0]]


 

[oraasm@rmb-put-mordor ~]$ sqlplus
SQL*Plus: Release 11.2.0.3.0 Production on Fri Sep 6 07:55:51 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Enter user-name: / as sysasm
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
SQL> sho parameter pfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string
SQL>
SQL> create spfile from pfile;
create spfile from pfile
*
ERROR at line 1:
ORA-29786: SIHA attribute GET failed with error [Attribute 'SPFILE' sts[200]
lsts[0]]

After searching on metalink I found that ASM database was not started using SVRCTL utility, It was started manually.


 

[oraasm@rmb-put-mordor ~]$ srvctl status asm
ASM is not running.

To resolve this issue , we need to start ASM using SRVCTL utility. Please find below to resolve this issue:


 

[oraasm@rmb-put-mordor ~]$ srvctl add asm
[oraasm@rmb-put-mordor ~]$ srvctl status asm
ASM is not running.
[oraasm@rmb-put-mordor ~]$ srvctl start asm
[oraasm@rmb-put-mordor ~]$ srvctl status asm
ASM is running on rmb-put-mordor
[oraasm@rmb-put-mordor ~]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.3.0 Production on Fri Sep 6 07:59:44 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Automatic Storage Management option
SQL>
SQL> sho parameter pfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string
SQL>
SQL> create spfile from pfile;
File created.
SQL>
SQL> shu immediate
ASM diskgroups dismounted
ASM instance shutdown
SQL> startuP
ASM instance started
Total System Global Area 684785664 bytes
Fixed Size 2231512 bytes
Variable Size 657388328 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted
SQL> sho parameter pfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /u01/oracle/ASM/11.2.0/grid/dbs/spfile+ASM.ora
SQL>

Hope so u will find this post very useful 🙂

Cheers

Regards,

Adityanath

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s