The queries below will help to confirm how many sessions and processes are in use and which applications the sessions are originating from.
Execute the following queries on the Target database at the time the error occurs:
select count(*) from v$session;
select count(*) from v$process;
select sid, username, program from v$session where program like '%sp_opst%' and module like '%Post%';
The number of processes will need to be increased in the init.ora.
Once the change is made restart the database to implement the change.
SharePlex requirements for Oracle PROCESSES and SESSIONS setting:
The minimum requirement for MTP (Multithread Post) is to set SP_OPO_THREADS_MAX + one for the global connection.
Prior to SharePlex 9.2.8 the default value for this parameter was 65.
From SharePlex 9.2.8 onwards the default value for this parameter is 128.
The change takes effect when MTP Post is restarted.
This setting can be reviewed in the Target environment as follows:
sp_ctrl> list param all post
