My Oracle Support Banner

Essbase: Essbase is Not Starting in Failover Mode When Using Oracle 12.2 database, Error ORA-01017: invalid username/password; logon denied (Doc ID 2534404.1)

Last updated on JANUARY 28, 2021

Applies to:

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

Symptoms

Oracle 12.2 is the version of the Foundation services Database.  
Essbase has been configured in failover mode.
Starting Essbase throws below errors in leasemanager log.

leasemanager_essbase_host.log

Issue #1

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

Issue #2
[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-01017: invalid username/password; logon denied].
[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-01017: invalid username/password; logon denied].
[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-01017: invalid username/password; logon denied].
[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-28000: the account is locked].

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
References


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