c# - Oracle.ManagedDataAccess OracleInternal.NotificationServices.ONSException

Question

我们使用“Oracle.ManagedDataAccess”ODP.NET 驱动程序来访问 Oracle 的数据库。

使用连接字符串连接数据库时:

Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(Host=10.40.40.38)(Port=1521)))(CONNECT_DATA=(SERVICE_NAME=D3T))); User Id=test; Password=test'

Internal error message:

OracleInternal.NotificationServices.ONSException**: ONS: No node lists have been configured' after opening the connection.

代码:

string connect = "Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(Host=10.40.40.38)(Port=1521)))(CONNECT_DATA=(SERVICE_NAME=D3T))); User Id=test; Password=test";
OracleConnection connection = new OracleConnection(connect);
connection.Open();

与数据库的连接工作正常。但是配置内部有什么问题？

Answer 1

我发现此链接很有帮助: https://www.databaseusers.com/article/6046913/ONS%3A+No+node+lists+were+configured

基本上，您需要像这样配置 ONS，或禁用 LoadBalancing 和 HAEvents:

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