ORA-01017: invalid username/password; logon denied

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

Postby 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
Joost Van Gansbeke
 
Posts: 19
Joined: Thu 08 Apr 2010 11:24
Location: Belgium

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

Postby 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.
Pinturiccio
Devart Team
 
Posts: 1982
Joined: Wed 02 Nov 2011 09:44

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

Postby 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
Joost Van Gansbeke
 
Posts: 19
Joined: Thu 08 Apr 2010 11:24
Location: Belgium

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

Postby 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.
Pinturiccio
Devart Team
 
Posts: 1982
Joined: Wed 02 Nov 2011 09:44

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

Postby 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"
Edward Hollingsworth
 
Posts: 10
Joined: Tue 14 Mar 2017 19:22

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

Postby 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.
Pinturiccio
Devart Team
 
Posts: 1982
Joined: Wed 02 Nov 2011 09:44

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

Postby 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.
Edward Hollingsworth
 
Posts: 10
Joined: Tue 14 Mar 2017 19:22

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

Postby 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.
Pinturiccio
Devart Team
 
Posts: 1982
Joined: Wed 02 Nov 2011 09:44

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

Postby 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".
powelerl
 
Posts: 15
Joined: Thu 22 Dec 2016 10:00

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

Postby 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.
Pinturiccio
Devart Team
 
Posts: 1982
Joined: Wed 02 Nov 2011 09:44

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

Postby tlaguz » Wed 17 May 2017 09:11

Hello,
any update on this?

We ran into this issue yesterday
tlaguz
 
Posts: 1
Joined: Wed 17 May 2017 09:08

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

Postby 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.
Pinturiccio
Devart Team
 
Posts: 1982
Joined: Wed 02 Nov 2011 09:44

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

Postby 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)?
alex100
 
Posts: 6
Joined: Mon 18 Jul 2016 19:56

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

Postby 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 http://forums.devart.com/viewtopic.php?t=35436
Pinturiccio
Devart Team
 
Posts: 1982
Joined: Wed 02 Nov 2011 09:44

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

Postby 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!
jbucher
 
Posts: 13
Joined: Wed 20 Aug 2014 06:05

PreviousNext

Return to dotConnect for Oracle