Connection string for Code Only RC+Oracle RAC??

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Posts: 6
Joined: Wed 12 Jan 2011 20:42

Connection string for Code Only RC+Oracle RAC??

Post by joao88 » Sun 27 Mar 2011 20:54

Hi i will deploy my application tomorrow and need how i can configure devart to Oracle RAC?. With EDM i use oracle home but with Code Only RC how i can configure?

Site Admin
Posts: 8247
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Mon 28 Mar 2011 09:25

There are two connection modes: OCI (via Oracle Client) and Direct.

RAC is supported in the OCI mode only (the Direct=false; parameter in the connection string). All Oracle client settings should be specified in the tnsnames.ora file of your Oracle client ( ... snames.htm).

In the Direct mode you can connect only to one database instance (doesn't matter whether SID or Service Name is used to identify this single instance). When Service Name is specified and implies several database instances, dotConnect for Oracle connects to the first instance provided by Oracle listener. Note that RAC itself is not supported in the Direct mode, and provider works only with this one database instance.

Post Reply