Essbase Studio log shows error during startup: Unable to establish connection to Oracle server: ORA-01017: invalid username/password; logon denied
(Doc ID 2298800.1)
Last updated on JANUARY 25, 2019
Applies to:Hyperion Essbase Studio - Version 18.104.22.168.000 and later
Information in this document applies to any platform.
When attempting to start up Essbase Studio, it fails and following error was shown in /Oracle/Middleware/user_projects/epmsystem1/diagnostics/logs/EssbaseStudio/server.log:
[2017-07-24T10:40:47.648-04:00] [hyperion] [ERROR] [ESSSTD-145015] [com.hyperion.cp.driver] [host: CW8353ALGE] [nwaddr: 22.214.171.124] [tid: 10] [userId: system] [ecid: 0000Lpp2hzX5Qd9xZc5Egb1PTWRX000001,0] [SRC_CLASS: com.hyperion.cp.driver.adapters.sql.oracle.OracleConnection] [SRC_METHOD: createSQLConnection] Unable to establish connection to Oracle server: ORA-01017: invalid username/password; logon denied[[
The database used for the Essbase Studio catalog tables had recently been upgraded to the Oracle 12c database.
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