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
For further information on Concurrent Manager click on System Administrator Maintenance Guide here [page 21-77]