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

PLSQL connects to Oracle 12c server via Oracle 11g client error ORA-28040

Environment description:

Oracle server-side version: oracle 12.2.0.1.0

Oracle client version: oracle 11.2.0.1.0

PLSQL is 11.4

Because PLSQL also connects to the database through the Oracle client, using the 11g client to access oracle 12c should also get the following error:

C:\ Users\ Administrator > sqlplus sys/abcd@shardcat as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on Sat Dec 20 22:22:07 2014Copyright (c) 1982, 2010, Oracle. All rights reserved.ERROR:ORA-28040: No matching authentication protocol

View a detailed description of the error:

[oracle@shard1 admin] $oerr ora 2804028040, 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.

View the table on the server side: dba_users,PASSWORD_VERSIONS column is: 11G 12C

SQL > select username, account_status,password_versions from dba_users where account_status='OPEN' USERNAME ACCOUNT_STATUS PASSWORD_VERSIONS -SYS OPEN 11G 12CSYSTEM OPEN 11G 12CGSMCATUSER OPEN 11G 12CJY OPEN 11G 12CMYGDSADMIN OPEN 11G 12CAPP_SCHEMA OPEN 11G 12C6 rows selected.

Server side: modify sqlnet.ora configuration: (after configuration modification, there is no need to restart the oracle server) here is the newly created sqlnet.ora, because it was not created originally

[oracle@shard1 admin] the total amount of $ls-lrt is 12, RW, RW, and lrt. 1 oracle oinstall 1441 August 28 2015 shrept.lstdrwxr-xr-x. 2 oracle oinstall 61 October 12 2017 samples-rw-r-. 1 oracle oinstall 960 January 18 2018 tnsnames.ora-rw-r--r-- 1 oracle oinstall 504 February 17 12:58 listener.ora [oracle@shard1 admin] $vi sqlnet.oraSQLNET.ALLOWED_LOGON_VERSION_SERVER=11SQLNET.ALLOWED_LOGON_VERSION_CLIENT=11

Client: try to connect again, prompting the user name and password error:

C:\ Users\ Administrator > sqlplus sys/abcd@shardcat as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on Sat Dec 20 22:16:06 2014Copyright (c) 1982, 2010, Oracle. All rights reserved.ERROR:ORA-01017: invalid username/password; logon denied

After modifying the server-side sqlnet.ora, you need to log in to sqlplus again, and then change the user's password, otherwise, after changing the user's password, the marked password version is still 11G 12C; log in to sqlplus again, change the scott user's password, and check PASSWORD_VERSIONS, adding a 10G

[oracle@shard1] $sqlplus sys/abcd@shardcat as sysdbaSQL*Plus: Release 12.2.0.1.0 Production on Mon Feb 17 13:07:28 2020Copyright (c) 1982, 2016, Oracle. All rights reserved.Connected to:Oracle Database 12c Enterprise Edition Release 12.2.0.1.0-64bit ProductionSQL > alter user sys identified by "abcd"; User altered.SQL > select username, account_status,password_versions from dba_users where account_status='OPEN' USERNAME ACCOUNT_STATUS PASSWORD_VERSIONS -SYS OPEN 10G 11G 12CSYSTEM OPEN 11G 12CGSMCATUSER OPEN 11G 12CJY OPEN 11G 12CMYGDSADMIN OPEN 11G 12CAPP_SCHEMA OPEN 11G 12C6 rows selected.

Client: try to log in to oracle 12c again, successfully:

C:\ Users\ Administrator > sqlplus sys/abcd@shardcat as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on Sat Dec 20 22:22:39 2014Copyright (c) 1982, 2010, Oracle. All rights reserved.Connected to:Oracle Database 12c Enterprise Edition Release 12.2.0.1.0-64bit ProductionSQL >

Summary: when the oracle11g client connects to the oracle 12c server, you need to configure sqlnet.ora on the server side and change the user password again.

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.