Error "ORA-28040: No matching authentication protocol" in RmiServer.log after upgrading to Oracle 12c

Document ID : KB000087426
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Error Message :
ErrorMsg: AwE-5001 Database Query Error (11/19/16 11:13 PM)
Details: getConnection
null
java.sql.SQLException: ORA-28040: No matching authentication protocol

After upgrading the Oracle database to version 12c, the RMI process fails to start. The RmiServer.log shows the below errors.
 
ErrorMsg: AwE-5001 Database Query Error (01/01/16 11:11PM)
Details: getConnection
null
java.sql.SQLException: ORA-28040: No matching authentication protocol

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.O3log.receive1st(O3log.java:410)
at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:260)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:368)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:549)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:349)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.appworx.server.sql.AxConnectionPool.getConnection(AxConnectionPool.java:375)
at com.appworx.server.sql.DBAccess.getConnection(DBAccess.java:1490)
at com.appworx.server.sql.CommonDB.A(CommonDB.java:564)
at com.appworx.server.sql.CommonDB.A(CommonDB.java:540)
at com.appworx.server.sql.CommonDB.getSqlData(CommonDB.java:182)
at com.appworx.server.data.MasterDB.<init>(MasterDB.java:213)
at com.appworx.server.data.MasterDB.<init>(MasterDB.java:188)
at com.appworx.server.data.Master.<init>(Master.java:207)
at com.appworx.server.data.AxRmiServer.Å(AxRmiServer.java:3011)
at com.appworx.server.data.AxRmiServer.setupMasters(AxRmiServer.java:2864)
at com.appworx.server.data.AxRmiServer.main(AxRmiServer.java:916)
Environment:
OS Version: N/A
Cause:
Cause type:
By design
Root Cause: Unlike Applications Manager version 9, version 8 was not written for Oracle 12c.
Resolution:
This error can have two causes.
  1. It can be thrown because Applications Manager 8 is not compatible with Oracle 12c. Upgrading Applications Manager to version 9 resolves this problem.
OR
  1. If you are on version 9 of Applications Manager look in the master's $AW_HOME/web/classes directory. If there is still an ojdbc14.jar file in that directory remove it totally from the instance.


Fix Status: No Fix

Fix Version(s):
N/A
Additional Information:
Workaround :
N/A