Connection string for Code Only RC+Oracle RAC??
Connection string for Code Only RC+Oracle RAC??
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?
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.
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.