Hyperion Financial Management Application Creation Fails With ORA-12520 Errors
Posted by Priya Doyle on 02 December 2010 08:34 AM
Applies to:Hyperion Financial Management - Version: 22.214.171.124.00 to 126.96.36.199.00 - Release: 9.3 to 11.1
Hyperion Financial Management - Version: 188.8.131.52.00 to 184.108.40.206.00 [Release: 9.3 to 11.1]
Information in this document applies to any platform.
An Enterprise Performance Management Architect (EPMA) type Hyperion Financial Management (HFM) application could not be deployed. The EPMA job library displays the following messages for the attempted deployment job:
Review of the attachment job message shows details similar to the following:
The Oracle instance initialization parameters have not been optimized for the expected number of database connections that will come from HFM application servers.Oracle instance must have the appropriate values configured for the SESSIONS and PROCESSES initialization parameters.
Details for determining appropriate values can be found in the Database Information For Financial Management section of the EPM Installation and Configuration Guide as well as in the HFM Performance Tuning Guide
NOTE:1083460.1 - Hyperion Financial Management (HFM) Performance Tuning Guide, Fusion Edition