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

Script to find sessions that are blocking other sessions in PostgreSQL

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

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

PostgreSQL pgBadger

How to Return a Result Set from a PostgreSQL Stored Procedure