SOI Custom Connector cannot connect to Oracle DB

Article Id: 140496

Status: Published

Updated On: 20-11-2019 11:09

Products:

CA Service Operations Insight (SOI)

Issue/Introduction:

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

Environment:

Release : 4.2

Component : Service Operations Insight (SOI) Manager

Oracle: 12C

Resolution:

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