ODBC Layer Error: [S1000] ==> [[DataDirect][ODBC Oracle Wire Protocol driver]Cannot open TNS Names file]

(Doc ID 1597656.1)

Last updated on APRIL 06, 2018

Applies to:

Hyperion Essbase - Version 9.3.1.0.00 to 11.1.2.4.014 [Release 9.3 to 11.1]
Linux x86-64

Symptoms

While Connecting to SQL Database from EAS Console it throws below error:

[Mon Nov  4 11:35:56 2013]Local/application/database/710542@Native Directory/7457/Info(1021006)
SELECT Statement [SELECT * FROM STG_HRMS] is generated

[Mon Nov  4 11:35:56 2013]Local/application/database/710542@Native Directory/7457/Info(1021013)
ODBC Layer Error: [S1000] ==> [[DataDirect][ODBC Oracle Wire Protocol driver]Cannot open TNS Names file.]

[Mon Nov  4 11:35:56 2013]Local/application/database/710542@Native Directory/7457/Info(1021014)
ODBC Layer Error: Native Error code [0]

[Mon Nov  4 11:35:56 2013]Local/application/database/710542@Native Directory/7457/Error(1021001)
Failed to Establish Connection With SQL Database Server.  See log for more information

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