Oracle 12c Bug 14575666 "java.sql.SQLException: ORA-28040: No matching authentication protocol"

Oracle 12c Bug 14575666 "java.sql.SQLException: ORA-28040: No matching authentication protocol"

book

Article ID: KB0083912

calendar_today

Updated On:

Products Versions
TIBCO Administrator 5.10

Description

While trying to connect to Oracle 12c, the following error is reported. 
===========================
java.sql.SQLException: ORA-28040: No matching authentication protocol
===========================

Issue/Introduction

"java.sql.SQLException: ORA-28040: No matching authentication protocol" error while connecting to Oracle 12c .

Environment

Windows, Administrator 5.10, TRA 5.10, Oracle 12c

Resolution

This is an Oracle bug :
<--------------------------------------------
Bug ID : 14575666
Description : 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.
----------------------------------------->

Additional Information

https://docs.oracle.com/database/121/READM/chapter12102.htm#READM266

Go to : 2.22.13 Oracle Real Application Clusters (Oracle RAC) Known Bugs

2.22.13.1 Bug 14575666


 
Powered by Wolken Software