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 OCTOBER 24, 2023

Applies to:

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

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