ASM的spfile创建和 重命名ASM目录

创建spfile
asm_diskgroups=‘OCR’,‘DATA’,‘FRA’
instance_type=‘asm’
large_pool_size=12M
remote_login_passwordfile=‘EXCLUSIVE’
ASM_DISKSTRING=’/dev/oracleasm/disks/*’


sqlplus / as sysasm

show parameter spfile



alter diskgroup OCR mount;



create spfile=’+OCR’ from pfile=’/home/grid/tmp/init+ASM.ora’;

show parameter spfile

shutdown immediate

sqlplus / as sysasm


show parameter spfile



如果不创建的问题

这三个启不来

重命名ASM目录
asmcmd -p显示完整路径




创建目录

sqlplus “/as sysasm”
alter diskgroup DATA rename directory ‘+DATA/ORADB/ORCL’ to ‘+DATA/ORADB/ORCLDB’;


select name, system_created from v$asm_alias;