Clarity app error ORA-12514 Connection refused

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

The Clarity servers have all stopped accessing the database with error:

FATAL 2021-08-27 11:27:43,442 [ProcessEngineMonitor] union.persistence (clarity:unknown:-1:none) Failed to initialize Context properties
java.sql.SQLNonTransientConnectionException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-12514 Connection refused, the specified service name (clarity) was not recognized by the Oracle server.
at com.ca.clarity.jdbc.oraclebase.ddcj.a(Unknown Source)
at com.ca.clarity.jdbc.oraclebase.ddcj.b(Unknown Source)
at com.ca.clarity.jdbc.oraclebase.ddcj.a(Unknown Source)
at com.ca.clarity.jdbc.oraclebase.ddcj.a(Unknown Source)
at com.ca.clarity.jdbc.oracle.OracleImplConnection.a(Unknown Source)

Environment

Release : Any

Component : CLARITY INTEGRATIONS & INSTALLATIONS

Resolution

• Connect to CSA and ensure the details in Server - Database are correct
• Ensure you are able to connect via SQL Developer
• Engage your DBA to help resolve the issue