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 and later
Information in this document applies to any platform.


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




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.