question on concurrent manager

[Sri]

Hi Erman,

Our cost manager was errored out with below error,we have raised an SR but i would like to ask you in this blog.can you please help

APP-FND-01564: ORACLE error 12502 in AFPCOA

Cause: AFPCOA failed due to ORA-12502: TNS:listener received no CONNECT_DATA from client
.

The SQL statement being executed at the time of the error was:  and was executed from the file .
/u02/PRODROOK/fs1/EBSapps/appl/bom/12.0.0/bin/CMCTCM
Program exited with status 1

[ErmanArslansOracleBlog]

1)Only CMCTCM ? Does any other conc. program fail with this error?

2)Answer the question above, and send me the following file file further diag..->

(a) Listener tracing at support level taken at the time of the issue
Note 395525.1  How to Enable Oracle Net Client,Server,Listener,Kerberos and External procedure Tracing from Net Manager (netmgr):

(b) Listener log for the same period

(c) Listener services output
$ lsnrctl services <listener_name>

(d) Settings of Local & Remote Listeners (if any)
$ sql> show parameter listener

3)Relink CMCTCM program (just in case)

4)Ensure your apps tier TNS entries are correct. (just in case)

5)Ensure your dbc file is correct (just in case)

6)Read this document as well: Troubleshooting Guide for ORA-12502 TNS:listener received no CONNECT_DATA from client (Doc ID 453505.1)

[Sri]

Hi Erman,

Thank you

Issue is only with cost manager.we have ralaunched the cost manager and now it is running.But from 2 days it was erroring out with that error and every time we have to relaunch

sorry,we didnt have trace

[ErmanArslansOracleBlog]

I think you had a problem during that period, in your db listener level.
But if it is working now, leave it , dont touch :) good...

[Sri]

Thanks for the update erman.

But actually in last 2 days we have this error.we are afraid that it may error out today as well and client asked for RCA

SR we raised was not progressing as expected

[ErmanArslansOracleBlog]

You need to check the logs for the problematic time interval, as I sent you in my previous updates.

[ErmanArslansOracleBlog]

You need to check the logs for the problematic time interval, as I sent you in my previous updates.

[Sri]

Hi erman,

we dont see any such error in dbalert log or db listener logs as well as application listener.is this could be a network problem as well?

we can see only in request logs

Cause: AFPCOA failed due to ORA-12502: TNS:listener received no CONNECT_DATA from client

Thank you

[ErmanArslansOracleBlog]

Ok.
You need Listener tracing at support level taken at the time of the issue.
But, since the problem is not occuring now, you can not get that trace now.
Next time, follow -> Troubleshooting Guide for ORA-12502 TNS:listener received no CONNECT_DATA from client (Doc ID 453505.1) "and get listener support level taken at the time of the issue."