oracle 11gR2 關閉asm例項 報ORA-01031 錯誤處理

      在11.2版本中,用sqlplus  / as sysdba關閉asm例項時報ORA-01031錯誤,

sqlplus '/ as sysdba'

SQL*Plus: Release 11.2.0.1.0 Production on Thu Oct 22 13:32:50 2009

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Automatic Storage Management option

SQL> shutdown immediate;
ORA-01031: insufficient privileges
SQL>

透過查官方文件，在11.1版本之前關閉sm例項都可以正常用sqlplus / as sysdba方式

11.2版本需要用sqlplus / as  sysasm方式 即有sysasm許可權

Commands that you ran using the SYSDBA privilege on ASM 11g r1 and below have now been deprecated in release 11g r2.

Starting with 11g release 2, Oracle ASM administration must be done with the SYSASM privilege.

不只是關閉asm例項，對磁碟組新增disk或者刪除disk所有對asm 管理操作都需要用sysasm 許可權。

sqlplus '/ as sysasm'

SQL*Plus: Release 11.2.0.1.0 Production on Thu Oct 22 13:32:50 2009

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Automatic Storage Management option
SQL> shutdown immediate;

ASM diskgroups dismounted
ASM instance shutdown