oracle11g r2中asm角色进行了分离,其中对磁盘组的mount管理也发生了变化,需要mount磁盘,必须以sysasm角色登陆sqlplus而不是之前的sysdba。
如果以sysdba登陆做报如下错:
sqlplus /as sysdba
SQL> alter diskgroup data1 mount;
alter diskgroup data1 mount
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15260: permission denied on ASM disk group
以sysasm登陆后正常
$ sqlplus / as sysasm
SQL> alter diskgroup data1 mount;
Diskgroup altered.