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
owner 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:
Cause
You have logged in with SYSDBA privilege that is not allowed for ASM operations
Solution
Login with SYSASM credentials for ASM operations
MOS [ID 889810.1]
A is wrong. there is no operation yet
B is wrong. the error message is not about compatibility
C is wrong. v$asm_usergroup is for ASM file access
D is wrong. v$xs_session_roles are the enabled roles in the current application session
E is right. you have to login as sysasm, not sysdba
So E is correct.