oracle 11gR2 关闭asm实例报ORA-01031错误处理
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