troubleshooting Question

TNS listener not working for client tools ("no listener"), but Sql Plus command window is ok

Avatar of Wm Peck 1958
Wm Peck 1958Flag for United States of America asked on
Oracle DatabaseWindows 7
6 Comments2 Solutions1985 ViewsLast Modified:
I can log on to sql plus successfully from the command line, but when attempting to connect with various client tools, I keep getting "No listener".
no listener Sql Plus windowsOracle Forms no listener
But I can connect via Sql Plus in command window
Sql Plus command window connect
The Listener is started in services, and here is the status (points to 192.168.1.9, Orcl shows ready)
LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 07-AUG-2014 14:35:56

Copyright (c) 1991, 2010, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
Start Date                06-AUG-2014 15:12:27
Uptime                    0 days 23 hr. 23 min. 30 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   E:\app\Stephen\product\11.2.0\dbhome_1\network\admin\listener.ora
Listener Log File         e:\app\stephen\diag\tnslsnr\Stephen-PC\listener\alert\log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.9)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
  Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
  Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully

so it's registered ok.

Notes:
- this is a follow-on from How to connect to PC #1 (running Oracle) from PC #2 (running Oracle client), where I was trying to connect from PC #2  to PC #1. The solution was to specify the local IP address (192.168.1.9) in the tnsnames file and in listener.ora, and to register. All was good, thus allowing me to connect from remote PC's

- just today I set up Oracle client on two different PC's, and I can connect via Sql Plus to scott/tiger@orcl

- so in circling back to regression testing on PC #1, something's wrong with the Listener when trying to connect with client tools :-(. Although I can connect from Sql Developer . . .

Also, I checked my PATH and it's good.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros