I installed Oracle 10g RAC On Windows 2003 Using VMware Server, in order to test to see if my companies Websphere J2EE application would run on Oracle RAC database. I had to change the JDBC URL format from "jdbc:oracle:thin:@<hostname>:1521:ORCL"
Once I did that, the J2EE application was able to connect to the Oracle RAC database and application ran fine.
I then decided to test Oracle failure, by simply disconnecting the rac1-vip Node from the network, I expected that my J2EE application would still work, as the second Oracle RAC Node rac2-vip is still connected to the network.
This did not happen, and my J2EE application lost its connection to the database.
I was also connected to the database via my TOAD client, and this also lost its connection to the database.
What should of been the expected outcome of disabling one of the clustered nodes in an Oracle RAC'd database? Should the database connection of been lost or not?
Could it be the Websphere server or could it be the version of the Oracle Thin JDBC drivers that my J2EE application is using?