ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Getting ORA-01031 when performing ASM adminstrative operations in 11.2

Getting ORA-01031 when performing ASM adminstrative operations in 11.2

原创 Linux操作系统 作者:spider0283 时间:2011-08-23 12:12:34 0 删除 编辑
 [ID 957055.1]  
  修改时间 10-NOV-2010     类型 PROBLEM     状态 PUBLISHED  

In this Document
  Symptoms
  Cause
  Solution
  References


Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.0 to 11.2.0.0 - Release: 11.2 to 11.2
Information in this document applies to any platform.

Symptoms

In 11.2, when logging into ASM using 'sysdba' you receive the following error:

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>

Cause

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.



Solution

You will now need to connect as SYSASM to perform. any administrative operations on the ASM instance or we will get an ORA-01031 error as shown below :

ORA-01031: insufficient privileges






References

http://download.oracle.com/docs/cd/E11882_01/install.112/e16763/whatsnew.htm

显示相关信息 相关的


产品
  • Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition
关键字
SYSDBA; SQL PLUS
错误
ORA-1031; 01031 ERROR

返回页首返回页首

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

请登录后发表评论 登录
全部评论

注册时间:2011-03-29

  • 博文量
    194
  • 访问量
    627928