About

Martin Klier

usn-it.de

Oracle 11gR2 ASM: Changed permission policy (ORA-15260)

Did you recently see the new error ‘ORA-15260: permission denied on ASM disk group’ in your ASM administration? Maybe you are still connected as SYSDBA, old habit from 10g?

A quick citation from the Oracle Docs:

The SYSOPER privilege permits the following subset of the ALTER DISKGROUP operations: diskgroup_availability, rebalance_diskgroup_clause, check_diskgroup_clause (without the REPAIR option). All other ALTER DISKGROUP clauses require the SYSASM privilege.

Just connect with

sqlplus / as sysasm

and you are happy.

Have fun
Usn

Oracle 11g Release 2 documentation
Oracle 11gR2 ASM / ACFS: A first benchmark (poorly)

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.