Direct connection fails after upgrade to 10.0.1

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
dados
Posts: 82
Joined: Thu 18 Aug 2005 14:06

Direct connection fails after upgrade to 10.0.1

Post by dados » Thu 06 Apr 2017 12:07

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

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: Direct connection fails after upgrade to 10.0.1

Post by MaximG » Fri 07 Apr 2017 12:58

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.

dados
Posts: 82
Joined: Thu 18 Aug 2005 14:06

Re: Direct connection fails after upgrade to 10.0.1

Post by dados » Fri 07 Apr 2017 13:23

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.

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: Direct connection fails after upgrade to 10.0.1

Post by MaximG » Wed 12 Apr 2017 12:46

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" )

dados
Posts: 82
Joined: Thu 18 Aug 2005 14:06

Re: Direct connection fails after upgrade to 10.0.1

Post by dados » Sun 16 Apr 2017 14:04

I can confirm that the nightly fix works for me.
Thanks.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Direct connection fails after upgrade to 10.0.1

Post by AlexP » Thu 20 Apr 2017 07:50

Glad to see that the issue was resolved. If you have any further questions, feel free to contact us.

wchris
Posts: 51
Joined: Thu 09 Jun 2005 09:44

Re: Direct connection fails after upgrade to 10.0.1

Post by wchris » Thu 27 Apr 2017 08:15

+1 We also wait for this fix !

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: Direct connection fails after upgrade to 10.0.1

Post by MaximG » Fri 28 Apr 2017 12:02

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.

andrefm
Posts: 37
Joined: Wed 23 Oct 2013 10:02

Re: Direct connection fails after upgrade to 10.0.1

Post by andrefm » Sun 10 Sep 2017 12:29

Hi,
Can I receive the night build with this fix? Thank you
Andre

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: Direct connection fails after upgrade to 10.0.1

Post by MaximG » Tue 12 Sep 2017 05:38

A link to download the night build was sent to your email address

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: Direct connection fails after upgrade to 10.0.1

Post by MaximG » Wed 01 Aug 2018 07:25

Please explain what info about our access components you need.

Post Reply