SOI Custom Connector cannot connect to Oracle DB

book

Article ID: 140496

calendar_today

Updated On:

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