TNS:listener could not resolve SERVICE_NAME given in connect descriptor (Doc ID 2224111.1)

Last updated on AUGUST 08, 2017

Applies to:

Hyperion BI+ - Version 11.1.2.3.500 and later
Information in this document applies to any platform.

Symptoms

During the creation of a new ODBC data source for Hyperion IR, getting problems connecting to the database using the Data Direct 7.0 Drivers.
The error received is:

[Oracle][ODBC Oracle Wire Protocol driver][Oracle]TNS-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor (-1)

Changes

Recently migrated from 10g single instance to 12c RAC on Exadata

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