How does client connect to replication server in oracle?

by user3198603   Last Updated January 14, 2018 12:05 PM

I have read couple of articles on google but not sure how DB client for example java application connect to clustered DB. All the articles I read says client will write at master node but will use slave for read.

My question is how client will know which one is master(and its location) and which one is slave(and its location). Does Oracle uses any router server(sitting separately on existing or different node) and java client will connect to this router and it is the responsibility of router to send the calls to master or slave based on request type (DDL or DML) ?

Related Questions

Disaster Recovery Database Switchover options

Updated December 07, 2017 18:05 PM