Reporter node has sql exception while connecting to Oracle DB

Products

• CA Automic Dollar Universe

Issue/Introduction

We are running 6.10.41 version of Dollar Universe. We had Oracle migration to of the DB to Exadata post which we see that the reporter node not working and failing with below error:

[ERROR] XXX [RestartTimer2] com.orsyp.reppub.server.manager.continuous.ContinuousIntevalExecutionQueue -
com.orsyp.reppub.common.exception.PersistenceException: Database communication error: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

Why reporter doesn't show any notification?

How do we fix this error?

Environment

Release : 6.X

Component : REPORTER SERVER

Resolution

The error below in the logs, state that reporter is having an issue while connecting to DB.

ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

[ERROR] 01 Nov 2021 01:06:38 [class com.orsyp.reppub.server.manager.continuous.ContinuousIntevalExecutionQueue 2] com.orsyp.reppub.server.manager.db.rep.RepExtSourceStatusConsolidatedPMImpl - 
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

In case of connectivity failure, reporter will not alerts or notify explicitly, however the status of the same should be validate on UVC -> Administration->Nodes. The reporter will stop reporting or saving data to DB in case of DB connectivity failure.

Resolving Reporter connectivity issue

1: Please validate reporter database settings as express in document. (applicable for all DB types)

2: In case if there is any DB upgrade or server migration please validate connection viability

         Oracle:

• • sqlplus "user/pass@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=hostname.network)(Port=1521))(CONNECT_DATA=(SID=remote_SID)))"
  • OR (alternative syntax) sqlplus user/password@//hostname:port/service_name

3: Oracle only: Oracle DB can be connected either via service-name or SID. Please use appropriate configuration based on your DB configuration

• When selected Use Oracle Service URL=Yes the value in DBID or DB Instance Id (on UVC UI) is used as Oracle service name.
• When selected Use Oracle Service URL=No the value in DBID or DB Instance Id (on UVC UI)is used as Oracle SID.

4: Post validating above configuration, restart the reporter and validate connectivity to DB.