Connection string for Code Only RC+Oracle RAC??

Connection string for Code Only RC+Oracle RAC??

Postby 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?
joao88
 
Posts: 6
Joined: Wed 12 Jan 2011 20:42

Postby 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 (http://download.oracle.com/docs/cd/B28359_01/network.111/b28317/tnsnames.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.
Shalex
Devart Team
 
Posts: 7377
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle