Clarity app error ORA-12514 Connection refused

book

Article ID: 222803

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS STARTER PACK-CLARITY PPM

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