Oracle Performance Enterprise Management (EPM) Server Service no longer Starts After Installing ODI with Error:"database connectivity could not be established. Oracle.DataAccess.Client.OracleException" (Doc ID 1427027.1)

Last updated on JULY 28, 2016

Applies to:

Hyperion Planning - Version 11.1.2.1.101 and later
Information in this document applies to any platform.
6.16.15

Symptoms

EPMA Server Dimension Server and Web Tier are Installed on 64 Bit and everything working Fine before the Install of ODI. After Install of ODI on 64 Bit, the EPMServer (Dimension Server) no longer starts with the following error in the Windows Event Viewer:

 
EPM Server Process:

[EPMA Server Startup] ERROR SVR_ERR_PROCESSMGR_CANT_INIT_SESSIONMGR:Cannot initialize the Session Manager.Hyperion.DimensionServer.Interface.Exceptions.EPMAServiceException: Cannot initialize the Session Manager. --Hyperion.CommonServices.Exceptions.SessionManagerException: Session Manager could not start because database connectivity could not be established. Oracle.DataAccess.Client.OracleException at Hyperion.DimensionServer.SessionManager.SessionManager.InitializeSqlConnectionString()--- End of inner exception stack trace ---
at Hyperion.DimensionServer.SessionManager.SessionManager.InitializeSqlConnectionString()

at Hyperion.DimensionServer.SessionManager.SessionManager.Initialize(String configFileName, Boolean restorePastInstanceSessions, Boolean enableCaching)

--- End of inner exception stack trace ---
at Hyperion.DimensionServer.Service.Main.InitializeSessionManager()
at Hyperion.DimensionServer.Service.Main.Start()

Hyperion EPMA Dimension Server:

 

Service cannot be started. Hyperion.DimensionServer.Interface.Exceptions.EPMAServiceException: Cannot initialize the Session Manager. ---
Hyperion.CommonServices.Exceptions.SessionManagerException: Session Manager could not start because database connectivity could not be established. ---Oracle.DataAccess.Client.OracleException at Hyperion.DimensionServer.SessionManager.SessionManager.InitializeSqlConnectionString()

End of inner exception stack trace
at Hyperion.DimensionServer.SessionManager.SessionManager.InitializeSqlConnectionString()
at Hyperion.DimensionServer.SessionManager.SessionManager.Initialize(String configFileName, Boolean restorePastInstanceSessions, Boolean enableCaching)

End of inner exception stack trace
at Hyperion.DimensionServer.Service.Main.InitializeSessionManager()
at Hyperion.DimensionServer.Service.Main.Start()
at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)

For more information, see Help and Support Center at

 

Changes

ODI (32 Bit) was installed on the same server as EPMA

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