1. 首页 > ITPUX技术网 > 正文

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

本文由风哥教程整理发布,仅用于学习测试使用,转载注明出处:http://www.fgedu.net.cn/10327.html

联系我们

在线咨询:点击这里给我发消息

微信号:itpux-com

工作日:9:30-18:30,节假日休息