Tuesday, February 26, 2013

ORA-15260: permission denied on ASM disk group


select * from v$asm_disk;

select * from v$asm_diskgroup;

alter diskgroup DATA01 resize disk ORA_MAIN size 360G;

ORA-15260: permission denied on ASM disk group


When I login 11gR2 ASM instance as sysdba to mount diskgroup, it showed permission denied on ASM disk group. After I login the ASM instance as sysasm, it is fixed.


SQL> alter diskgroup DATA1 mount;
alter diskgroup DATA1 mount
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15260: permission denied on ASM disk group

 

SQL> connect / as sysasm <– as sysasm
Connected.
SQL> alter diskgroup data1 mount;

Diskgroup altered.

 

alter diskgroup DATA01 resize disk ORA_MAIN size 360G;

 

[grid@MDS-ORA-RAC-03 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Tue Feb 26 15:40:38 2013

Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL> connect / as sysasm
Connected.
SQL> alter diskgroup DATA01 resize disk ORA_MAIN size 360G;

Diskgroup altered.

4 comments:

  1. I rattling delighted to find this internet site on bing, just what I was looking for :D besides bookmarked.

    ReplyDelete
  2. maillot de football...

    wow, awesome blog article.Really looking forward to read more. Awesome....

    ReplyDelete
  3. Quite good and it fixed my problem.

    thanks for it.

    ReplyDelete
  4. I am really happy to read this webpage posts which contains plenty of
    useful data, thanks for providing such information.

    ReplyDelete