Connecting to Oracle RAC Using ODAC Direct Mode

kemplud · Post by **kemplud** » Fri 25 Apr 2008 23:09

Is there any way to take advantage of the 11g RAC feature (cluster) using ODAC direct mode?

I need to use RAC feature in implementing the database infrastructure with no single points-of-failure by employing redundancy, thus reducing the chances that any set of simultaneous failures will cause a loss of service.

For example, is there any way to translate tnsnames.ora file below in ODAC direct mode connection string?

Code: Select all

ARMSTRONG.ACCT =
  (DESCRIPTION = 
    (ADDRESS_LIST= 
     (ADDRESS= (PROTOCOL = TCP)(HOST = server1)(PORT = 1521))
     (ADDRESS= (PROTOCOL = TCP)(HOST = server2)(PORT = 1521))
     (ADDRESS= (PROTOCOL = TCP)(HOST = server3)(PORT = 1521))
     (FAILOVER = on)
     (LOAD_BALANCE = on)
    )   
    (CONNECT_DATA=
     (SERVICE_NAME = acct.us.yourcompany.com)
    )
  )

Thank you.

Plash · Post by **Plash** » Sat 26 Apr 2008 06:15

Direct mode does not support RAC. You can connect only to one fixed server in RAC.