Error Starting Essbase "[DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-28040: No matching authentication protocol]" (Doc ID 2634614.1)

Last updated on NOVEMBER 10, 2022

Applies to:

Symptoms

Unable to connect to Essbase when configured on a Failover mode.

Essbase version 11.1.2.4 and Oracle Database 19c Enterprise Edition Release Version 19.3.0.0.0(12.2.0.3)

The leasemanager_essbase_<HOSTNAME>.log has the below errors:

[Timestamp] [ESSBASE0] [NOTIFICATION:16] [LM-39] [LM] [ecid: ] [tid:] Lease Database Connection Information:
[Timestamp] [ESSBASE0] [NOTIFICATION:16] [LM-41] [LM] [ecid: ] [tid:] ODBC Driver [DataDirect 7.1 Oracle Wire Protocol]
[Timestamp] [ESSBASE0] [NOTIFICATION:16] [LM-40] [LM] [ecid: ] [tid:] Host [<HOSTNAME>] and port [<PORT>]
[Timestamp] [ESSBASE0] [NOTIFICATION:16] [LM-42] [LM] [ecid: ] [tid:] Service Name [<SERVICE NAME>]
[Timestamp] [ESSBASE0] [NOTIFICATION:16] [LM-44] [LM] [ecid: ] [tid:] User [<USER>]
[Timestamp] [ESSBASE0] [NOTIFICATION:16] [LM-9] [LM] [ecid: ] [tid:] Attempt to connect to database failed with error [[DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-28040: No matching authentication protocol]
[Timestamp] [ESSBASE0] [NOTIFICATION:16] [LM-9] [LM] [ecid: ] [tid:] Attempt to connect to database failed with error [[DataDirect][ODBC Oracle Wire Protocol driver][Oracle]TNS-12505: TNS:listener could not resolve SID given in connect descriptor]
[Timestamp] [ESSBASE0] [NOTIFICATION:16] [LM-1] [LM] [ecid: ] [tid:] Failed to acquire the lease after [6] consecutive attempts
[Timestamp] [ESSBASE0] [NOTIFICATION:16] [LM-16] [LM] [ecid: ] [tid:] Lease is being surrendered
[Timestamp] [ESSBASE0] [NOTIFICATION:16] [LM-11] [LM] [ecid: ] [tid:] Preparing to shutdown abort
[Timestamp] [ESSBASE0] [NOTIFICATION:16] [LM-12] [LM] [ecid: ] [tid:] Terminating the process.

Cause

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