[11gr2@rh5 ~]$ sqlplus '/ as sysdba'
SQL*Plus: Release 11.2.0.2.0 Production on Sun Nov 7 20:35:17 2010
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Automatic Storage Management option
SQL> alter diskgroup DATA rebalance power 0;
alter diskgroup DATA rebalance power 0
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15260: permission denied on ASM disk group
SQL> alter diskgroup data add disk '/dev/hda10';
alter diskgroup data add disk '/dev/hda10'
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15260: permission denied on ASM disk group
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Automatic Storage Management option
[11gr2@rh5 ~]$ sqlplus '/ as sysasm'
SQL*Plus: Release 11.2.0.2.0 Production on Sun Nov 7 20:35:35 2010
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production
With the Automatic Storage Management option
SQL> alter diskgroup DATA rebalance power 0;
Diskgroup altered.
SQL>
SQL> alter diskgroup data add disk '/dev/hda10';
Diskgroup altered.
Sunday, November 7, 2010
sysdba VS sysasm in 11gR2
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment