Oracle.ManagedDataAccess OracleInternal.NotificationServices.ONSException

I found this link helpful:https://www.databaseusers.com/article/6046913/ONS%3A+No+node+lists+were+configured

Basically, you need to configure ONS, or disable LoadBalancing and HAEvents like so:

Oracle.ManagedDataAccess.Client.OracleConfiguration.LoadBalancing = false;Oracle.ManagedDataAccess.Client.OracleConfiguration.HAEvents = false;

Thanks to Jacob Peterson.

But if you are unable to find the mentioned setting in C# code then configure your config as below. "Add settings if the block is already there"

<oracle.manageddataaccess.client>    <version number="*">      <settings>        <setting name="LoadBalancing" value="false" />        <setting name="HAEvents" value="false" />      </settings>          </version>     </oracle.manageddataaccess.client>

We configure the OracleConnection with a single connection string (without any xml).
Setting those two parameters is possible using the following names, the other parts are for example and not relevant for this problem.

Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=mydbhost)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=myservicename)));load balancing=false;ha events=false;Min Pool Size=1;Incr Pool Size=1;user id=mydbuser