Is it possible for a JDBC application to receive Fast Application Notification (FAN) from an Oracle Data Guard broker when a SWITCHOVER happens from a primary to a secondary database, so that the application can reconnect without Oracle RAC/ cluster? That is, I have just got a single instance database on the primary site and a similar setup on the secondary site, and I want my Java based application to detect and reconnect in case of FAILOVER/ SWITCHOVER.
Based on what I know about FAN, it depends on Oracle Notification Service, which indirectly means Oracle RAC/ Grid. Is this understanding correct? Oracle Data Guard, by itself, doesn't require either Oracle RAC or Oracle Grid.
If FAN is not available, what are the options for an application to get the connection to the new primary without requiring a restart?
Copyright Notice：Content Author:「Jaywalker」，Reproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article：https://stackoverflow.com/questions/51730027/oracle-fan-with-oracle-data-guard-but-without-using-oracle-grid-rac