Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

asm erro r:-ORA-15260: permission denied on ASM disk group

ORA-15260: permission denied on ASM disk group

SQL> alter diskgroup DG1 rebalance power 11;
alter diskgroup DG1 rebalance power 11
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15260: permission denied on ASM disk group


Solution:
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Automatic Storage Management option

[grid@raj bin]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.3.0 Production on Sat Jan 16 14:41:21 2016
Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Automatic Storage Management option

SQL> alter system set asm_power_limit=11 scope=spfile;
System altered.


SQL> alter diskgroup DG1 rebalance power 11;
Diskgroup altered.

Comments

Popular posts from this blog

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

PostgreSQL Pgbadger Installation On Linux

How to find the server is whether standby (slave) or primary(master) in Postgresql replication ?

7 Steps to configure BDR replication in postgresql

How To Schedule PostgreSQL Jobs using pgAgent on Linux plateform