oracle 11gR2 关闭asm实例报ORA-01031错误处理

教程发布:风哥 教程分类:ITPUX技术网 更新日期:2022-02-12 浏览学习:631

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

本文标签:
网站声明:本文由风哥整理发布,转载请保留此段声明,本站所有内容将不对其使用后果做任何承诺,请读者谨慎使用!
【上一篇】
【下一篇】