ORA-29786: SIHA attribute GET failed with Error If 11gR2 ASM instance is created manually
(Doc ID 976075.1)
Last updated on APRIL 25, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.1.0 to 11.2.0.1.0 [Release 11.2]Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
After creating an initial parameter file init+ASM.ora manually and starting an ASM instance, certain ASM commands fail with ORA-29786 in sqlplus:
sqlplus / as sysasm
SQL> create spfile='$ORACLE_HOME/spfile+ASM.ora' from pfile='$ORACLE_HOME/dbs/init+ASM.ora';
create spfile='$ORACLE_HOME/spfile+ASM.ora' from pfile='$ORACLE_HOME/dbs/init+ASM.ora'
*
ERROR at line 1:
ORA-29786: SIHA attribute GET failed with error [Attribute 'SPFILE' sts[200]
lsts[0]]
SQL> create spfile='$ORACLE_HOME/spfile+ASM.ora' from pfile='$ORACLE_HOME/dbs/init+ASM.ora';
create spfile='$ORACLE_HOME/spfile+ASM.ora' from pfile='$ORACLE_HOME/dbs/init+ASM.ora'
*
ERROR at line 1:
ORA-29786: SIHA attribute GET failed with error [Attribute 'SPFILE' sts[200]
lsts[0]]
SQL> create diskgroup <DISK_GROUP>1 normal redundancy disk '/opt/oracle/oradata/nobilldb/<DISK_GROUP>1_dev0' disk '/opt/oracle/oradata/nobilldb/<DISK_GROUP>1_dev1';
Diskgroup created.
SQL> drop diskgroup <DISK_GROUP>1;
drop diskgroup <DISK_GROUP>1
*
ERROR at line 1:
ORA-15039: diskgroup not dropped
ORA-29786: SIHA attribute GET failed with error [Attribute 'SPFILE' sts[200]
lsts[0]]
Diskgroup created.
SQL> drop diskgroup <DISK_GROUP>1;
drop diskgroup <DISK_GROUP>1
*
ERROR at line 1:
ORA-15039: diskgroup not dropped
ORA-29786: SIHA attribute GET failed with error [Attribute 'SPFILE' sts[200]
lsts[0]]
Better option to create ASM instance is to run asmca in GUI/Silent mode.
Changes
Starting with 11gR2, ASM instance is a resoure in CRS repository also in single instance installations. Hence, it must be registered to OLR before doing certain operations like create/drop diskgroup, create pfile/spfile, etc.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |