My Oracle Support Banner

Essbase: Unable to connect to Oracle Database which has Oracle Advanced Security (OAS) Enabled. Getting Error: ODBC Layer Error: [08001] ==> [[DataDirect][ODBC Oracle Wire Protocol driver][Oracle]Connection Dead. This may have occurred because the server (Doc ID 2542519.1)

Last updated on DECEMBER 15, 2020

Applies to:

Hyperion Essbase - Version 11.1.2.4.000 and later
Information in this document applies to any platform.

Symptoms

The Oracle Database used as a data source for Essbase SQL Interface has Oracle Advanced Security (OAS) Enabled.   When trying to connect to the Oracle data source using the Data Load rule file using SQL Interface in Essbase Administration Services (EAS) Console, getting below error in Application Log:

<AppLog TimeStamp>Info(1013091)
Received Command [SQLListDsn] from user [UserName]

<AppLog TimeStamp>/Info(1013091)
Received Command [SQLRetrieve] from user [UserName]

<AppLog TimeStamp>/Info(1021004)
Connection String is generated

<AppLog TimeStamp>/Info(1021041)
Connection String is [DSN=OracleDSN;UID=...;PWD=...;]

<AppLog TimeStamp>/Info(1021006)
SELECT Statement [SELECT * FROM TABLE WHERE CONDITION;] is generated

<AppLog TimeStamp>/Info(1021013)
ODBC Layer Error: [08001] ==> [[DataDirect][ODBC Oracle Wire Protocol driver][Oracle]Connection Dead. This may have occurred because the server requires Oracle Advanced Security. To enable the driver to use OAS, please use the DataIntegrityLevel and/or EncryptionLevel connect options.]

<AppLog TimeStamp>/Info(1021014)
ODBC Layer Error: Native Error code [4294967292]

<AppLog TimeStamp>/Error(1021001)
Failed to Establish Connection With SQL Database Server.  See log for more information

<AppLog TimeStamp>/Warning(1080014)
Transaction [ 0x50001( 0x5cd18159.0x339eb ) ] aborted due to status [1021001].


 

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
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.