DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: LISTENER.ORA and TNSNAMES.ORA

  1. #1
    Join Date
    Mar 2002
    Posts
    200
    I see the contents of both the files are identical. Can anyone please explain the difference between the two. Also, if someone can precisely explain what a "listener" is used for, that would be a great help.

  2. #2
    Join Date
    Nov 2000
    Location
    Israel
    Posts
    268
    Hya,
    The listener process is responsible to handle all connect request from client. The listener can work in 2 differen modes:
    dedicated - for each connect request, the listener start a server process and hands it to the client. this server process will serve the client until it disconnects.
    shared (MTS) - there are several dispathcers in the system. each dispatcher works with a server process. when a listener gets the connect request, it asks the most available dispatcher for a server process, the dispatcher is handed to the client and the client works with the dispatcher until it disconnects. In this mode, there are fewer server processes in the system.

    The listener.ora file contains information about the listener, its addresss and protocol and the services it serves (the instances). The listener process uses this file for configuration.

    The tnsnames.ora file is used to resolve the connect string in the connect request ("connect scott/tiger@orcl") to a database.

    Cheers,
    R.

  3. #3
    Join Date
    Mar 2002
    Posts
    200
    Thanks for the response. Any other better explanation?

  4. #4
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Yes, sure. Try Oracle manuals....
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    LOL

  6. #6
    Join Date
    Mar 2002
    Posts
    200
    jmodic and pando: i did read the manuals. i am not able to decipher the conceptual difference and the use of a listener. thats why i posted. thx anyways for ur encouragement. we definitely do need some good moderators like you guys.

  7. #7
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    Originally posted by quester
    I see the contents of both the files are identical. Can anyone please explain the difference between the two. Also, if someone can precisely explain what a "listener" is used for, that would be a great help.
    Try reading this one.......

    http://otn.oracle.com/docs/products/...tro.htm#437541

    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  8. #8
    Join Date
    Apr 2002
    Posts
    135
    As far as my knowledge in oracle,

    1. When the Oracle client wants to Eshtablis connection with any of the oracle servers, net8 configuration has to be done .And the details about the server will be entered in the Tnsnames File.Every time you want to connect to the server the tnsnames files will be read and the server details will be used to connect with the server.


    2. The listener process will be in the Oracle Server which will be constantly listening on the port, and if any client wishes to connect to the server hands off the request to the listener and the listener takes care of the rest in authenticating and connecting.( also it will handle to request to the dispatcher in the case of Shared server mode)
    Good Judgement comes from Experience.
    Experience comes from Bad Judgement

  9. #9
    Join Date
    Jul 2002
    Location
    Lincolnshire, IL
    Posts
    203
    To put it in very simple laymen's words...
    A listener listens (listener.ora) at the server the request made by clients i.e. tnsnames.ora
    Contents can never be identical fo both file...
    Sandy
    "Greatest Rewards come only with Greatest Commitments!"

  10. #10
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    Quester,

    the conceptual difference
    The phone number you dial is the number which the other end must possess.


    the use of a listener.

    A telecom exchange must be ready to not only wait/standby/listen for your calls/requests but for everyone else. So after you have been connected, the exchange reliquishes the connection and waits fro others to call in...

    Hope this explains a littel bit.
    Cheers!!!

    Tarry
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width