Web Viewer 12.1 cannot connect to an Oracle 12c or 12g database. When using the configuration tool, the database connection test fails. The ConfigTool.log shows an exception with message:
Loaded: ojdbc14.jar
java.sql.SQLException: ORA-28040: No matching authentication protocol
When accessing Web Viewer, the web login page reports error
Database connection can not be established. Contact your System Administrator.
The wvtrace.log shows an exception with the same message:
Internal Exception: java.sql.SQLException: ORA-28040: No matching authentication protocol
The problem is caused by an older Oracle JDBC JAR file delivered with Web Viewer.
RO87675 CUMULATIVE BUILD 137 FOR V12.1 or higher contains support for Oracle Database 12c and 12g. Install the latest cumulative build to receive this solution and all security fixes.
Deleting this JAR file (in two places) resolves the problem.
For the Configuration Tool:
For Web Viewer (web interface):
Please note that after maintenance is applied and/or you re-deploy the WAR/EAR file, you must perform the circumvention again as the maintenance will restore the deleted file.