Sypmtoms:
ASM存储下,无法从pfile创建spfile。
SQL>create spfile='+DG_SYS' from pfile='$ORACLE_HOME/dbs/ init+ASM.ora';
createspfile='+DG_SYS' from pfile='$ORACLE_HOME/dbs/ init+ASM.ora'
*
ERROR atline 1:
ORA-29786:SIHA attribute GET failed with error [Attribute 'SPFILE' sts[200]
lsts[0]]
Cause:
这是当前ASM不是通过oracle restart启动的,而是通过手工启动的,所以还没有在OHAS stack中注册。使用一下命令将asm添加到OHAS stack中
Solution:
[grid@addb~]$ srvctl add asm -l LISTENER -p /u01/app/12.1.0/grid/dbs/init+ASM.ora -d'/dev/12c*';
Sypmtoms:
还是无法创建Spfile。
SQL>create spfile='+DG_SYS' from pfile='$ORACLE_HOME/dbs/init+ASM.ora';
createspfile='+DG_SYS' from pfile='$ORACLE_HOME/dbs/init+ASM.ora'
*
ERROR atline 1:
ORA-17502:ksfdcre:4 Failed to create file +DG_SYS
ORA-15221:ASM operation requires compatible.asm of 11.2.0.0.0 or higher
Cause:
这是由于Disk group设置的可兼容版本号过低。
SQL> select group_number, name,compatibility,database_compatibility from v$asm_diskgroup;
GROUP_NUMBERNAME COMPATIBIL DATABASE_C
---------------------- ---------- ----------
2 DG_SYS 10.1.0.0.0 10.1.0.0.0
1 DATA 10.1.0.0.0 10.1.0.0.0
Solution:
Alter diskgroup setattribute "compatibile"="11.2";
SQL>create spfile='+DG_SYS' from pfile='$ORACLE_HOME/dbs/init+ASM.ora';
Filecreated.