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?

Question

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?

Accepted Answer

E. Check the connect string for the privileged role.

Answer

A. Check v$asm_operation for operations halted by the error.

Answer

B. Check v$asm_attributes to determine the asm.compatible setting.

Answer

C. Check v$asm_usergroup to determine the owning user group for this diskgroup.

Answer

D. Check v$xs_session_role to determine the role privileges of the current user.

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…

Question

Options

How the community answered

Explanation

Topics

Community Discussion