elcarOnOsdnaH

Monday, August 6, 2012

Troubleshooting Apps Listener Start-up/Connection Issue

Perform the following checkup of the Apps Listener service having issue

Log-on to E-Business Suite host

# cd <10.1.2 ORACLE_HOME>/bin

# pwd

# export ORACLE_HOME=<path to 10.1.2 directory>

[oracle@appsnode_new admin]$ locate lsnrctl

/u01/app/oracle/visr12/apps/tech_st/10.1.2/bin/lsnrctl

[oracle@appsnode_new admin]$ lsnrctl status APPS_visr12

LSNRCTL for Linux: Version 10.1.0.5.0 - Production on 03-AUG-2012 19:26:24

Connecting to (ADDRESS=(PROTOCOL=TCP)(Host=appsnode_new)(Port=1626))

STATUS of the LISTENER

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

Alias APPS_visr12

Version TNSLSNR for Linux: Version 10.1.0.5.0 - Production

Start Date 03-AUG-2012 17:29:36

Uptime 0 days 1 hr. 56 min. 47 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /u01/app/oracle/visr12/inst/apps/visr12_appsnode_new/ora/10.1.2/network/admin/listener.ora

Listener Log File /u01/app/oracle/visr12/inst/apps/visr12_appsnode_new/logs/ora/10.1.2/network/apps_visr12.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=appsnode_new.localdomain)(PORT=1626)))

Services Summary...

Service "FNDFS" has 1 instance(s).

Instance "FNDFS", status UNKNOWN, has 1 handler(s) for this service...

Service "FNDSM" has 1 instance(s).

Instance "FNDSM", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

-- Run “lsnrctl” for status checkup.

[oracle@appsnode_new admin]$ lsnrctl status "(ADDRESS=(PROTOCOL=TCP)(HOST=appsnode_new)(PORT=1626))"

LSNRCTL for Linux: Version 10.1.0.5.0 - Production on 03-AUG-2012 19:30:47

Connecting to (ADDRESS=(PROTOCOL=TCP)(HOST=appsnode_new)(PORT=1626))