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 [oracle®gr7597-]$ 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 Transparent Application Failover (TAF), either on the client or for the service.
B.
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.
C.
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 ) ;
D.
Enable Advanced Queuing notifications by using SRVCTL as shown in the following
command: $ srvctl modify service -d prod -s gl -q TRUE -j LONG
E.
Link client applications with the client thread or operating system library.