JAVA Dosn’t start after oracle 12c upgrade with ORA-28040 No matching authentication Protocol error

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.bootstrap.SynchronizationException: Database initialization failed! Check database properties!
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)







Leave a Reply

Your email address will not be published. Required fields are marked *