My Oracle Support Banner

Creating Hyperion Interactive Reporting OCE Returns Error: "ORA-12154: TNS: could not resolve the connect identifier specified" (Doc ID 1301177.1)

Last updated on MARCH 25, 2021

Applies to:

Hyperion BI+ - Version and later
Information in this document applies to any platform.
***Checked for relevance on 11-Oct-2012***


In Hyperion Interactive Reporting (, when attempting to create an OCE using an ODBC Oracle data source, the following error occurs:

SQL API: [SQLConnectW], SQL RETURN: [-1], SQL STATE: [08004], SQL NATIVE ERROR: [12154], SQL MESSAGE: [[Oracle][ODBC][Ora]ORA-12154: TNS: could not resolve the connect identifier specified]


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

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