Which three steps are required to enable ODP.NET clients that connect to the GL service to receive FAN High Availability Events?

You are managing a three-instance policy-managed RAC database PROD. You created a service
called GL for the PROD database by using the following command:
[oracIe@gr7597~]$ srvctl add service -d PROD -s GL -g SP1 -c singleton -y manual
Examine the following output:
[oracIe@gr7597~]$ srvctl config database -d PROD -a
Database unique name: PROD
Database name: PROD
Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1
Oracle user: oracle
Spfile: +DATA/PROD/spfileRACDB.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: SP1
Database instances:
Disk Groups: DATA, FRA
Services:

Database is enabled
Database is policy managed
[oracIe@gr7597~]$ crsctl stat res ora.PROD.db
NAME=ora.PROD.db
TYPE=cluster_resource
TARGET=ONLINE
STATE=ONLINE on gr7597 ONLINE on gr7602 ONLINE on gr7633
[oracIe@gr7597~]$ crsctl stat serverpool ora.SP1
NAME=ora.SP1
ACTIVE_SERVERS=gr7597 gr7602 gr7633
[oraclegr7597-]$ crsctl stat res ora.prod.gl.svc
NAME=ora.prod.gl.svc
TYFE=ora.service.type
TARGET=ONLINE
STATE=ONLINE on gr7597
Which three steps are required to enable ODP.NET clients that connect to the GL service to
receive FAN High Availability Events?

A.
Enable Advanced Queuing notifications by using SRVCTL as shown in the following command:
$ srvctl modify service -d prod -s gl -q TRUE -j LONG

B.
Execute the following statement for the users that will be connecting by way of the .Net
Application, where user_name is the user name:
EXECUTE DBMS_AQADM.GRANT_QUEUE_PRIVILEGE( ‘DEQUEUE’, ‘
SYS.SYS$SERVICE_METRICS’,
user_name ) ;

C.
Enable Transparent Application Failover (TAF), either on the client or for the service.

D.
Enable Fast Connection Failover for ODP.NET connection pools by subscribing to FAN High
Availability events. Do this by setting the HA events connection string attribute to true at
connection time.

E.
Link client applications with the client thread or operating system library.

Explanation:
Enabling ODP.NET Clients to Receive FAN High Availability Events

Perform the following steps to enable FAN for ODP.NET clients:
Enable Advanced Queuing notifications for a service by using SRVCTL as shown in the following
example:
srvctl modify service -d crm -s odpnet.example.com -q TRUE
Grant permissions on the internal event queue table by executing the following command for the
users that will be connecting by way of the ODP.NET application, where user_name is the
database user name:
EXECUTE
DBMS_AQADM.GRANT_QUEUE_PRIVILEGE(‘DEQUEUE’,’SYS.SYS$SERVICE_METRICS’,
user_name);
Enable Fast Connection Failover for ODP.NET connection pools by subscribing to FAN high
availability events. To enable FCF, include “HA Events=true” and “pooling=true” (the default value)
in the connection string, as shown in the following example where user_name is the name of the
database user and password is the password for that user:
con.ConnectionString =
“User Id=user_name;Password=password;Data Source=odpnet;” +
“Min Pool Size=10;Connection Lifetime=120;Connection Timeout=60;” +
“HA Events=true;Incr Pool Size=5;Decr Pool Size=2”;
Oracle Real Application Clusters Administration and Deployment Guide
11g Release 2 (11.2)