Shulou(Shulou.com)06/03 Report--

This article mainly explains "how to solve the problem that Oracle | ORA-28040 low-version client cannot connect to Oracle 19C". The content of the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "how to solve the problem that Oracle | ORA-28040 low-version client cannot connect to Oracle 19C"!

Problem background

After the system Oracle version was upgraded from the original Oracle 11g to Oracle 19c, the PLSQL client connection reported an error:

ORA-28040: No matching authentication protocol

ORA-28040: no matching authentication protocol

Cause of the problem

Client-and server-side password generation version

Due to dba_users.password_versions inconsistency, the version of the client password before upgrade is as follows:

-- query Oracle server password version select d.password_versions from dba_users d

Solution

1. Find the sqlnet.ora file on the database server

/ oracle/app/oracle/product/19.0.0.0/db_1/network/admin/sqlnet.ora

2. If there is a direct modification, there is no direct creation

3. Configuration content: the local PLSQL client is version 8.5, so just configure the version number as 8.

SQLNET.ALLOWED_LOGON_VERSION_SERVER=8SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8

4. Points for attention:

If you don't have a sqlnet.ora file, you can create vi sqlnet.ora directly.

If you can't vi directly, you need to append the sed-a command, otherwise it will lead to garbled ora files.

After adding parameters, there is no need to restart the database or listen, but you need to change the user's password, otherwise an error will be reported.

5. Change the user name and password:

Log in to sqlplus as Oracle user as sysdba

Sqlplus / as sysdba

Modify a user's password

Alter user username identified by new password

Thank you for your reading. The above is the content of "how to solve the problem that Oracle | ORA-28040 low-version clients cannot connect to Oracle 19C". After the study of this article, I believe you have a deeper understanding of how to solve the problem that Oracle | ORA-28040 low-version clients cannot connect to Oracle 19C, and the specific usage needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.