RAC connection string

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
PlanetPaolo
Posts: 1
Joined: Thu 17 Feb 2011 22:47
Location: Adelaide, Australia

RAC connection string

Post by PlanetPaolo » Thu 17 Feb 2011 23:04

Hi,

We have been using Direct mode whilst developing our application (using Entity Framework) and our connection strings looks like this:

connectionString=
"metadata=[...omitted...]
provider=Devart.Data.Oracle;
provider connection string = "
Server=;Port=1521;User Id=;Password=;Direct=true;SID=;
""

For deployment, we need to target a RAC server and we have been asked to use the service_name instead of the SID.
I know that Direct mode is not applicable in this case.
Could you please advise how the above connection string should look like to meet the specified requirements?

Thank you in advance,
Paolo

Shalex
Site Admin
Posts: 8248
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Fri 18 Feb 2011 11:02

There are two connection modes: OCI (via Oracle Client) and Direct. RAC is supported in the OCI mode. 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). We will investigate the possibility of implementing the RAC support in the Direct mode but there is no timeframe.

slaxman
Posts: 47
Joined: Wed 16 Sep 2009 20:09
Location: United States

any updates on this?

Post by slaxman » Thu 27 Oct 2011 22:23

We need this feature as well--badly. where is it in your roadmap?

Shalex
Site Admin
Posts: 8248
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Mon 31 Oct 2011 10:56

We cannot provide any timeframe concerning RAC support in the Direct mode.

Post Reply