Products | Versions |
---|---|
TIBCO Administrator | 5.10 |
While trying to connect to Oracle 12c, the following error is reported.
===========================
java.sql.SQLException: ORA-28040: No matching authentication protocol
===========================
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. ----------------------------------------->