Wednesday, September 30, 2020

If Actual and Target OPP processes do not match EBS

 Check from backend which ones are "ACTIVE"

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


       SID    SERIAL# PROGRAM
---------- ---------- ------------------------------------------------
MODULE                                           STATUS   PROCESS      LOGON_TIM
------------------------------------------------ -------- ------------ ---------
      4748          1 JDBC Thin Client
FNDCPOPP                                         INACTIVE              15-JUL-20
      4750          3 JDBC Thin Client
FNDCPOPP                                         INACTIVE              15-JUL-20
      4753         17 JDBC Thin Client
FNDCPOPP                                         INACTIVE              15-JUL-20

       SID    SERIAL# PROGRAM
---------- ---------- ------------------------------------------------
MODULE                                           STATUS   PROCESS      LOGON_TIM
------------------------------------------------ -------- ------------ ---------
      5769         31 JDBC Thin Client
FNDCPOPP                                         ACTIVE                20-JUL-20
      5773         10 JDBC Thin Client
FNDCPOPP                                         ACTIVE                20-JUL-20
      5780          4 JDBC Thin Client
FNDCPOPP                                         ACTIVE                20-JUL-20

6 rows selected.



select sid,serial#,program,module,status,process,logon_time from v$session where module like'%OPP%'and status='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   20-JUL-20
FNDCPOPP
      5773         10 ACTIVE   20-JUL-20
FNDCPOPP
      5780          4 ACTIVE   20-JUL-20
FNDCPOPP


Check from front end.


Actual and Target processes should both be 3.

No comments:

Post a Comment

Featured post

Migrate OCR & vote from external to normal or High redundancy in ASM

How to Move OCR & Vote from external to Normal or high. 1)  Create New diskgroup(CRS) with suitable redundancy for OCR and Voting files....

Popular Posts