Page 1 of 1

Direct connection fails after upgrade to 10.0.1

Posted: Thu 06 Apr 2017 12:07
by dados
Hi,

I just updated ODAC and recompiled my project.
Now when I try to connect I got:
ORA-01016: invalid username/password; logon denied.
ORA-01017: invalid username/password; logon denied.

I then created an new vcl project and put OraSession on the form and opened the session editor.
Filled out the form for a direct connection it fails.
I'm trying to connect to my Oracle 12.1.0.2 db

So after the upgrade to ODAC 10.0.1 the following direct connection work/fail:
12.2.0.1 works
12.1.0.2 fails (I have a group of 4 db's on solaris 2xdev, 1xtest and 1xprod that all fail the same way)
12.1.0.2 works (dev running on windows)
12.1.0.1 works
11.2.0.3 works
11.1.0.7 works
10.2.0.5 works
10.2.0.3 works x2 db's
10.1.0.2 works

I downgraded ODAC to 9.7.28 everything works as usual with direct connection except to the new 12.2.0.1 db with ORA-28040: No matching authentication protocol

All connections thought tns oracle client(oci) work

Tested with ODAC on 32/64bit 10.1 Berlin and 10.2 Tokyo

Re: Direct connection fails after upgrade to 10.0.1

Posted: Fri 07 Apr 2017 12:58
by MaximG
Thank you for the information. We will investigate this problem. Oracle 12.2.0.1 support will appear only in ODAC 10.0.1 version, therefore you get an error message when trying to connect to Oracle 12.2.0.1 server using the previous ODAC version. Please specify whether it was possible to establish a connection to the server 12.1.0.2 on the Solaris platform in Direct Mode using ODAC 9.7.28. Probably when working with the server on the Solaris platform you are using some specific encryption. Currently we do not have a possibility to check this behavior directly on Solaris platform. Please let us know whether you can provide a remote connection to your server under any Oracle user with limited rights.

Re: Direct connection fails after upgrade to 10.0.1

Posted: Fri 07 Apr 2017 13:23
by dados
I've not had any trouble connecting to these 4 db's on solaris using direct connection on previous ODAC version for the last years except with version 9.6.22 (viewtopic.php?f=5&t=33408&p=115506#p115506)
But you guys fixed that bug.

I sent to your support an email containing wireshark information when I try to connect that might help you find out what's going on.

Re: Direct connection fails after upgrade to 10.0.1

Posted: Wed 12 Apr 2017 12:46
by MaximG
We have reproduced the problem and fixed the bug. The fix will be included in the next ODAC build. Currently, we can send you a night build of ODAC with the fix. For this, please specify your license number and the exact version of Delphi you are using via the e-support form ( https://www.devart.com menu "Support"\"Request Support" )

Re: Direct connection fails after upgrade to 10.0.1

Posted: Sun 16 Apr 2017 14:04
by dados
I can confirm that the nightly fix works for me.
Thanks.

Re: Direct connection fails after upgrade to 10.0.1

Posted: Thu 20 Apr 2017 07:50
by AlexP
Glad to see that the issue was resolved. If you have any further questions, feel free to contact us.

Re: Direct connection fails after upgrade to 10.0.1

Posted: Thu 27 Apr 2017 08:15
by wchris
+1 We also wait for this fix !

Re: Direct connection fails after upgrade to 10.0.1

Posted: Fri 28 Apr 2017 12:02
by MaximG
We are glad that the problem has been solved. We will provide necessary support in case of any questions concerning the use of our products.

Re: Direct connection fails after upgrade to 10.0.1

Posted: Sun 10 Sep 2017 12:29
by andrefm
Hi,
Can I receive the night build with this fix? Thank you
Andre

Re: Direct connection fails after upgrade to 10.0.1

Posted: Tue 12 Sep 2017 05:38
by MaximG
A link to download the night build was sent to your email address

Re: Direct connection fails after upgrade to 10.0.1

Posted: Wed 01 Aug 2018 07:25
by MaximG
Please explain what info about our access components you need.