2022
我们一起努力

oracle 11g 为ASM磁盘组添加磁盘时报错ORA-15260和ORA-15032处理一则

今天在一个项目上为oracle数据库ASM磁盘组添加磁盘:
先说一下环境:
两台P750,AIX 6.1,oracle RAC 11.2.0.3

添加磁盘时报如下错:
ORA-15032: not all alterations performed
ORA-15260: permission denied on ASM disk group

原来是当时使用了sysdba连接,改为使用sysasm连接即可,这是11g在ASM管理上的一个改进。
即:su – grid
sqlplus / as sysasm
alter diskgroup DATA  add disk ’/dev/rhdisk10’;

网上搜到的文章记录一下: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

赞(0)
文章名称:《oracle 11g 为ASM磁盘组添加磁盘时报错ORA-15260和ORA-15032处理一则》
文章链接:https://www.fzvps.com/53158.html
本站文章来源于互联网,如有侵权,请联系管理删除,本站资源仅供个人学习交流,请于下载后24小时内删除,不允许用于商业用途,否则法律问题自行承担。
图片版权归属各自创作者所有,图片水印出于防止被无耻之徒盗取劳动成果的目的。

评论 抢沙发

评论前必须登录!