Event_log errors:
shs_alloc_stat (1): Failed with error shs_ALLALLOCED: no more memory to allocate [sp_opst_mt(shs), Error: 12035 - OCISessionBegin failed with ORA-20,Notice: ORA-00020: maximum number of processes () exceeded. [sp_opst_mt(osp).
This maybe caused by Bug related to the SP_OPO_IDLE_LOGOUT mechanism not taking effect.
WORKAROUND:
One way to ensure that all idle sessions are logged out is to allow all messages in the post queue to be fully consumed. In other words, stop import until such time that "qstatus" reveals unchanging values for the post queue, and wait for evidence of the logging off of idle sessions to appear in the event_log before starting import.
STATUS:
Issue fixed in version 5.3.2. The latest version of Shareplex for Oracle can be downloaded at: https://support.quest.com/shareplex/download-new-releases
SP_OPO_IDLE_LOGOUT functionality
