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 AUGUST 25, 2017

Applies to:

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

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: CW8353ALGE] [nwaddr: 3.101.106.218] [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[[

.
]]

 

Changes

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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms