ORA-01017: invalid username/password; logon denied

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
motuzko
Posts: 54
Joined: Tue 08 Sep 2009 18:02
Contact:

ORA-01017: invalid username/password; logon denied

Post by motuzko » Tue 07 Mar 2017 23:54

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)?
Last edited by motuzko on Wed 08 Mar 2017 16:10, edited 1 time in total.

motuzko
Posts: 54
Joined: Tue 08 Sep 2009 18:02
Contact:

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

Post by motuzko » Wed 08 Mar 2017 01:39

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
Last edited by motuzko on Wed 15 Mar 2017 20:51, edited 2 times in total.

puma
Posts: 4
Joined: Thu 09 Mar 2017 09:39

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

Post by puma » Thu 09 Mar 2017 09:43

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>

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

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

Post by Pinturiccio » Fri 10 Mar 2017 15:20

Please provide the value of SQLNET.ALLOWED_LOGON_VERSION_SERVER on your server.

motuzko
Posts: 54
Joined: Tue 08 Sep 2009 18:02
Contact:

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

Post by motuzko » Fri 10 Mar 2017 15:53

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?

puma
Posts: 4
Joined: Thu 09 Mar 2017 09:39

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

Post by puma » Tue 14 Mar 2017 11:32

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

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

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

Post by Pinturiccio » Tue 14 Mar 2017 16:14

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.

motuzko
Posts: 54
Joined: Tue 08 Sep 2009 18:02
Contact:

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

Post by motuzko » Tue 14 Mar 2017 19:12

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.

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

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

Post by Edward Hollingsworth » Tue 14 Mar 2017 19:25

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

motuzko
Posts: 54
Joined: Tue 08 Sep 2009 18:02
Contact:

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

Post by motuzko » Wed 15 Mar 2017 13:29

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

puma
Posts: 4
Joined: Thu 09 Mar 2017 09:39

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

Post by puma » Wed 15 Mar 2017 14:59

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

a.claudiu
Posts: 2
Joined: Wed 15 Mar 2017 12:37

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

Post by a.claudiu » Wed 15 Mar 2017 15:12

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 ?

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

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

Post by Edward Hollingsworth » Wed 15 Mar 2017 19:52

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!

a.claudiu
Posts: 2
Joined: Wed 15 Mar 2017 12:37

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

Post by a.claudiu » Thu 16 Mar 2017 07:43

please give me a solution to my problem. I bought yesterday a product from you which I can't use !!!
it is very urgent.

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

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

Post by Edward Hollingsworth » Thu 16 Mar 2017 11:26

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!

Post Reply