How do you diagnose this error?

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-1S260: permission denied on ASM disk group How do you diagnose this
error?

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-1S260: 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.



Leave a Reply 0

Your email address will not be published. Required fields are marked *