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

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

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

2. 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