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

[ErmanArslansOracleBlog]

any updates?

[ErmanArslansOracleBlog]

You didn't send me the update but here is my update on the matter;

We faced the same thing in a cloned EBS 12.2.4 instance.

as for the solution: I did set set  "Concurrent PCP Instance Check" to OFF.  (it was ON before)
Then I relinkled FNDLIBR binaries and executed cmclean.sql

After that I saw that the error that we were getting, changed.
Standard manager could not start fully. (The target was 10, but the actual was 1 , 2 , and 3 sometimes)

It was obvious that there was some concurrent request issue. A problematic concurrent request assigned to the standard manager queue..
Anyways, I fixed it using the solution documented in Standard Manager Not Starting After Clone (Doc ID 1390758.1)

Fyi.

[ashish_oracleguy]

Hello Erman,

Sorry for not posting any updates.

I was out for few days.

I thinking you might be right on this
"I think the problem is happening while your managers are going down. I think it is a bug. "

------------------

When I stop the EBS 12.2.3 app services, after sometime, I still see following processes are still running

RCVOLTM apps/ZG664DCB8B0CA05FE7A39DFEAB68FC50EE29C04037D2D9E6C27DF8DA6ECF5E01EB1DE255353EF345BC1EF2F619FBA88E63 PO RCVOLTM N 60 t LOCK Y PVCPAP01 9902

INCTM apps/ZG238A0EB9E8B9140F8C2162EEA1F83A59761F0953E34A05327C127D96157347FEC9DD79D5434446FD1EF2F619FBA88E63 INV INVTMRPM N 60 t LOCK Y PVCPAP01 9903

POXCON apps/ZGC524711385244FDBDC6B77B23E6BDBEE9AB8FA1FA4F7417DE420C25FFD10745B547ED875326C0278825A173054454775 PO PODAMGR N 60 t LOCK Y PVCPAP01 9870


-------------------

Thanks

[ErmanArslansOracleBlog]

Executable:POXCON - PO Document Approval Manager Program
Executable:RCVOLTM - Receiving Transaction Manager
Executable:INCTM - Inventory Remote Procedure Manager

These are not related with Standard Manager.
you can kill the remaining processes after the adstpall returns with exit status of 0 , but you can review their log files for further diagnostics as well.

For you main issue, I mean "standard manager and inventory managers, won't start. " , I believe it is related with the Concurrent PCP Instance Check.. It should be off, if you are not using Parallel Concurrent Processing and since you have only a single Apps Tier you can't just have Parallel Concurrent Processing.

I suggest you to take the steps like I did  ->

As for the solution: I did set set  "Concurrent PCP Instance Check" to OFF.  (it was ON before)
Then I relinkled FNDLIBR binaries and executed cmclean.sql

After that I saw that the error that we were getting, changed.
Standard manager could not start fully. (The target was 10, but the actual was 1 , 2 , and 3 sometimes)

It was obvious that there was some concurrent request issue. A problematic concurrent request assigned to the standard manager queue..
Anyways, I fixed it using the solution documented in Standard Manager Not Starting After Clone (Doc ID 1390758.1)

[ErmanArslansOracleBlog]

Also , apply the patch Patch 20312229.

Reference: Stopping Concurrent Manager Process Shows the Following Log Error: Oracle Error 100: ORA-01403: No Data Found Has Been Detected In fnd_conc_rac_utils.submit_manager_kill_session (Doc ID 2144999.1)


** Update me with the outcomes.

[ErmanArslansOracleBlog]

You can also apply Patch 24408550: 12.2.3/12.2.4 LOG & OUT MGMT BACKPORT COMPOSITE STABILITY PATCH II , which supersedes the Patch 20312229.

[ashish_oracleguy]

Hello Erman,

Thanks for the multiple responses.

I very much appreciate your help and dedication.

I will keep you posted.

Regards,

Ashish