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 SEPTEMBER 06, 2024
Applies to:
Hyperion Planning - Version 11.1.2.1.101 and laterInformation 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:
[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
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 |
Changes |
Cause |
Solution |