Friday 14 June 2013

CONC-SM TNS FAIL in concurrent manager logfile.

Error in internal  concurrent manager logfile
==============================
CONC-SM TNS FAIL

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

Metalink id:
========
Concurrent Processing – CONC-SM TNS FAIL In Internal Concurrent Manager (ICM) Log File With Virtual Hosts Configuration (Doc ID 961216.1)

Solution:
1)Check mout point
2)Run cmclean.sql
3)start concurrent manager
Run cmclean.sql
===========

SQL> show user
USER is "APPS"
SQL> @/u01/.wasiq/scripts/cmclean.sql
DOC>
DOC>WARNING : Do not run this script without explicit instructions
DOC>from Oracle Support
DOC>
DOC>
DOC>*** Make sure that the managers are shut down ***
DOC>*** before running this script ***
DOC>
DOC>*** If the concurrent managers are NOT shut down, ***
DOC>*** exit this script now !! ***
DOC>
DOC>#
If you wish to continue type the word 'dual':
If you wish to continue type the word 'dual': dual



-----------------------------------------------------------------------
-- Updating invalid process status codes in FND_CONCURRENT_PROCESSES

0 rows updated.


-----------------------------------------------------------------------
-- Updating running processes in FND_CONCURRENT_QUEUES
-- Setting running_processes = 0 and max_processes = 0 for all managers

54 rows updated.


-----------------------------------------------------------------------
-- Updating invalid control_codes in FND_CONCURRENT_QUEUES

Manager short name Control code
-------------------- ------------
FNDCRM N
FNDSCH N
STANDARD N
PODAMGR N
RCVOLTM N
PASMGR N
GEPSNOTML N
INVMGR N
INVTMRPM N
MRPMGR N
CRPINQMGR N
WFWSSVC N
WFALSNRSVC N
WFMLRSVC N
FNDCPOPP N
FNDSM_CTSSD N

16 rows updated.


54 rows updated.


-----------------------------------------------------------------------
-- Updating any Running or Terminating requests to Completed/Error

0 rows updated.


-----------------------------------------------------------------------
-- Updating any Runalone flags to 'N'

Updated 0 rows of runalone_flag in fnd_conflicts_domain to 'N'

-----------------------------------------------------------------------
Updates complete.
Type commit now to commit these updates, or rollback to cancel.
-----------------------------------------------------------------------

SQL> commit;

Commit complete.

SQL>

Start concurrent manager .

after doing above steps CM is came up!!!

1 comment: