Shulou(Shulou.com)05/31 Report--

This article mainly explains "how to solve the error of ORACLE 12C connecting Times ORA28040 and ORA01017". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Next, let the editor take you to learn how to solve the error of ORACLE 12C connecting Times ORA28040 and ORA01017.

[1] Environmental description

1.1 Oracle server version: 12.2.0.1

1.2 Oracle client version: 11.2.0.1

[2] problem description

2.1 the client reports an error in ORA-28040 when connecting to the server.

2.2 an error was reported when the client connected to ORA-01017.

[3] solution

3.1 Solutions to ORA-28040 errors:

For oracle/network/admin/sqlnet.ora on the database server, add the following

[ALLOWED_LOGON_VERSION_SERVER=8SCOTT 10G 11G 12C # requires the client to have a minimum version of 10

How did version 4.3 PASSWORD_VERSIONS come into being?

The birth of PASSWORD_VERSIONS is a parameter of the above sqlnet.ora: SQLNET.ALLOWED_LOGON_VERSION_SERVER. When SQLNET.ALLOWED_LOGON_VERSION_SERVER sets different values, the corresponding password_versions is generated.

So when SQLNET.ALLOWED_LOGON_VERSION_SERVER=8, the corresponding value of PASSWORD_VERSIONS is 10G 11G 12C

The corresponding value of SQLNET.ALLOWED_LOGON_VERSION_SERVER=8,PASSWORD_VERSIONS is 11G 12C

At this point, I believe you have a deeper understanding of "how to solve the error of ORACLE 12C connecting Times ORA28040 and ORA01017". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

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.