1Z0-058 · Question #80
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…
The correct answer is A. Enable Advanced Queuing notifications by using SRVCTL as shown in the following command: B. Execute the following statement for the users that will be connecting by way of the .Net D. Enable Fast Connection Failover for ODP.NET connection pools by subscribing to FAN High. 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 srvctl modify service -d crm -s odpnet.example.com -q…
Question
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?
Options
- AEnable Advanced Queuing notifications by using SRVCTL as shown in the following command:
- BExecute the following statement for the users that will be connecting by way of the .Net
- CEnable Transparent Application Failover (TAF), either on the client or for the service.
- DEnable Fast Connection Failover for ODP.NET connection pools by subscribing to FAN High
- ELink client applications with the client thread or operating system library.
How the community answered
(28 responses)- A82% (23)
- C11% (3)
- E7% (2)
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 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: DBMS_AQADM.GRANT_QUEUE_PRIVILEGE('DEQUEUE','SYS.SYS$SERVICE_METRICS', 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)
Topics
Community Discussion
No community discussion yet for this question.