温馨提示×

温馨提示×

您好,登录后才能下订单哦!

密码登录×
登录注册×
其他方式登录
点击 登录注册 即表示同意《亿速云用户服务条款》

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

发布时间:2020-08-13 03:37:42 来源:ITPUB博客 阅读:275 作者:531968912 栏目:建站服务器

今天在一个项目上为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
向AI问一下细节

免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。

AI