EPM System Diagnostics report shows error for Essbase / Essbase Administration Services: java.sql.SQLException: Listener refused the connection with the following error: ORA-12514 (Doc ID 2247868.1)

Last updated on MARCH 28, 2017

Applies to:

Hyperion Essbase Administration Services - Version 11.1.2.4.000 and later
Information in this document applies to any platform.

Symptoms

When running EPM System diagnostics the validation report shows following error in the Essbase / Essbase Administration Services section:

FAILED   REG: Datasource   Datasource Checking if datasource property exists in the registry
Error: 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
Recommended Action: Check database configuration
FAILED  DB: Database Connectivity  Checking connection to database jdbc:oracle:thin:@clarityscan.global.ldap.wan:1531/HFMPROD.global.ldap.wan
Error: Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
Recommended Action: Check database configuration

 

It has been confirmed the database being used for EAS is running and is reachable from a SQL client.





Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms