Database Blog

Concurrent Request completed with “sqlldr : Permission denied” error

While running the Concurrent Request it has completed with the following Error. Arguments ———— /testapps/apps/apps_st/appl/doyen/12.0.0/Interfaces/DOYENINBOUND/doyen2.csv sqlldr: Permission denied usdsop: exec failed during spawnusdsop cannot write to pipe Cause: usdsop attempted…

Read More

While cloning R12 instance apps Tier Error occurs at 3% after running adcfgclone.pl

Error: ====== ouicli.pl               INSTE8_APPLY       -1 The following report lists errors AutoConfig encountered during each phase of its execution.  Errors are grouped by directory and phase. The report format is:      …

Read More

Script to disable all scheduled requests – After cloning

update fnd_concurrent_requests set phase_code=’C’, status_code=’D’ where phase_code = ‘P’ and (status_code = ‘I’ OR status_code = ‘Q’); and requested_start_date >= SYSDATE and hold_flag = ‘N’;

Read More

Steps to debug “Not able to view Concurrent request Output “

When we try to view the concurrent request output or log files we would get the following Error:  ” An error occurred while attempting to establish an Applications File  Server…

Read More

To check the Size of RAM in Unix

HP-UX swapinfo –tm Linux free –m free -g AIX lsdev -C|grep mem Solaris prtconf|grep -i mem

Read More

To check number of CPU’s in the server

Linux cat /proc/cpuinfo | grep “processor”|wc –l HP-UX ioscan -C processor | grep processor | wc –l SUN Solaris psrinfo -v|grep “Status of processor”|wc –l AIX lsdev -C|grep Process|wc –l

Read More

To identify High Disk I/o using Unix command

/usr/bin/ps -eo pid,user,pcpu,args | grep -v %CPU |  sort -nbk 3 | tail -25

Read More

Number of times Purge Concurrent Request execution was run in last 30 days

set pages 1000 set line 132 set head on select  r.requested_start_date,r.actual_start_date,r.phase_code,r.status_code,r.actual_completion_date from apps.fnd_concurrent_programs_vl p, apps.fnd_concurrent_requests r where p.concurrent_program_id = r.concurrent_program_id and p.application_id = r.program_application_id and p.user_concurrent_program_name like ‘Purge Concurrent Request…

Read More

Number of times gather schema stats was run in last 30 days

set pages 1000 set line 132 set head on select  r.request_id,r.actual_start_date,r.phase_code,r.status_code,r.actual_completion_date,argument_text from apps.fnd_concurrent_programs_vl p, apps.fnd_concurrent_requests r where p.concurrent_program_id = r.concurrent_program_id and p.application_id = r.program_application_id and p.user_concurrent_program_name like ‘%Gather Schema Statistics%’…

Read More

Concurrent Requests Average/Max/Min hours runtime details

set linesize 200 col username for a10 col status for a10 col phase  for a10 col PNAME for a70 col request_id for 99999999999 col PNAME  for a40 select b.user_name username,…

Read More