Re: Standard Mgr and Inventory, always running on one particular node of RAC db.

Posted by ErmanArslansOracleBlog on Dec 15, 2016; 12:31pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Standard-Mgr-and-Inventory-always-running-on-one-particular-node-of-RAC-db-tp1693p1760.html

bytheway, The instance name in the cp analyzer output is not important. It gets the instance_name from v$instance. So it is based on the instance on which your sqlplus session which executes the cpanalyzer, resides connected.

Answer the following questions.

1)Are you sure that all the other manager except standard manager and inventory manager running? -- please test this by submitting some requests to them .. I m asking this, because there can be a more general and the active/actual values in concurrent manager administer screen may be misleading you.

2)
I think the problem is happening while your managers are going down. I think it is a bug.
The key is managers will have to go down first before they can come back up.
So, we need to concantrate on the problem logged in your manager's logfile, which is ->
Could not submit job to kill concurrent process 9825: Oracle error 100: ORA-01403: no data found has been detected in FND_CONC_RAC_UTILS.SUBMIT_MANAGER_KILL_SESSION.

-> set  "Concurrent PCP Instance Check" to OFF.
->Check this note for the patches: Concurrent Programs Fail With: Oracle Error 100: ORA-01403: No Data Found Has Been Detected In FND_CONC_RAC_UTILS. (Doc ID 1988419.1)
-> Check this note for the patches as well : Concurrent Manager FNDSM intermittently Crashes / Shutting Down Abnormally When a Concurrent Request is Cancelled (Doc ID 1577982.1)
->Check this note for the patches as well: Concurrent Managers Are Not Going Down Properly After Applying Patch 16735285 (Doc ID 2063862.1)