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!!!
==============================
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!!!
Thanks! was useful!
ReplyDelete