3830590 wrote:Hi I have installed ORACLE 18c XE on windows. I created a database and users ,. When i try to login to my db with the user i get the below error. How do i resolve it?SQL State = "HY000", Message = "[STRS][ODBC Oracle Wire Protocol driver][Oracle]ORA-28040: No matching authentication protocol
When was last time this worked without error?
What changed since then?
[[email protected] ~]$ oerr ora 28040
28040, 0000, "No matching authentication protocol"
// *Cause: There was no acceptable authentication protocol for
// either client or server.
// *Action: The administrator should set the values of the
// SQLNET.ALLOWED_LOGON_VERSION_SERVER and
// SQLNET.ALLOWED_LOGON_VERSION_CLIENT parameters, on both the
// client and on the server, to values that match the minimum
// version software supported in the system.
// This error is also raised when the client is authenticating to
// a user account which was created without a verifier suitable for
// the client software version. In this situation, that account's
// password must be reset, in order for the required verifier to
// be generated and allow authentication to proceed successfully.
What clues exist within listener.log file?
How can we reproduce what you report?