Page 1 of 1
Connection string for Code Only RC+Oracle RAC??
Posted: Sun 27 Mar 2011 20:54
by joao88
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?
Posted: Mon 28 Mar 2011 09:25
by Shalex
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/B283 ... 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.