• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3724
  • Last Modified:

Expected Outcome of Testing Failover on Oracle RAC 10G R 2 database

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?

  • 4
  • 3
  • 3
2 Solutions
You need to set your FAILOVER_MODE

also check your LISTENER configuration.

Read chapter 13 of the Net Services Admin guide about Transparent Failover
Try like this : jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=vip-db01-lisqa.ctn)(PORT=1529))(ADDRESS=(PROTOCOL=TCP)(HOST=vip-db02-lisqa.ctn)(PORT=1529))

Also present the output :

sql > show parameter remote_listener

LSNRCTL > start remote_listener vaule

Present the output of the above two syntax and try with the above jdbc connect string alter is as per your requ.

tyronetseAuthor Commented:
I logged into sqlplus as sys and did the command

    sql > show parameter remote_listener
Which returned

I then opended another windows cmd window and did the command

LSNRCTL > start remote_listener  LISTENERS_WRAC

TNS-01151: Missing listener name, remote_listener, in LISTENER.ORA

Here are the contents of the database servers LISTENER.ORA file
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
      (PROGRAM = extproc)

      (ADDRESS = (PROTOCOL = TCP)(HOST = wrac1-vip.localdomain)(PORT = 1521)(IP = FIRST))
      (ADDRESS = (PROTOCOL = TCP)(HOST = = 1521)(IP = FIRST))

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

did you change your connect string to include the failover_mode?


change your remote_listener to "LISTENER_WRAC1"  instead of "LISTENER_WRAC"
tyronetseAuthor Commented:
When you say set failover_mode do you mean like this in my JDBC url string


failover_mode is a more complicated subclause in the connect string.

anand2000v has an example above.

Depending on your setup and requirements there are many options as to how you might want to failover.
Chapter 13 of the Net Services Admin Guide explains each option and the available settings for each.
tyronetseAuthor Commented:
Can the FAILOVER_MODE option be used with the Oracle Thin JDBC driver.
The TAF documentation says it is an OCI protocal which I think can only be used with the thick OCI JDBC driver and I've read under chapter Fast Connection Failover is supported under the Oracle Thin driver.

Hey ,
 I m sorry instead of asking you for the status of remote listener,i mistakenly typed it as start.

Lnsrctl > status LISTENERS_WRAC

The above will show us the status of the registered service names. This will be more helpful for us to check the status of Load balance.
Yes, JDBC thin driver supports TAF. Also it support FCF ( Fast Connection Failover) with JDBC thin Driver. FCF needs some alteration on the Jboss side ( You need to use XA data source to use FCF ).

We have Jboss TAF implemented in our Production and works fine for last two years. Our production works with 10g R2 RAC.

Please go thro the below metalink doucment and also

Doc id :433827.1


tyronetseAuthor Commented:
Thanks for your help guys
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now