Poster: 12032 - OCIServerAttach failed with ORA-12536 (4222534)

Poster: 12032 - OCIServerAttach failed with ORA-12536

Post unable to logon to Oracle

Event_log shows:
Notice   2016-06-01 16:59:43.622648 90111 1089865472 Poster: Session 19 unable to logon to oracle 60 sec  (posting from SOURCE_SID, queue name, to target_sid) [module opo]
Error    2016-06-01 16:58:44.562433 90120 646616928 Poster: Runtime: pthread_create: Resource temporarily unavailable (11).  (posting from SOURCE_SID, queue name, to target_sid) [module opo]
Error    2016-06-01 17:32:35.182877 61661 345180000 Poster: 12032 - OCIServerAttach failed with ORA-12536.  (posting from SOURCE_SID, queue name, to target_sid) [module osp]

Maximum number of SharePlex user processes has reached the OS limit

1. Check v$resource_limit's max_utilization and limit_value values for processes and sessions on target
2. Check select count(*) from shareplex_trans on target
3. Check the maximum number of processes allowed for the SharePlex user (ulimit -u)
4. Adjust the ulimit -u according the values from v$resource_limit and count from shareplex_trans
5. Restart SharePlex

The value for ulimit -u is seen from issuing "ulimit -aH" for hard limit and "ulimit -aS" for soft limit. In addition to checking the ulimit -u, if ulimit -n, the number of open file descriptors is less than recommended value of 8192, bump up to 8192 as Oracle needs 3 file descriptors and SharePlex uses 1/3 of the open file descriptors. In order for SharePlex to recognize a new ulimit setting, SharePlex would have to be restarted. It is recommended to set the ulimit -n and ulimit -u values in the SharePlex user profile.