The multi data source should be used when connecting to an Oracle RAC database. The multi data source is a data source abstraction that groups all the individual data sources that connect to each node of the Oracle RAC database.
Consider that the
DBApp application requires an XA connection with a JNDI name
jdbc/ds-XA added to a database.
The database is an Oracle RAC database with two nodes. The first node has an instance name
instance-rac01 and runs in the
dbhost-rac01 hostname and listens to the port
1521. The listener accepts requests to the service name
dbservice-rac01. The second node is the instance
instance-rac02, and it runs in the
dbhost-rac02 hostname, listens to the port
1521, and has a service name