ORA-01017: invalid username/password; logon denied

[Joost Van Gansbeke]

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]

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

[Joost Van Gansbeke]

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

Regards,
Joost

[Pinturiccio]

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]

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]

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]

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

[Pinturiccio]

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]

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]

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?

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]

Hello,
any update on this?

We ran into this issue yesterday

[Pinturiccio]

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]

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]

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]

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