在11g中,增加磁盘到已有的磁盘组中,操作命令还是"alter diskgroup webdg add disk '/dev/raw/raw4';",但是使用sysdba连接则会报错。
(墙内链接: http://mikixiyou.iteye.com/blog/1508663
)
ORA-15260: permission denied on ASM disk group
告知权限被否则。
[root@serv1 ~]# su - grid
/home/grid@serv1=>+ASM1$sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Thu May 3 15:28:20 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> alter diskgroup webdg add disk '/dev/raw/raw4';
alter diskgroup webdg add disk '/dev/raw/raw4'
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15260: permission denied on ASM disk group
使用sysasm连接,即可。
/home/grid@serv1=>+ASM1$sqlplus / as sysasm
SQL*Plus: Release 11.2.0.1.0 Production on Thu May 3 15:29:42 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> show user
USER is "SYS"
SQL> alter diskgroup webdg add disk '/dev/raw/raw4';
这是11g在ASM管理上一个改进。
分享到:
相关推荐
ASM 实例中遇到 ORA-4031 官方解决方案
oracleasm-support-2.1.8-1.SLE11.x86_64.rpm oracleasm-support-2.1.8-1.SLE11.x86_64.rpm
REDHAT安装ASM时必须安装的包。一共有三个,分别是 oracleasm-support-2.1.7-1.el5.i386.rpm oracleasm-2.6.18-164.el5-2.0.5-1.el5.i686.rpm oracleasmlib-2.0.4-1.el5.i386.rpm
kmod-oracleasm-2.0.8-15.el6_9.x86_64 oracleasm-support-2.1.8-1.el6.x86_64 oracleasmlib-2.0.4-1.el6.x86_64 安装顺序: rpm -ivh kmod-oracleasm-2.0.8-15.el6_9.x86_64.rpm rpm -ivh oracleasm-support-2.1.8...
oracleasm-support-2.1.8-1.el6.x86_64.rpm
oracleasm-support-2.1.4-1.el5.x86_64.rpm 适用于内核为2.6.18-164.el5环境使用
oracleasm-support-2.1.7-1.el5.x86_64.rpm
centos 7 oracleasm-support el7 rpm 安装包
kmod-oracleasm-2.0.6.rh1-2.el6.x86_64.rpm kmod-oracleasm-2.0.6.rh1-3.el6_5.x86_64.rpm
Oracle 11G ASM安装准备 linux
oracleasm-support-2.1.8-1.el5.i386 .rpm oracleasm 所需rpm
当任何试图分配一个大的连续的共享池中的内存失败,Oracle首先会刷新掉共享池中所有目前不在使用的对象,然后使得内存块被合并在一起。如果内存块仍然不够满足需求,那么就会出现ORA- 04031错误。这些错误同样可能...
rhel-asm包括kmod-oracleasm-2.0.6.rh1-2 kmod-oracleasm-2.0.6.rh1-3.el6.x86_64和 kmod-oracleasm-2.0.6.rh1-3.el6.x86_64
在Linux平台上配置ASM环境需安装的三个软件包之一。
oracle 安装所需asm rpm安装包。 oracleasm-support-2.1.8-1.el5.x86_64
oracleasm-support-2.1.3-1.el5.x86_64.rpm
kmod-oracleasm-2.0.6.rh1-3.el6.x86_64.rpm和Oracleasmlib、Oracleasm-support,
linux4.6下oracleasm插件,oracleasm-support-2.1.7-1.el4.x86_64.rpm
oracleasmlib-2.0.2-1.i386.rpm oracleasm-support-2.0.4-1.el5.i386.rpm
oracleasm-support-2.1.7-1.el5.i386.rpm