My Oracle Support Banner

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 SEPTEMBER 10, 2019

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:@<HOST>:<PORT>/<DOMAIN_NAME>
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.





Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.