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

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7199859/viewspace-669798/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/7199859/viewspace-669798/