10.3.8 and Direct connection fails

[dados]

Hi,

I just installed ODAC 10.3.8 for Tokyo and re-compiled my project and I get ORA-01017: invalid username/password; logon denied.

I created a new VCL program and put TOraSession on the form and double-clicked and filled out the form and I get the same error

[dados]

Installed ODAC 10.3.8 for Delphi 10.3 Rio and I get the same error.

Downgraded to ODAC 10.2.7 for Tokyo and direct connection works there, as it did before the ODAC upgrade

[MaximG]

Please specify the exact version of the Oracle server you are using. In addition, if it's possible, provide us with the configuration parameters present in the SQLNET.ORA file.

[akiraiu]

I also got the Invalid Login/password problem, can not connect to oracle 12c with direct mode.
I am using:
Delphi 7 profression
ODAC 10.3.8

sqlnet.ora flie:

SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

But the ODAC 10.3.7 is work fine.

Thanks.

[MaximG]

Thank you for providing the information. We are currently testing the performance of the latest version of ODAC on all Oracle servers available in our environment, including using Oracle 12.1.0.1 and 12.2.0.1.
Unfortunately, it is not yet possible to reproduce the issue. Please specify whether you have the opportunity to provide a temporary limited access to your Oracle server. To investigate the issue, we need only access to the Oracle user of your server, which has only the privilege to establish a connection. In this case you can provide us with the required connection parameters using the e-support form (https://www.devart.com/company/contactform.html)

[dados]

Maxim, I've sent you a Wireshark info on successful connection with ODAC 10.2.7 and unsuccessful with ODAC 10.3.8
This sounds similar to what happened in ODAC 10.0.1 when you guys added alot of direct mode support
viewtopic.php?f=5&t=35240&p=122313#p122313

[MaximG]

We continue to investigate the described problem and so far have checked all versions of Oracle 12c available in our environment. The probable cause of the described error is the specific platform on which the Oracle server runs, or a combination of certain settings of the server itself. Therefore, to continue investigation, we will expect a remote connection to any test server with a minimum set of privileges, on which the problem occurs.

[ms31d300]

Hi,
we have the same problem as forum user dados.
( C++ Builder Professional 10.2.3 / ODAC 10.3.8 / Oracle Version 12.1.0.2.0 / Oracle Database 12c Release 2 Client (12.2.0.1.0) )

1. With a oracle client we can connect to the user without any problems.
Perhaps the forum user dados has an old version of the Oracle Client Version (11g) ?
2. In direct mode we got after the update to 10.3.8 the same error message "invalid username /password"

The username ist testuser and his password version is 10g and 11g.

Code: Select all

SELECT USERNAME,PASSWORD_VERSIONS FROM DBA_USERS;

So we tried to connect to other users with the limited password version 10g and 11g.
For every user with this limitations we got the same error message, but for every
user with the password versions 10g,11g and 12c, a connection is possible.

If we create an user in the 12c database with minimal rights his password version is 10g,11g and 12c
and we have also no connection problems.

Code: Select all

CREATE USER testuser2
IDENTIFIED BY "Testuser2"
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
ACCOUNT UNLOCK;
GRANT CREATE SESSION to testuser2;

We hope this information will help you troubleshoot your problem.

see also here:
https://docs.oracle.com/en/database/ora ... 4D89936304

[MaximG]

Thank you for providing the information. Thank you for the information. We reproduced the issue and fixed this error. As a workaround, we can now send you a night build of our product. For this, provide your license number and used IDE version that you are using via the e-support form (https://www.devart.com/company/contactform.html)

[heidenbluth]

Could you please release a fixed version ASAP?

[MaximG]

We are planning to release the version that you are interested in until the end of this year. As a workaround, we can send you a night build that includes the necessary changes. For this, use the e-support form e-support form https://www.devart.com/company/contactform.html to provide your license number and IDE version you use.

[heidenbluth]

Hello,

New year is now 3 weeks old and there is still no bug fix.
I also asked twice (in December) using the form you mentioned and did not get an answer.

What are your plans now for the new release? I need it very urgently.

[MaximG]

We are planning to release this build within the current week

[heidenbluth]

Thank you.

[MaximG]

A new version of ODAC 10.3.9 was released on January 21. the complete history of the changes is available on the page: https://www.devart.com/odac/revision_history.html