DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: Purpose of having multi listener ?

  1. #1
    Join Date
    Apr 2003
    Location
    Vijayawada-INDIA
    Posts
    14

    Purpose of having multi listener ?

    Hi

    whats the purpose of having multi listener ???

    will it increase the posting speed in server, when it receives bulk data from 2 clients ???


    thanks in advance
    Himaja

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Depends. Is the listener process consuming a lot of CPU?
    Jeff Hunter

  3. #3
    Join Date
    May 2005
    Location
    AZ, USA
    Posts
    131
    Quote Originally Posted by Himaja
    Hi

    whats the purpose of having multi listener ???

    will it increase the posting speed in server, when it receives bulk data from 2 clients ???


    thanks in advance
    Himaja
    We use it to differentiate projects, so that certain databases/applications, use a particular port.

  4. #4
    Join Date
    Apr 2003
    Location
    Vijayawada-INDIA
    Posts
    14

    is it the right way of setting multi listener ??

    hi

    while setting multi listener, i changed only the host.
    i dint change the port.

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.9.100.1)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.9.100.2)(PORT = 1521))


    is it the right way of setting multi listener ??


    thanks in advance
    himaja

  5. #5
    Join Date
    Apr 2003
    Location
    Pune,Maharashtra. India.
    Posts
    245
    Hi,
    read
    http://download-west.oracle.com/docs...ts.htm#1041193

    In that also read
    Enhanced Service Accessibility with Multiple Listeners

    I think it will Halp you in your question

    Rgds
    Parag

  6. #6
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Quote Originally Posted by Himaja
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.9.100.1)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.9.100.2)(PORT = 1521))
    Correct me if I'm wrong, but isn't the address list (above) for using 2 network cards (each with it's own IP) in 1 server?

    Or failover for a RAC environment...

    From "Enhanced Service Accessibility with Multiple Listeners" link above:
    "For some configurations, such as Oracle9i Real Application Clusters, multiple listeners on multiple nodes can be configured to handle client connection requests for the same database service. In the following example, sales.us.acme.com can connect to sales.us.acme.com using listeners on either sales1-server or sales2-server."

    (DESCRIPTION=
    (ADDRESS_LIST=
    (ADDRESS=(PROTOCOL=tcp)(HOST=sales1-server)(PORT=1521))
    (ADDRESS=(PROTOCOL=tcp)(HOST=sales2-server)(PORT=1521)))
    (CONNECT_DATA=
    (SERVICE_NAME=sales.us.acme.com)))

    Sorry, but I'm confused.
    Last edited by KenEwald; 06-24-2005 at 03:10 AM.

  7. #7
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Quote Originally Posted by Himaja
    whats the purpose of having multi listener ???

    will it increase the posting speed in server, when it receives bulk data from 2 clients ???
    Certanly not! Data to be inserted/updated/deleted/retrived fint/from the database *never* goes through the listener. Database server and the client talk directly to each other, no listener is involved in that. Listener only take its part between the client and the database during the connection time. Once the session is established listener is no longer needed - you can even shut it down and the connected sessions will still happily comunicate with the database.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  8. #8
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    jmodic,

    Yea, I guess he wasn't concerned about overloading a nic or a port with new connections.

    I agree that the listener has nothing to do with established connections data throughput. The listener's job is to start the user's server process and step aside.

  9. #9
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Quote Originally Posted by jmodic
    Certanly not! Data to be inserted/updated/deleted/retrived fint/from the database *never* goes through the listener. Database server and the client talk directly to each other, no listener is involved in that. Listener only take its part between the client and the database during the connection time. Once the session is established listener is no longer needed - you can even shut it down and the connected sessions will still happily comunicate with the database.
    That's what I was going to say until I thought maybe they're connecting each time before they insert (don't laugh, I've seen it).
    Jeff Hunter

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