How to troubleshoot Concurrent Manager in 11i/R12 – Apps Listener

Today’s post is from one of our Apps DBA training exercise (more information on our online Apps DBA training [699 USD] here   ) related to Concurrent Manager.

.

How to check if Concurrent Manager is Up and running ?

Login as user with System Administrator responsibility. Under Concurrent : Manager click on Administer (Actual should be equal to Target)

.


.

.

How to troubleshoot Concurrent Manager issue ?

Check Concurrent Manager log $SID_[MMDD] where MMDD is Concurrent Manager start Month & Date

1. $APPLCSF/$APPLLOG/$SID_[MMDD].mgr

Could not contact Service Manager FNDSM_INNOWAVE03_visr12. 

The TNS alias could not be located, the listener process onINNOWAVE03 could not be contacted, 

or the listener failed to spawn the Service Manager process. 

     Process monitor session started : 24-SEP-2009 20:31:07Could not contact Service Manager FNDSM_INNOWAVE03_visr12. 

The TNS alias could not be located, the listener process onINNOWAVE03 could not be contacted, 

or the listener failed to spawn the Service Manager process.

2. Error message is pointing towards “FNDSM_INNOWAVE03_visr12” so run tnsping to check status of TNS alias like

[avisr12@innowave03 ~]$ tnsping FNDSM_INNOWAVE03_visr12

Output like

TNS Ping Utility for Linux: Version 10.1.0.5.0 - 

Production on 24-SEP-2009 20:36:12Copyright (c) 1997, 2003, Oracle.  

All rights reserved.Used parameter files:Used TNSNAMES adapter to resolve the alias 

Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=innowave03.com)(PORT=1638)) (CONNECT_DATA=(SID=FNDSM))) 

TNS-12541: TNS:no listener

3. Check Apps Listener status like

[avisr12@innowave03 ~]$ lsnrctl status APPS_visr12
LSNRCTL for Linux: Version 10.1.0.5.0 - 

Production on 24-SEP-2009 20:37:36Copyright (c) 1991, 2004, Oracle.  

All rights reserved.Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=innowave03.com)(Port=1638)) 

TNS-12541: TNS:no listener  

TNS-12560: TNS:protocol adapter error  

TNS-00511: No listener   

Linux Error: 111: Connection refused

4. Start Apps Listener

[avisr12@innowave03 scripts]$ ./adalnctl.sh start

output like

adalnctl.sh version 120.3 

Checking for FNDFS executable. 

Starting listener process APPS_visr12. 

adalnctl.sh: exiting with status 0adalnctl.sh: check the logfile /oracle/ apps/ r12/ visr12/ inst/ apps/ visr12_innowave03/ logs/ appl/ admin/ log/ adalnctl.txt formore information ...

5. Try again tnsping again

[avisr12@innowave03 scripts]$ tnsping FNDSM_INNOWAVE03_visr12

output like

TNS Ping Utility for Linux: Version 10.1.0.5.0 - 

Production on 24-SEP-2009 20:39:09Copyright (c) 1997, 2003, Oracle.  

All rights reserved.Used parameter files:Used TNSNAMES adapter to resolve the aliasAttempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=innowave03.com)(PORT=1638)) (CONNECT_DATA=(SID=FNDSM))) 

OK (0 msec)

6. Restart CM again

Oracle Apps DBA (E-Business Suite) R12

Live Instructor led Online sessions with Hands-on Lab Exercises, Dedicated Machines to Practice.

For more queries mail us at contactus@k21technologies.com

Click here to learn more

For further information on Concurrent Manager click on System Administrator Maintenance Guide here  [page 21-77]

About the Author Atul Kumar

Oracle ACE, Author, Speaker and Founder of K21 Technologies & K21 Academy : Specialising in Design, Implement, and Trainings.

follow me on:

Leave a Comment:

11 comments
Simeon says November 2, 2009

I would to know if there is script out there that one can use to monitor when concurrent manager goes down in R1206. I have review OAM but did not see such functionality.
My ccm was down over the weekend and I only notice it on Monday when jobs were pending and other running longer than expected. I had to shutdown the apps and restart to get this fixed. If I had a script in place to send alert when ccm goes down,I would have restarted the ccm immediately. Please let me know if you have any tool that can be of help.

Reply
Ravi kishore says August 18, 2010

Hi ,

why concurrent manager needs apps listener to be started first.My doubt is after starting icm can we start apps listener.

Reply
djay says February 15, 2011

Hello Atul,

Installed 12.1.1 on Oracle enterprise linux (2.6.9-42 Kernel). Unable to login to login page because of APPS Listener unavailability.
Error was like this
TNS-01151 : Missing listener name, APPS_PROD, in listener.ora

when i checked apps listner location found no listener.ora file . Only tnsnames.ora file was there. What could be the problem

Reply
Atul Kumar says February 15, 2011

@ djay,
There are two listeners in apps

a) Apps Listener on application tier
b) Database Listener on database tier

Which listener you are talking ?
Where did you check listener.ora (Did you set environment variable using env files which comes with R12 before checking listener.ora $TNS_ADMIN)

Reply
djay says February 27, 2011

Hi Atul,
IM talkin aboutg apps listener.
Everything was set properly….and checked in each and every file related to listnenr. But simply no listner.ora file was created.

Anyways as re – installed the R12 this time it got successful.

Thanks

Reply
satish says January 24, 2012

Instead of remembering the navigation. kindly go through this commad
ps -ef|grep FNDLIBR is the command to know whether the ccm is up or not.

Reply
santosh says May 11, 2012

Hi Atul,

Hello Atul,

Installed 12.1.1 on Oracle enterprise linux (2.6.9-42 Kernel). my concurrent manager is down could not be started because my APPS Listener unavailability.
Error was like this
TNS-01151 : Missing listener name, APPS_PROD, in listener.ora

when i checked apps listner location found no listener.ora file . Only tnsnames.ora file was there. What could be the problem
checked $TNS_ADMIN

Only Apache services are running.

Reply
    Atul Kumar says May 11, 2012

    @ Santosh,
    This could be because of some failed step during installation. Run autoconfig that should regenerate listener.ora. If AutoConfig fails then check autoconfig logs for root cause

    Reply
Rosana says May 11, 2012

Hello,

I would like to say: THANKS.. your post save my day today..Thanks..

Reply
CHAITANYA says May 18, 2012

Hi, Please help as on urgent basis.

I am getting same error like…

An error occurred while attempting to establish an Applications File Server connection with the node FNDFS_DEV. There may be a network configuration problem, or the TNS listener on node FNDFS_DEV may not be running. Please contact your system administrator.

$ adrelink.sh force=y “fnd FNDFS” :- Failed , status with 1.
$ adrelink.sh force=y “fnd FNDLIBR” :- Success status with 0
$ adrelink.sh force=y “fnd FNDSM”:- Success status with 0
$ adrelink.sh force=y “fnd FNDCRM”:- Success status with 0

$ adalnctl.sh status APPS_TEST

adalnctl.sh version 115.17

Checking status for listener process APPS_TEST.

LSNRCTL for HPUX: Version 8.0.6.3.0 – Production on 18-MAY-2012 11:48:11

(c) Copyright 1999 Oracle Corporation. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=dev)(Port=1630))
STATUS of the LISTENER
————————
Alias APPS_TEST
Version TNSLSNR for HPUX: Version 8.0.6.3.0 – Production
Start Date 18-MAY-2012 11:31:49
Uptime 0 days 0 hr. 16 min. 21 sec
Trace Level off
Security OFF
SNMP OFF
Listener Log File /oraapps/prodora/8.0.6/network/admin/apps_test.log
Services Summary…
FNDFS has 1 service handler(s)
FNDSM has 1 service handler(s)
The command completed successfully

adalnctl.sh: exiting with status 0

but still i am not able to see any logfile and output files.

Kindly help…or send me action plan on
shakichaitanya@gmail.com

Reply
CHAITANYA says May 18, 2012

Also check below FND output.

SQL> select CONCURRENT_QUEUE_NAME from FND_CONCURRENT_QUEUES where CONCURRENT_QU
EUE_NAME like ‘FND%’
2 /

CONCURRENT_QUEUE_NAME
——————————
FNDCPOPP
FNDCRM
FNDICM
FNDIM_AUTHENTICATION
FNDIM_DEV
FNDSCH
FNDSM_AUTHENTICATION
FNDSM_DEV
FNDTMTST

9 rows selected.

Reply
Add Your Reply

Not found