Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
http://www.free-online-exams.com
Problem: All the
Concurrent requested were in pending state and not being
processed
Bounce CM gave the below:
Routine &ROUTINE has attempted to start the
internal concurrent manager. The ICM is already running. Contact you system
administrator for further assistance.afpdlrq received an unsuccessful result
from PL/SQL procedure or function
FND_DCP.Request_Session_Lock.
Routine FND_DCP.REQUEST_SESSION_LOCK received a result code of 1 from the call to DBMS_LOCK.Request.Possible DBMS_LOCK.Request resultCall to establish_icm failed The Internal Concurrent Manager has encountered an error.
Routine FND_DCP.REQUEST_SESSION_LOCK received a result code of 1 from the call to DBMS_LOCK.Request.Possible DBMS_LOCK.Request resultCall to establish_icm failed The Internal Concurrent Manager has encountered an error.
Solution:
For a high transaction environment, that's why the
Purge concurrent program has to be scheduled to run daily or at least
weekly
To avoid running out of space on your disk drives, you
should periodically
delete Oracle Applications log files, output files and purge these tables
with the FNDCPPUR program.
The FNDCPUR purge program maintains the number of log and output files the
operating system retains, and manage tables that store information about
concurrent requests and concurrent manager processes.
You can run the program FNDCPPUR once and automatically resubmit the program
for your specific time intervals.
It is a highly recommended step to improve the performance of the concurrent managers
Oracle Applications System Administrator’s Guide - Maintenance Release 11i (Part No. B13924-04)
Note 565942.1 Which Table Column And Timing Period Does The FNDCPPUR Purge Program Use
schedule The FNDCPPUR Purge Program to be run daily or at least weekly
re-monitor the pending issue and feedback
delete Oracle Applications log files, output files and purge these tables
with the FNDCPPUR program.
The FNDCPUR purge program maintains the number of log and output files the
operating system retains, and manage tables that store information about
concurrent requests and concurrent manager processes.
You can run the program FNDCPPUR once and automatically resubmit the program
for your specific time intervals.
It is a highly recommended step to improve the performance of the concurrent managers
Oracle Applications System Administrator’s Guide - Maintenance Release 11i (Part No. B13924-04)
Note 565942.1 Which Table Column And Timing Period Does The FNDCPPUR Purge Program Use
schedule The FNDCPPUR Purge Program to be run daily or at least weekly
re-monitor the pending issue and feedback
References:
Note:134033.1 ANALYZEPENDING.SQL - Analyze all Pending
Requests
No comments:
Post a Comment