We have a custom SOI connector which is failing to connect to the Oracle DB. This was working fine until the Oracle was upgraded to 12C. The following error appears in the connector log
2019-11-20 07:36:41,524 ERROR [CA:77001_<name>@<hostName>] data.JdbcDataSource - Unable to connect to database using 'jdbc:oracle:thin:@ussauxapps123p.cotyww.com:1525:REDP'.
java.sql.SQLException: ORA-28040: No matching authentication protocol
Release : 4.2
Component : Service Operations Insight (SOI) Manager
Oracle: 12C
Stop catalyst container
CA\Catalyst\CatalystConnector\container\lib
Rename ojdbc14.jar to ojdbc14.jar_original
Download and copy the ojdbc6.jar (or ojdbc8.jar) as suggested by https://stackoverflow.com/questions/24100117/ora-28040-no-matching-authentication-protocol-exception
Start catalyst container