My Oracle Support Banner

ERD Run Fails With Error "ERROR:ORA-12504: TNS:Listener Was Not Given The SERVICE_NAME In CONNECT_DATA" (Doc ID 1272517.1)

Last updated on DECEMBER 03, 2019

Applies to:

Primavera Data Warehouse - Version 6.2 to R1 [Release 6.2 to R1]
Information in this document applies to any platform.


The following connection error is encountered during the Reporting Database connection configuration or in the Etlprocess.log or Incremental.log files:

"ERROR:ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA"


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
 Solution for Cause #1
 Solution for Cause #2 - Listener Validation/Configuration
 Solution for Cause #3 - Database may not be Open

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