ORA-28040: No matching authentication protocol

0

$FND_TOP/bin/txkrun.pl -script=SetSSOReg -removereferences=yes -appspass=apps

ORA-28040: No matching authentication protocol

Solution:

Bug 14575666

In 12.1, the default value for the SQLNET.ALLOWED_LOGON_VERSION parameter has been updated to 11. This means that database clients using pre-11g JDBC thin drivers cannot authenticate to 12.1 database servers unless theSQLNET.ALLOWED_LOGON_VERSION parameter is set to the old default of 8.

This will cause a 10.2.0.5 Oracle RAC database creation using DBCA to fail with the ORA-28040: No matching authentication protocol error in 12.1 Oracle ASM and Oracle Grid Infrastructure environments.

Workaround: Set SQLNET.ALLOWED_LOGON_VERSION=8 in the oracle/network/admin/sqlnet.ora file.

https://www.ibm.com/mysupport/s/question/0D50z000062khoMCAQ/after-upgrading-to-oracle-12c-database-i-start-getting-ora28040-no-matching-authentication-protocol?language=en_US

SQLNET.ALLOWED_LOGON_VERSION_CLIENT=8 and

SQLNET.ALLOWED_LOGON_VERSION_SERVER=8

Share.

About Author

Leave A Reply