Newsletters Archive - All

If you would like to know more about the iDevelopment.info 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 
applicable.

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
jhunter@idevelopment.info
http://www.idevelopment.info
----------------------------