How many connections are established, and on which instances?

You define the ERP service using this statement:

srvctl add service -d RACDB -s ERP -r RAC01 -a RAC02 -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=N1VIP)(PORT=1521))

(ADDRESS=(PROTOCOL=TCP)(HOST=N2VIP)(PORT=1521))

(CONNECT_DATA = (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?

You define the ERP service using this statement:

srvctl add service -d RACDB -s ERP -r RAC01 -a RAC02 -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=N1VIP)(PORT=1521))

(ADDRESS=(PROTOCOL=TCP)(HOST=N2VIP)(PORT=1521))

(CONNECT_DATA = (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



Leave a Reply 0

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