Which three steps are required to enable ODP.NET clients that connect to the GL services 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:
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_l cle user: oracle Spfile:
+DATA/PROD/spfil6RACDB.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: SPl Database instances:
Disk Groups: DATA, FRA
Services:
Database is enabled Database is policy managed
[oracle@gr?597~]$ 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~]S crsctl stat serverpool ora.SPl
NAME=ora.SPl
ACTIVE_SERVERS=gr7S97 gr7 602 gr7633
[oracle@gr7597-JS 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?

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_l cle user: oracle Spfile:
+DATA/PROD/spfil6RACDB.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: SPl Database instances:
Disk Groups: DATA, FRA
Services:
Database is enabled Database is policy managed
[oracle@gr?597~]$ 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~]S crsctl stat serverpool ora.SPl
NAME=ora.SPl
ACTIVE_SERVERS=gr7S97 gr7 602 gr7633
[oracle@gr7597-JS 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 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:
Perform the following steps to enable FAN for ODP.NET clients:
srvctl modify service -d crm -s odpnet.example.com -q TRUE
EXECUTE
DBMS_AQADM.GRANT_QUEUE_PRIVILEGE(‘DEQUEUE’,’SYS.SYS$SERVICE_METR ICS’,
user_name);
Oracle Real Application Clusters Administration and Deployment Guide



Leave a Reply 3

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


L. Zhu

L. Zhu

A is right. FAN for OCI client (.NET) uses Advance Queuing
B is right. enable AQ
C is wrong. TAF is not needed for FAN
D is right. FCF and FAN are hand in hand
E is wrong. nothing to do with client thread

So A.B.D. are correct

duff

duff

ABC
FCF requires java but not “.NET”

duff

duff

Sorry, ODP.NET supports FCF

Enable Fast Connection Failover for ODP.NET connection pools by subscribing to FAN high availability events. To enable Fast Connection Failover, include “HA Events=true” and “pooling=true” 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=sales;” +
“Min Pool Size=10;Connection Lifetime=120;Connection Timeout=60;” +
“HA Events=true;Incr Pool Size=5;Decr Pool Size=2”;

https://docs.oracle.com/database/121/HABPT/config_fcf.htm#HABPT5390