12c Database: perl adcfgclone.pl appsTier : RC-40201: Unable to connect to Database

12c Database: perl adcfgclone.pl appsTier : RC-40201: Unable to connect to Database

CloneContext_***.log Shows the Message: Exception occurred: java.sql.SQLException: ORA-28040: No matching authentication protocol

Environment: 12.1.3 Applications with 12c Database (12.1.0.2)

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.

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

Scroll to Top