You define the ERP service using this statement:
srvctl add service -d RACDB -s ERP -r RAC01 -P PRECONNECT srvctl start service -d RACDB -s
ERP
You then use this connect string to connect to your RAC instances:
ERP =
(DESCRIPTION =(FAILOVER=ON)(LOAD_BALANCE=ON)
(ADDRESS=(PROTOCOL=TCP)(HOST=N1 VIP)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=N2VIP)(PORT=1521))
(CONNECTJDATA = (SERVICE_NAME = ERP)
(FAILOVER_MODE =
(BACKUP=ERP_PRECONNECT)(TYPE=SESSION)(METHOD=PRECONNECT))))
You successfully establish a connection to your RAC database using the above connect string.
How many connections are established, and on which instances?
A.
two on RAC01
B.
two on RAC02
C.
only one on RAC01
D.
one on RAC01 and one on RAC02