also go through following oracle support doc
(mark this post as helpful or correct if it helps you !)
try to set as the following
Also let me know what is the PROCESSES parameter in Oracle Database set to?
After set the following at DB server, I've got to deploy the HFM apps successfully
ALTER SYSTEM SET processes=1000 SCOPE=SPFILE; (to all products)
ALTER SYSTEM SET OPEN_CURSORS=5000 SCOPE=SPFILE; ( to Financial Management)
Thank you all for you advices