ORA-01017: invalid username/password; logon denied
ORA-01017: invalid username/password; logon denied
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)?
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.
Re: ORA-01017: invalid username/password; logon denied
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
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.
Re: ORA-01017: invalid username/password; logon denied
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!!!
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>
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: ORA-01017: invalid username/password; logon denied
Please provide the value of SQLNET.ALLOWED_LOGON_VERSION_SERVER on your server.
Re: ORA-01017: invalid username/password; logon denied
I don't have access to the Oracle box. Can I obtain the value via SQL command?Pinturiccio wrote:Please provide the value of SQLNET.ALLOWED_LOGON_VERSION_SERVER on your server.
Re: ORA-01017: invalid username/password; logon denied
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
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
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: ORA-01017: invalid username/password; logon denied
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.
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
There is no way to access the Oracle server in my case outside the firewall.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.
The password contains letters (both upper and lower case), underscore, and numbers.
-
- Posts: 10
- Joined: Tue 14 Mar 2017 19:22
Re: ORA-01017: invalid username/password; logon denied
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
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
Talked to the DBA
Here's the response:
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
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
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
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 ?
now I cant connect on oracle 11.2.0.4.
what can I do ?
-
- Posts: 10
- Joined: Tue 14 Mar 2017 19:22
Re: ORA-01017: invalid username/password; logon denied
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
please give me a solution to my problem. I bought yesterday a product from you which I can't use !!!
it is very urgent.
it is very urgent.
-
- Posts: 10
- Joined: Tue 14 Mar 2017 19:22
Re: ORA-01017: invalid username/password; logon denied
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!
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!