Kevin Kempf's Blog

July 21, 2010

Where are my 11i manager logfiles?

Filed under: 11i — kkempf @ 1:04 pm

I pieced together a nifty query today while troubleshooting my workflow notification mailer.  If you’ve ever wondered which log file is for the various managers running, this may be of use to you.

select
  concurrent_queue_name manager
  ,fcp.concurrent_process_id pid
  ,meaning
  ,fcp.logfile_name
from
  fnd_concurrent_queues    fcq
  ,fnd_concurrent_processes fcp
  ,fnd_lookups              flkup
where
  fcq.concurrent_queue_id = fcp.concurrent_queue_id
and
  fcq.application_id = fcp.queue_application_id
and
  flkup.lookup_code=fcp.process_status_code
and
  lookup_type ='CP_PROCESS_STATUS_CODE'
and
  meaning='Active'
order by
  manager
;

The output will look something like this:

MANAGER PID MEANING LOGFILE_NAME
CSTROLLUP 53985 Active /u02/appdevl/devcomn/admin/log/DEV_oradev-02/w53985.mgr
FNDCPOPP 53912 Active /u02/appdevl/devcomn/admin/log/DEV_oradev-02/FNDOPP53912.txt
FNDCRM 53915 Active /u02/appdevl/devcomn/admin/log/DEV_oradev-02/c53915.mgr
FNDICM 53898 Active /u02/appdevl/devcomn/admin/log/DEV_oradev-02/DEV_0714.mgr
FNDSCH 53916 Active /u02/appdevl/devcomn/admin/log/DEV_oradev-02/s53916.mgr
FNDSM_ORADEV-02 53900 Active /u02/appdevl/devcomn/admin/log/DEV_oradev-02/FNDSM53900.mgr
INVMGR 53984 Active /u02/appdevl/devcomn/admin/log/DEV_oradev-02/w53984.mgr
INVMGR 53983 Active /u02/appdevl/devcomn/admin/log/DEV_oradev-02/w53983.mgr
INVMGR 53982 Active /u02/appdevl/devcomn/admin/log/DEV_oradev-02/w53982.mgr
INVMGR 53981 Active /u02/appdevl/devcomn/admin/log/DEV_oradev-02/w53981.mgr
INVTMRPM 53903 Active /u02/appdevl/devcomn/admin/log/DEV_oradev-02/t53903.mgr
INVTMRPM 53902 Active /u02/appdevl/devcomn/admin/log/DEV_oradev-02/t53902.mgr
INVTMRPM 53899 Active /u02/appdevl/devcomn/admin/log/DEV_oradev-02/t53899.mgr
INVTMRPM 53901 Active /u02/appdevl/devcomn/admin/log/DEV_oradev-02/t53901.mgr
INVTMRPM 53904 Active /u02/appdevl/devcomn/admin/log/DEV_oradev-02/t53904.mgr
OAMCOLMGR 53928 Active /u02/appdevl/devcomn/admin/log/DEV_oradev-02/w53928.mgr
PODAMGR 53910 Active /u02/appdevl/devcomn/admin/log/DEV_oradev-02/t53910.mgr
PODAMGR 53909 Active /u02/appdevl/devcomn/admin/log/DEV_oradev-02/t53909.mgr
PODAMGR 53908 Active /u02/appdevl/devcomn/admin/log/DEV_oradev-02/t53908.mgr
RCVOLTM 53905 Active /u02/appdevl/devcomn/admin/log/DEV_oradev-02/t53905.mgr
RCVOLTM 53906 Active /u02/appdevl/devcomn/admin/log/DEV_oradev-02/t53906.mgr
RCVOLTM 53907 Active /u02/appdevl/devcomn/admin/log/DEV_oradev-02/t53907.mgr
STANDARD 53936 Active /u02/appdevl/devcomn/admin/log/DEV_oradev-02/w53936.mgr
STANDARD 53935 Active /u02/appdevl/devcomn/admin/log/DEV_oradev-02/w53935.mgr
STANDARD 53929 Active /u02/appdevl/devcomn/admin/log/DEV_oradev-02/w53929.mgr
STANDARD 53930 Active /u02/appdevl/devcomn/admin/log/DEV_oradev-02/w53930.mgr
STANDARD 53931 Active /u02/appdevl/devcomn/admin/log/DEV_oradev-02/w53931.mgr
STANDARD 53932 Active /u02/appdevl/devcomn/admin/log/DEV_oradev-02/w53932.mgr
STANDARD 53933 Active /u02/appdevl/devcomn/admin/log/DEV_oradev-02/w53933.mgr
STANDARD 53934 Active /u02/appdevl/devcomn/admin/log/DEV_oradev-02/w53934.mgr
WFALSNRSVC 53914 Active /u02/appdevl/devcomn/admin/log/DEV_oradev-02/FNDCPGSC53914.txt
WFMLRSVC 53913 Active /u02/appdevl/devcomn/admin/log/DEV_oradev-02/FNDCPGSC53913.txt
WFWSSVC 53911 Active /u02/appdevl/devcomn/admin/log/DEV_oradev-02/FNDCPGSC53911.txt
DW_MANAGER 53979 Active /u02/appdevl/devcomn/admin/log/DEV_oradev-02/w53979.mgr
DW_MANAGER 53980 Active /u02/appdevl/devcomn/admin/log/DEV_oradev-02/w53980.mgr
LONG_REQUEST_MANAGER 53922 Active /u02/appdevl/devcomn/admin/log/DEV_oradev-02/w53922.mgr
LONG_REQUEST_MANAGER 53921 Active /u02/appdevl/devcomn/admin/log/DEV_oradev-02/w53921.mgr
LONG_REQUEST_MANAGER 53920 Active /u02/appdevl/devcomn/admin/log/DEV_oradev-02/w53920.mgr
LONG_REQUEST_MANAGER 53919 Active /u02/appdevl/devcomn/admin/log/DEV_oradev-02/w53919.mgr
Advertisements

Create a free website or blog at WordPress.com.