ORA-01017: invalid username/password; logon denied

ORA-01017: invalid username/password; logon denied

Postby 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: 48
Joined: Tue 08 Sep 2009 18:02

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

Postby 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.
motuzko
 
Posts: 48
Joined: Tue 08 Sep 2009 18:02

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

Postby 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>
puma
 
Posts: 4
Joined: Thu 09 Mar 2017 09:39

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

Postby Pinturiccio » Fri 10 Mar 2017 15:20

Please provide the value of SQLNET.ALLOWED_LOGON_VERSION_SERVER on your server.
Pinturiccio
Devart Team
 
Posts: 2021
Joined: Wed 02 Nov 2011 09:44

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

Postby 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?
motuzko
 
Posts: 48
Joined: Tue 08 Sep 2009 18:02

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

Postby 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
puma
 
Posts: 4
Joined: Thu 09 Mar 2017 09:39

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

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

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

Postby 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.
motuzko
 
Posts: 48
Joined: Tue 08 Sep 2009 18:02

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

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

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

Postby 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/NETRF/sqlnet.htm#NETRF2016
motuzko
 
Posts: 48
Joined: Tue 08 Sep 2009 18:02

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

Postby 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
puma
 
Posts: 4
Joined: Thu 09 Mar 2017 09:39

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

Postby 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 ?
a.claudiu
 
Posts: 2
Joined: Wed 15 Mar 2017 12:37

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

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

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

Postby 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.
a.claudiu
 
Posts: 2
Joined: Wed 15 Mar 2017 12:37

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

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

Next

Return to dotConnect for Oracle