My Oracle Support Banner

Essbase Rules File SQL Connection Can Not Connect To Oracle 19c Database When Using OCI Connection (Doc ID 3026143.1)

Last updated on JUNE 07, 2024

Applies to:

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

Symptoms

After upgrade of Oracle Database from 12c to 19c, Essbase Rules File SQL Interface can no longer connect to the Oracle database. An encrypted connection to Oracle is being used.

Following error is displayed: Error: 1021001 Failed to Establish Connection With SQL Database Server. See log for more information

In the Essbase application log following error is found: ORA-28040: No matching authentication protocol

Changes

 

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
Changes
Cause
Solution
References


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