The Oracle 11g Release 2 (version 11.2.0.1) ASM instance has a new diskgroup named data that Is currently not mounted You log in to a cluster node as the Grid Infrastructure software, and set the environment variables to point to the ASM instance on that node. Using SQL*plus, you issue the commands:
CONNECT / AS SYSDBA
ALTER DISKGROUP DATA MOUNT;
The system response is:
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15260: permission denied on ASM disk group
How do you diagnose this error?
A.
Check v$asm_operation for operations halted by the error.
B.
Check v$asm_attributes to determine the asm.compatible setting.
C.
Check v$asm_usergroup to determine the owning user group for this diskgroup.
D.
Check v$xs_session_role to determine the role privileges of the current user.
E.
Check the connect string for the privileged role.
Explanation:
should be:
/ as sysasm