Possible regression: Value cannot be null. (Parameter 'hostname')

[Shalex]

We tested a dozen of our servers of various versions from 8 to 20c and still cannot reproduce the error. As soon as someone gives us a test connection, we will immediately fix the issue.

[Jan Zimmermann]

I can also can confirm that last version has this error.

Requested Information provided by contact form.

Oracle Version: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Clustered DB

Is it possible to Dump the Information you need from a testconnection? I dont think that our Database Admin or our infrastructure allow a connection to the internet.

[suojatar]

We've been having the same issue with all versions past 9.11.980, including the latest, 9.13.1107. Tried the following connection strings (sensitive values replaced with values in angled brackets)- all work in 9.11.980 but not in later versions:

_connectionString = "Data Source=(DESCRIPTION=(CONNECT_TIMEOUT=5)(RETRY_COUNT=2)(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=<hostname>)(PORT=1521))(SERVICE_NAME=<servicename>));Direct=true;Uid=<userid>;Pwd=<password>;License Key=<licensekey>;

Error: Value cannot be null. (Parameter 'hostname')

_connectionString = "Data Source=(DESCRIPTION_LIST=(FAILOVER=on)(LOAD_BALANCE=off)(DESCRIPTION=(CONNECT_TIMEOUT=5)(RETRY_COUNT=2)(LOAD_BALANCE=on)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<hostname>)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=<hostname2>)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=<servicename>))));Direct=true;Uid=<userid>;Pwd=<password>;License Key=<licensekey>;
Throws the following exception:

Error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Tried instantiating an OracleConnectionStringBuilder object - works in 9.11.980, bombs out in later versions:

var oracleCSB = new OracleConnectionStringBuilder()
{
Direct = true,
ServiceName = "<servicename>",
Server = "<hostname>",
Port = 1521,
UserId = "<userid>",
Password = "<password>",
ConnectionTimeout = 5,
LicenseKey = "<licensekey>"
};

_connectionString = oracleCSB.ConnectionString;

Error: Value cannot be null. (Parameter 'hostname')

We have verified that our values do not contain any special characters. Please address. Thanks.

[Shalex]

We have reproduced the bug in our environment and will notify you when the issue is fixed.

[Shalex]

The bug with connecting to Oracle Real Application Clusters (RAC) in the Direct mode is fixed.

The internal build with the fix: https://download.devart.com/nuget_oracle_9_13_1112.zip .

[hkrug]

When will the bug be officially fixed?

[Shalex]

We are going to release a new public build this week.

[Jan Zimmermann]

The BUg is fixed with Version 9.13.1127

Thank you @Devart

[Shalex]

New build of dotConnect for Oracle 9.13.1127 is available for download now: viewtopic.php?f=1&t=42365.