September 15th, 2009

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


By usn in Oracle 



You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “Oracle 11gR2 ASM: Changed permission policy (ORA-15260)”

  1. Usn’s IT Blog » Oracle 11gR2 ASM / ACFS: A first benchmark (poorly) Says:
    September 15th, 2009 at 3:01 pm

    [...] Have a look at ASM permission pitfalls as well. By usn in Linux / Unix, Oracle  You can follow any responses to this [...]

Leave a Reply