We have a number of ODP.NET applications, and we are upgrading them to the latest 12c, Managed Driver provider. I thought I'd take this opportunity to standardize the connection strings in our applications. We are in a RAC environment so my thought is this template should be sufficient:
Data Source=VALUE;HA Events=true;Load Balancing=true;Password=VALUE;User Id=VALUE;
My rationale is that all defaults for the other attributes in the documentation appear sufficient. However, I am wondering if this is a good practice. Would it be better to explicitly specify all the settings, in case they change to something else? Is this even likely to happen?
Thanks!
John