Getting "out of process memory when trying to allocate" even after applying TEC535005

Products

• CA eHealth

Issue/Introduction

Problem:

Getting Oracle "out of process memory when trying to allocate" errors even after applying TEC535005

Cause:

Sometimes even after applying the Oracle tuning in TEC535005 you can still get Oracle "Out of processes memory when trying to allocate" errors causing failures in eHealth and/or eHealth jobs. 

Resolution:

Decrease the Oracle parameter parallel_max_server by 1/2.

sqlplus "[email protected]_CONNECT_STRING/ehealth as sysdba"

SQL> show parameter parallel_max_servers

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
parallel_max_servers                 integer     32

SQL> alter system set parallel_max_servers = 16 scope=both;

System altered.

SQL>quit

C:> 

Environment

Release: LHDEVC99000-6.3-eHealth-Live Health Upgrade Elements
Component: