Which two connect strings are correctly configured to connect to the ERP service?

Assume that you want to make a connection to the ERP service associated with a newly created
RAC database called PROD on a cluster called cluster01 that consists of three nodes: node1,
node2, and node3. Which two connect strings are correctly configured to connect to the ERP
service?

Assume that you want to make a connection to the ERP service associated with a newly created
RAC database called PROD on a cluster called cluster01 that consists of three nodes: node1,
node2, and node3. Which two connect strings are correctly configured to connect to the ERP
service?

A.
ERP=(DESCRIPTION =
(LOAD_BALANCE=on )
(ADDRESS =(PROTOCOL=TCP)(HOST=cluster01-scan)(PORT=1521))
(CONNECT_DATA=( SERVICE_NAME=ERP)))

B.
ERP= (DESCRIPTION=
(LOAD_BALANCE=on )
(ADDRESS=(PROTOCOL=TCP)(HOST=node1-vip)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=node2-vip)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=node3-vip)(PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=ORCL)))

C.
ERP=(DESCRIPTION=
(LOAD_BALANCE=on )
(ADDRESS=(PROTOCOL=TCP)(HOST=cluster01-scan1)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=cluster01-scan2)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=cluster01-scan3)(PORT=1521))
(CONNECT_DATA=( SERVICE_NAME=ERP)))

D.
url=”jdbc:oracle:thin:@(DESCRIPTION=
(LOAD_BALANCE=on)
(ADDRESS=(PROTOCOL=TCP)(HOST=cluster01-scan)(PORT=1521)))
(CONNECT DATA=(SERVICE NAME=ERP)))”

Explanation:
Use Services with Client Applications

Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 15 – 11



Leave a Reply 1

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


L. Zhu

L. Zhu

A is right. using scan and right service name
B is wrong. wrong service name
C is wrong. should use node vip, not scan vip
D is right. for jdbc thin

So A.D. are correct