ORA-28040: No matching authentication

Tags: oracle, error, ORA-28040

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.

Sources:

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

http://www.dba-oracle.com/t_ora_12638_credential_retrieval_failed.htm

No Comments

You must log on to comment.