Home » RDBMS Server » Networking and Gateways » Listener trivial question
Listener trivial question [message #66689] Fri, 25 October 2002 09:00 Go to next message
Messages: 40
Registered: July 2001
I've just started working on listeners.could anyone just tell me about the significance of listeners( i mean i know they r used to handle connections to that database) but what does that mean.i have worked with databases without configuring any listener for them.What actually does a listener do and why do u need it???

I am not sure whether i am complete in my question.Kindly bear with me.

Thanx in advance,
Re: Listener trivial question [message #66690 is a reply to message #66689] Fri, 25 October 2002 09:52 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
1. If you install the datbase in a box, and work
   directly from there ( without giving hostring) no
   listener is reuqired.
   Same goes with PERSONAL EDITIONS too.
2. But if u want u want to use a connection string...
   you have to use listener.
   same goes when u want to connect from cleint to server.

[b] local database -- without connect string [/b]
SQL> connect mag/mag 
[b]local database with correct string only works[/b]
SQL> connect mag/mag@somestring
ORA-12154: TNS:could not resolve service name

Warning: You are no longer connected to ORACLE.
SQL> connect mag/mag@local
SQL> connect dbadmin@biochip_chipdb2
Enter password: *********

3. You have to create the connectstring in the
   Tnsanames.ora file.
4. LISTENER waits or listens for incoming connections
5. single listener may handle many databases.
   for better security, 1 listener per database would
   be recomended.

ex: this shows that single listner is listening 
for many databases

$ lsnrctl status

LSNRCTL for Solaris: Version - Production on 25-OCT-2002 11:27:37

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

Alias                     LISTENER
Version                   TNSLSNR for Solaris: Version - Production
Start Date                21-AUG-2002 11:51:55
Uptime                    64 days 23 hr. 35 min. 41 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/8.1.7/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/8.1.7/network/log/listener.log
Services Summary...
  PLSExtProc            has 1 service handler(s)
  abprod                has 1 service handler(s)
  abtest                has 1 service handler(s)
  chipdb2               has 1 service handler(s)
  ctoracle              has 1 service handler(s)
  dc            has 1 service handler(s)
  dmea          has 1 service handler(s)
  nihcns                has 1 service handler(s)
  ods           has 1 service handler(s)
  pmwr          has 1 service handler(s)
  pmwr1         has 1 service handler(s)
The command completed successfully

6 . to check whether listener is up from a client, use TNSPING ( just like ping)

Microsoft Windows 2000 [[Version 5.00.2195]]
(C) Copyright 1985-2000 Microsoft Corp.

C:>tnsping biochip_chipdb2

TNS Ping Utility for 32-bit Windows: Version - Production on 25-OCT-2002 11:32:37

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

Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=*****.mit.edu)(PORT=****))
OK (70 msec)


Previous Topic: TNS protocol adapter error on windows 98
Next Topic: Re: Listener trivial question
Goto Forum:

Current Time: Thu Feb 29 08:33:55 CST 2024