Newsletters Archive - 2009

If you would like to know more about the Newsletter, please email me.

  Using FAN with SQL*Plus in Oracle 11g — (27-September-2009)

Starting with Oracle 11g, Fast Application Notification (FAN) can be used with 
SQL*Plus. With Oracle RAC 11g, you can specify the -F (FAILOVER) option to the 
sqlplus command. This enabled SQL*Plus to interact with the OCI failover mode 
in a Real Application Cluster (RAC) environment. In this mode, a service or 
instance failure is transparently handled with transaction status messages if 

For an in-depth working example that describes the Fast Connection Failover 
(FCF) mechanism, please consult the following JDBC Java application:

Oracle Fast Connection Failover Example

Jeffrey M. Hunter, OCP
Sr. Database Administrator