Which two statements are true about clustered ASM instances?

Which two statements are true about clustered ASM instances? (Choose two.)

Which two statements are true about clustered ASM instances? (Choose two.)

A.
An ASM instance must store its SPFILE in ASM.

B.
The ASM passwordfile can be stored in $GRID_HOME/dbs on local storage of a cluster node.

C.
The ASM passwordfile can be stored in a diskgroup that is accessible to all ASM instances.

D.
The SPFILE must be stored in $GRID_HOME/dbs on local storage of a cluster node.

E.
The SPFILE must be stored in a diskgroup that is accessible to all ASM instances.



Leave a Reply 5

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


YK6

YK6

Correct: B, C
Password file authentication for Oracle ASM can (NOW, >11g) work both locally and remotely. To enable password file authentication, you must create a password file for Oracle ASM. If you select the Oracle ASM storage option, then ASMCA creates a password file for Oracle ASM with initial users (SYS and ASMSNMP) when ASMCA configures the Oracle ASM disk groups.

Wrong A: If you use an SPFILE in a clustered Oracle ASM environment, then you must place the SPFILE in a disk group or on a cluster file system

Mafalda

Mafalda

I think AE
It is speaking of clustered ASM instances

If you use an SPFILE in a clustered Oracle ASM environment, then you must place the SPFILE in a disk group or on a cluster file system. Oracle recommends that the Oracle ASM SPFILE is placed in a disk group.
https://docs.oracle.com/database/121/OSTMG/GUID-3F5329FB-B0A0-4154-A71B-ACA8799D0F86.htm#OSTMG10110

The ASM Password File is now kept in an ASM Diskgroup which is available to all the nodes. Being in one place, it does not need replication between nodes
http://www.oracle.com/technetwork/articles/database/asm-odb12c-enhancements-2206102.html

Michael Z

Michael Z

Correct: C E
If you use an SPFILE in a clustered Oracle ASM environment, then you must place the SPFILE in a disk group or on a cluster file system – Oracle recommends that the Oracle ASM SPFILE is placed in a disk group

Michael Z

Michael Z

A is wrong because it says “AN” ASM instance must store “its” SPFILE in ASM. It could be right as the below – ASM instances store the SPFILE in ASM.

Jorge Z.

Jorge Z.

I believe it’s C,E
On Oracle 12c you can store spfile and password file on ASM diskgroup.