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 MAY 21, 2021

Applies to:

Symptoms

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: <hostname>] [nwaddr: <nwaddr>] [tid: <tid>] [userId: <userid>] [ecid: <ecid>] [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[[

.
]]

Changes

The database used for the Essbase Studio catalog tables had recently been upgraded to the Oracle 12c database.

Cause

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