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




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.

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

  1. Usn’s IT Blog » Oracle 11gR2 ASM / ACFS: A first benchmark (poorly) Says:

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

  2. Ninpb Says:

    Thank you so much! Fingers have “sysdba” ingrained in them!

  3. Oracle 11gR2 ASM: Changed permission policy (ORA-15260) | Oracle VUE Says:

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

Leave a Reply