Shulou(Shulou.com)06/02 Report--

Add disks to the oracle database ASM disk group on a project today:

Let's talk about the environment first:

Two P750 Personals Aix 6.1 Oracle RAC 11.2.0.3

Add disk Times with the following error:

ORA-15032: not all alterations performed

ORA-15260: permission denied on ASM disk group

It turns out that the sysdba connection was used at that time, and the sysasm connection can be used instead, which is an improvement of 11g in ASM management.

Namely: su-grid

Sqlplus / as sysasm

Alter diskgroup DATA add disk'/ dev/rhdisk10'

Record the articles found on the Internet: http://yumianfeilong.com/html/2011/12/16/557.html

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.