Product: | Syniti Replicate (a.k.a Syniti Data Replication, DBMoto) |
Version: | All |
ID: | 1646 |
Summary: | Under certain conditions, the following error may occur: ORA-1017 Logon Denied |
Q.
I received the following error in Syniti Replicate when trying to connect to an Oracle database.
“ORA-1017: invalid username/password; logon denied”
I've checked that the user name and password are correct. What should I do?
A.
You might encounter this error if you are using the following configuration:
- Oracle Server Database 11G
- ODP.NET 10.2 (Oracle.DataAccess.dll 10.2) from client
You can solve the problem by upgrading to ODP .NET 11.0 from your client.
Alternatively, you can disable the Password Case Sensitivity option on your Oracle Server with this command:
ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = FALSE
For more information, see this article in Oracle Website.