28
Apr

Actual and Target OPP Processes do not match

If the processes do not match for Output Post Processor

CONCURRENT_QUEUE_NAME RUNNING_PROCESSES TARGET_PROCESSES MAX_PROCESSES MIN_PROCESSES
-------------------- ----------------- ---------------- ------------- -------------
FNDCPOPP 6 3 3 3


Check Internal Manager log

Starting FNDCPOPP Concurrent Manager : 14-APR-2015 17:26:18
Starting FNDCPOPP Concurrent Manager : 14-APR-2015 17:26:18
Starting FNDCPOPP Concurrent Manager : 14-APR-2015 17:26:18
Process monitor session started : 15-APR-2015 14:05:45
Internal Concurrent Manager found node APPROD to be down. Adding it to the list of unavailable nodes.
Internal Concurrent Manager found node DBPROD to be down. Adding it to the list of unavailable nodes.
CONC-SM TNS FAIL
Call to PingProcess failed for XDPCTRLS
CONC-SM TNS FAIL
Call to PingProcess failed for XDPQORDS

Call to PingProcess failed for FNDOPP
CONC-SM TNS FAIL
Call to PingProcess failed for FNDOPP
CONC-SM TNS FAIL
Call to PingProcess failed for FNDOPP

Starting FNDCPOPP Concurrent Manager : 15-APR-2015 14:08:11
Starting FNDCPOPP Concurrent Manager : 15-APR-2015 14:08:11
Starting FNDCPOPP Concurrent Manager : 15-APR-2015 14:08:12


3 OPP processes got killed from oracle because of network disconnect but were still running on OS.
Internal Manager started the managers which were down.
It shows 6 in Actual because 3 OS processes were there and then internal manager started 3 processes again.

Check from backend which ones are "ACTIVE"

SQL> select sid,serial#,program,module,status,logon_time from v$session where module like'%OPP%';

SID SERIAL# PROGRAM MODULE STATUS LOGON_TIM
------ ------- --------- ------- ------- ----------
4748 1 JDBC Thin Client FNDCPOPP INACTIVE 15-APR-15

4750 3 JDBC Thin Client FNDCPOPP INACTIVE 15-APR-15

4753 17 JDBC Thin Client FNDCPOPP INACTIVE 15-APR-15

5769 31 JDBC Thin Client FNDCPOPP ACTIVE 14-APR-15

5773 10 JDBC Thin Client FNDCPOPP ACTIVE 14-APR-15

5780 4 JDBC Thin Client FNDCPOPP ACTIVE 14-APR-15


6 rows selected.


Kill sessions that are inactive.

ALTER SYSTEM KILL SESSION 'sid,serial#' IMMEDIATE;

alter system kill session '4748,1' immediate;
alter system kill session '4750,3' immediate;
alter system kill session '4753,17' immediate;


SQL> select sid,serial#,status,logon_time,module from v$session where module like'%OPP%';

SID SERIAL# STATUS LOGON_TIM MODULE
--- ------- ------- --------- ------
5769 31 ACTIVE 14-APR-15 FNDCPOPP

5773 10 ACTIVE 14-APR-15 FNDCPOPP

5780 4 ACTIVE 14-APR-15 FNDCPOPP


Check from front end.

Actual and Target processes should both be 3.

Back to Top