Page 1 of 4
ORA-01017: invalid username/password; logon denied
Posted: Tue 07 Mar 2017 23:54
by motuzko
Upgraded to the latest (9.2.220.0) from 9.2.162.0
Started getting ORA-01017: invalid username/password; logon denied
Same configuration
Reverted back to 9.2.162.0 - the error is gone
Any advice(s)?
Re: ORA-01017: invalid username/password; logon denied
Posted: Wed 08 Mar 2017 01:39
by motuzko
Direct connection
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production
Re: ORA-01017: invalid username/password; logon denied
Posted: Thu 09 Mar 2017 09:43
by puma
Same issue moving from 9.1.x to 9.2 only in DIRECT mode!
MY DB is Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
looking release info i found
"Oracle 12c authentication in the Direct mode is supported"
did you change anything?
I tried to load old assemblies with assembly bindings and it worked!!!
Code: Select all
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<dependentAssembly>
<publisherPolicy apply="no" />
<assemblyIdentity name="Devart.Data.Oracle" publicKeyToken="09af7300eec23701" culture="neutral"/>
<bindingRedirect oldVersion="0.0.0.0-9.02.220.0" newVersion="9.1.45.0"/>
</dependentAssembly>
</assemblyBinding>
Re: ORA-01017: invalid username/password; logon denied
Posted: Fri 10 Mar 2017 15:20
by Pinturiccio
Please provide the value of SQLNET.ALLOWED_LOGON_VERSION_SERVER on your server.
Re: ORA-01017: invalid username/password; logon denied
Posted: Fri 10 Mar 2017 15:53
by motuzko
Pinturiccio wrote:Please provide the value of SQLNET.ALLOWED_LOGON_VERSION_SERVER on your server.
I don't have access to the Oracle box. Can I obtain the value via SQL command?
Re: ORA-01017: invalid username/password; logon denied
Posted: Tue 14 Mar 2017 11:32
by puma
I can't access to DB server neither.
Could you please give us a quick support on this issue? i sent a mail to support and i didn't receive any answer.
thanks
Re: ORA-01017: invalid username/password; logon denied
Posted: Tue 14 Mar 2017 16:14
by Pinturiccio
Unfortunately, we cannot reproduce the error with a connection to Oracle 11.2.0.4.
If possible, create a user on your server with only connection privileges, and
send us these credentials (sever, port, sid or service name, user id, password) so that we can connect to your server and reproduce the issue.
Re: ORA-01017: invalid username/password; logon denied
Posted: Tue 14 Mar 2017 19:12
by motuzko
Pinturiccio wrote:Unfortunately, we cannot reproduce the error with a connection to Oracle 11.2.0.4.
If possible, create a user on your server with only connection privileges, and
send us these credentials (sever, port, sid or service name, user id, password) so that we can connect to your server and reproduce the issue.
There is no way to access the Oracle server in my case outside the firewall.
The password contains letters (both upper and lower case), underscore, and numbers.
Re: ORA-01017: invalid username/password; logon denied
Posted: Tue 14 Mar 2017 19:25
by Edward Hollingsworth
I too have the issue.
Connection String: User Id=export;Password=export;Server=servernamehere;Connection Timeout=180;Max Pool Size=150;Validate Connection=True;Direct=True;Service Name=servicenamehere;Persist Security Info=True
Error: ORA-01017: invalid username/password; logon denied
Re: ORA-01017: invalid username/password; logon denied
Posted: Wed 15 Mar 2017 13:29
by motuzko
Talked to the DBA
Here's the response:
None of those parameters are defined in sqlnet.ora file, which means they are using default values as follows. Further details on those parameters can be found in the link provided below.
SQLNET.ALLOWED_LOGON_VERSION_CLIENT=11
SQLNET.ALLOWED_LOGON_VERSION_SERVER=11
https://docs.oracle.com/database/121/NE ... #NETRF2016
Re: ORA-01017: invalid username/password; logon denied
Posted: Wed 15 Mar 2017 14:59
by puma
For your info
i uninstalled 9.2.220 and i installed 9.2.205 (09-Feb-17) and everything worked like a charme (without assembly bindigs).
I think changes in authentication you made is the cause
9.2.220 02-Mar-17
•Visual Studio 2017 Release Candidate 4 is supported
•Oracle 12c authentication in the Direct mode is supported
Re: ORA-01017: invalid username/password; logon denied
Posted: Wed 15 Mar 2017 15:12
by a.claudiu
hello. I bought today dotconnect for oracle pro 9.2.220 ( I had trial 9.2.205 ).
now I cant connect on oracle 11.2.0.4.
what can I do ?
Re: ORA-01017: invalid username/password; logon denied
Posted: Wed 15 Mar 2017 19:52
by Edward Hollingsworth
a.claudiu. Do you have a link to the older versions like 9.2.205? The website doesn't appear to have the earlier versions link anymore. Thanks!
Re: ORA-01017: invalid username/password; logon denied
Posted: Thu 16 Mar 2017 07:43
by a.claudiu
please give me a solution to my problem. I bought yesterday a product from you which I can't use !!!
it is very urgent.
Re: ORA-01017: invalid username/password; logon denied
Posted: Thu 16 Mar 2017 11:26
by Edward Hollingsworth
It's very urgent for me as well. This is happening only on 11G x64 Oracle databases. Everything works fine on our 10G databases. What gives?
Our developers work for a large, well-known corporation and it's a shame that after believing faithfully in this control from a well-known company after all these years, a product would be put out to the public that totally breaks everything that has worked for many years.
Thank you!