ORA-01017: invalid username/password; logon denied

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Joost Van Gansbeke
Posts: 19
Joined: Thu 08 Apr 2010 11:24
Location: Belgium

Re: ORA-01017: invalid username/password; logon denied

Post by Joost Van Gansbeke » Thu 13 Apr 2017 08:01

Hello, I see in the History log:

9.2.220 02-Mar-17
•Oracle 12c authentication in the Direct mode is supported

Can I please download version "9.2.205 09-Feb-17" as that was the version before the authentication feature where all was still working I assume? On the website I can only download the latest version "9.3.230 16-Mar-17" where we have the ORA-01017 issue.

Regards,
Joost

Pinturiccio
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

Re: ORA-01017: invalid username/password; logon denied

Post by Pinturiccio » Thu 13 Apr 2017 09:12

dotConnect for Oracle Trial 9.2.205 can be downloaded by the following link: http://devart.com/pub/dcoracle92205.exe.

Joost Van Gansbeke
Posts: 19
Joined: Thu 08 Apr 2010 11:24
Location: Belgium

Re: ORA-01017: invalid username/password; logon denied

Post by Joost Van Gansbeke » Thu 13 Apr 2017 09:26

Thank you, but I only want to download a licensed version, as I have one.
Or will this work?

Regards,
Joost

Pinturiccio
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

Re: ORA-01017: invalid username/password; logon denied

Post by Pinturiccio » Thu 13 Apr 2017 09:38

Having a license for a dotConnect for Oracle, you can also download the latest version available for your subscription and any previous versions. You can find any previous version in the 'Registered Users' Area in the following way: click "Previous versions" on the "Download" page. So you will be able download dotConnect for Oracle 9.2.205, with which the issue did not occur.

Edward Hollingsworth
Posts: 10
Joined: Tue 14 Mar 2017 19:22

Re: ORA-01017: invalid username/password; logon denied

Post by Edward Hollingsworth » Thu 13 Apr 2017 16:47

My original issue was this: with the new version of dotConnect for Oracle 9.3.230.0, I could no longer use a connect string that is the same format of a TNSNAMES file entry. After setting in code like this, they work fine.

So we know...

MyConnString = "Server=(DESCRIPTION = " + _
" (ADDRESS = (PROTOCOL = TCP)(HOST = hostmachinename)(PORT = 1521))" + _
" (CONNECT_DATA =" + " (SERVER = DEDICATED)" + _
" (SERVICE_NAME = databasename)" + " )" + " );" + _
"direct=true;connection timeout=180;max pool size=150;validate connection=true;persist security info=true;" + _
"pass parameters by name=true;uid=useridhere;pwd=userpasshere"

Pinturiccio
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

Re: ORA-01017: invalid username/password; logon denied

Post by Pinturiccio » Tue 18 Apr 2017 15:40

Edward Hollingsworth wrote:My original issue was this: with the new version of dotConnect for Oracle 9.3.230.0, I could no longer use a connect string that is the same format of a TNSNAMES file entry. After setting in code like this, they work fine.

So we know...
Please provide a connection string (roughly, without credentials), with which a connection worked before, but then stopped working after updating to dotConnect for Oracle 9.3.230. Which changes did you make, after which the connection started working again?

Please also tell us the error text when using a connection with the Server parameter having the format of a TNSNAMES file entry.

Edward Hollingsworth
Posts: 10
Joined: Tue 14 Mar 2017 19:22

Re: ORA-01017: invalid username/password; logon denied

Post by Edward Hollingsworth » Tue 18 Apr 2017 15:45

1st request: Data Source = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = machinenamehost)(PORT = 1521))(LOAD_BALANCE = YES)(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = servicenamehere)(FAILOVER_MODE = (TYPE = SELECT)(METHOD = BASIC)(RETRIES = 180)(DELAY = 5))))

2nd request: ORA-01017: invalid username/password; logon denied
Last edited by Edward Hollingsworth on Thu 20 Apr 2017 12:46, edited 1 time in total.

Pinturiccio
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

Re: ORA-01017: invalid username/password; logon denied

Post by Pinturiccio » Tue 18 Apr 2017 15:47

We have fixed the bug with the "ORA-01017" error when connecting to an Oracle user account with PASSWORD_VERSIONS equal to 10g only in the Direct mode. We will post here when the corresponding build of dotConnect for Oracle is available for download.

powelerl
Posts: 31
Joined: Thu 22 Dec 2016 10:00

Re: ORA-01017: invalid username/password; logon denied

Post by powelerl » Thu 20 Apr 2017 11:17

I had the same problem with 12c r1. Solved it by enabling case sensitive passwords + setting the password.

alter system set sec_case_sensitive_logon=true scope=both;
alter user USERNAME identified by PASSWORD;

If I disable case sensitive passwords it starts failing again.

Using 9.3.230. PASSWORD_VER returns "10G 11G".

Pinturiccio
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

Re: ORA-01017: invalid username/password; logon denied

Post by Pinturiccio » Thu 20 Apr 2017 13:27

Edward Hollingsworth wrote:1st request: Data Source = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = machinenamehost)(PORT = 1521))(LOAD_BALANCE = YES)(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = servicenamehere)(FAILOVER_MODE = (TYPE = SELECT)(METHOD = BASIC)(RETRIES = 180)(DELAY = 5))))
We could not reproduce the issue and can connect to Oracle server with such kind of the connection string. Is the issue related to "ORA-01017: invalid username/password; logon denied"? Can it be reproduced with any server and user account or only with specific ones?
powelerl wrote:I had the same problem with 12c r1. Solved it by enabling case sensitive passwords + setting the password.

alter system set sec_case_sensitive_logon=true scope=both;
alter user USERNAME identified by PASSWORD;

If I disable case sensitive passwords it starts failing again.

Using 9.3.230. PASSWORD_VER returns "10G 11G".
We made a fix as we posted earlier. We plan to release a new build in the nearest future. We will post here when the new build is available for download. After the new build is available, please try it and tell us whether it fixes the issue in your case.

tlaguz
Posts: 1
Joined: Wed 17 May 2017 09:08

Re: ORA-01017: invalid username/password; logon denied

Post by tlaguz » Wed 17 May 2017 09:11

Hello,
any update on this?

We ran into this issue yesterday

Pinturiccio
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

Re: ORA-01017: invalid username/password; logon denied

Post by Pinturiccio » Wed 17 May 2017 10:31

We have fixed the bug with the "ORA-01017" error when connecting to an Oracle user account with PASSWORD_VERSIONS equal to 10g only in the Direct mode. We will post here when the corresponding build of dotConnect for Oracle is available for download.

alex100
Posts: 6
Joined: Mon 18 Jul 2016 19:56

Re: ORA-01017: invalid username/password; logon denied

Post by alex100 » Thu 25 May 2017 14:42

Pinturiccio wrote:We have fixed the bug with the "ORA-01017" error when connecting to an Oracle user account with PASSWORD_VERSIONS equal to 10g only in the Direct mode. We will post here when the corresponding build of dotConnect for Oracle is available for download.
Pinturiccio any chance to get a build (even a private one will do)?

Pinturiccio
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

Re: ORA-01017: invalid username/password; logon denied

Post by Pinturiccio » Fri 26 May 2017 10:17

New version of dotConnect for Oracle 9.4 is released.
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Customer Portal (for users with valid subscription only).
For more information, please refer to viewtopic.php?t=35436

jbucher
Posts: 13
Joined: Wed 20 Aug 2014 06:05

Re: ORA-01017: invalid username/password; logon denied

Post by jbucher » Thu 10 Aug 2017 12:38

Though password_versions gives me 10G and 11G i have the same problem with unidac 7.02! 6.4 works fine!

Post Reply