oracle wire protocol,[ODBC Oracle Wire Protocol driver][Oracle]ORA-28040: No matching authentication…

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?