10.3 Enterprise Manager installer fails to connect to Oracle 12.2 database with message "ORA-28040: No matching authentication protocol"

Document ID : KB000009135
Last Modified Date : 18/02/2018
Show Technical Document Details
Issue:

10.3 Enterprise Manager (EM) installer fails to connect to Oracle 12.2 database with message:

ORA-28040: No matching authentication protocol

Environment:
APM EM 10.3Oracle Database 12.2
Cause:

To be compatible with both Oracle 11g and 12c the EM installer and the EM itself use the Oracle 11g JDBC driver file ojdbc6.jar. That driver is using an Oracle 11 auth type connection to the Oracle database.

Resolution:

Adding this line to the Oracle Database Server sqlnet.ora file will allow the Oracle 11 auth type connection to the Oracle 12c database:

SQLNET.ALLOWED_LOGON_VERSION_SERVER=11

Additional Information:
  1. To date this problem has only been encountered with Oracle 12.2 and not with Oracle 12.1
  2. Oracle Database 12c Release 2 / Administration / Oracle Database Net Services Reference > Parameters for the sqlnet.ora File
  3. The 10.5.x EM installer has similar problem but the error message is "ORA-12505, TNS:listener does not currently know of SID given in connect descriptor". See KB TEC1129267 10.5.x Enterprise Manager installer fails to connect to Oracle 12.2 database with message "ORA-12505, TNS:listener does not currently know of SID given in connect descriptor"