Oracle 12c R2 RAC + ORA-28040

First, the environment

Service side: Oracle 12.2.0.1 RAC

Client: Less than Oracle 11.2.0.3

Second, the phenomenon

When using a less than Oracle 11.2.0.3 client version connection to the Oracle 12.2.0.1 RAC database "Ora-28040:no matching authentication protocol"

Third, solve the problem

Method One: According to the official website explanation, the client connects Oracle 12R2 database must use the 11.2.0.3 version above

Method Two: Create a Sqlnet.ora file (/oracle/app/oracle/product/12.2.0/db/network/admin/sqlnet.ora) in the Listening folder where the Oracle user is located, and add the content:

[email protected] admin]$ cat Sqlnet.ora

Sqlnet. Allowed_logon_version_server=8

Sqlnet. Allowed_logon_version_client=8

Then reboot the monitor and you can.

Comments:

Sqlnet. Allowed_logon_version_server: Control the client version that can be connected to a 12c database

Sqlnet. Allowed_logon_version_client: Control which version of the database the 12c database can connect to

This article is from the "Travel Life" blog, please be sure to keep this source http://felixgzf.blog.51cto.com/4108324/1960848

Oracle 12c R2 RAC + ORA-28040