What is the action of your client connection when it is using the following connect string?

What is the action of your client connection when it is using the following connect string?

net_service_name=

(DESCRIPTION=

(ADDRESS=(PROTOCOL=tcp)(HOST=sales1-svr-vip)(PORT=1521))

(ADDRESS=(PROTOCOL=tcp)(HOST=sales2-svr-vip)(PORT=1521)))

(CONNECT_DATA=(SERVICE_NAME=sales.us.acme.com)))

What is the action of your client connection when it is using the following connect string?

net_service_name=

(DESCRIPTION=

(ADDRESS=(PROTOCOL=tcp)(HOST=sales1-svr-vip)(PORT=1521))

(ADDRESS=(PROTOCOL=tcp)(HOST=sales2-svr-vip)(PORT=1521)))

(CONNECT_DATA=(SERVICE_NAME=sales.us.acme.com)))

A.
It always connects you to the least loaded node.

B.
It always connects you to the first protocol address.

C.
It randomizes its connection on the available listeners.

D.
It tries to connect you to the listener on SALES2-SRV-VIP if the listener on SALES1-SRV-VIP is down.



Leave a Reply 0

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