Java doesn’t come up after oracle 12c upgrade ,We get ORA-28040 No matching authentication Protocol error.
Error :Below error we’ll get in Java trace logs under work directory.
com.sap.engine.frame.core.configuration.ConfigurationException: Error while connecting to DB.
com.sap.engine.core.configuration.impl.persistence.rdbms.DBConnectionPool.createConnection(DBConnectionPool.java:384)
Caused by: java.sql.SQLException: ORA-28040: No matching authentication protocol
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113) “
This is known Bug in Oracle as per 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 the
SQLNET.ALLOWED_LOGON_VERSION parameter is set to the old default of 8.
Please follow below steps in order to fix this error:
1> Revert back to old oracle client 11x.
2> Change the 11x drive location from configtool and from OS level all places.
3> Add parameter SQLNET.ALLOWED_LOGON_VERSION_SERVER = 8 in sqlnet.ora and bounce the system. (referred SAP Note ###2218723 – ORA-28040 No matching authentication protocol: AS Java fails after DB upgrade)