Error 'ORA-28040' when setting up an Oracle data-source to using JDBC connection from Information Designer

Error 'ORA-28040' when setting up an Oracle data-source to using JDBC connection from Information Designer

When setting up a data source in the Information Designer to connect to an Oracle 12c database using a JDBC connection you might come across an error message as shown below:

ORA-28040: No matching authentication protocol 

Cannot connect to data source 'YOUR_DATA_SOURCE_NAME', due to invalid configuration or that the data source is not running. 
Database reported: ORA-28040: No matching authentication protocol

In Oracle 12.1, the default value for the SQLNET.ALLOWED_LOGON_VERSION parameter has been updated to 11. It means that database clients using pre-11g JDBC thin drivers cannot authenticate to 12.1 database servers unless the SQLNET.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.

This is known bug reported in 2.22.13.1 Bug 14575666

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

https://stackoverflow.com/questions/24100117/ora-28040-no-matching-authentication-protocol-exception?utm_medium=organic&utm_source=google_rich_qa&utm_campaign=google_rich_qa