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:
(oracle@gr7597~] $ srvctl add service -d PROD -s GL -g SP1 -c singleton -y manual
Examine the following output:
(oracle@gr7597~] $ srvctl config database -d PROD -a Database unique name: PROD base name: PROD
Oracle home: /u0l/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
[oracle@gr7597~]$ crsctl stat res ora.PROD.db
NAME=ora.PROD.db
TYPE=cluster_resource
TARGET=ONLlNE
STATE=ONLINE on gr7597 ONLINE on gr7602 ONLINE on gr7633
[oracle@gr7597~] $ crsctl stat serverpool ora.SP1
NAME=ora.SP1
ACTIVE_SERVERS=gr7597 gr75602 gr7633
[oracle@gr7597~] $ crsctl NAME=ora.prod.gl.svc
TYPE=ora.service – type
TARGET=ONLINE
STATE=ONLlNE on gr7597
Which three steps are required to enable ODP.NET clients that connect to the GL services 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 .
SYSSSERVICE_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 Hi-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.