Question regarding Oracle 10g listener
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Question regarding Oracle 10g listener

  1. #1
    Join Date
    Jun 2005
    Location
    Ottawa, Ontario, Canada
    Posts
    18

    Question regarding Oracle 10g listener

    Is it generally good practice to allocate one listener (one port) per database instance on an Oracle 10g Server ?
    Is there a maximum number of database instances that can listen on the same listener port ? Are there any guidelines to follow for this ?

    Thanks for any advice on this ....


    TTYL,
    Travis Weir

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    well in a perfect world only one database would live on one server.

    A listener can handle many many databases, more important is the number of connections which are being opened to the database.

  3. #3
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Quote Originally Posted by jimbobfurley
    Is there a maximum number of database instances that can listen on the same listener port ? Are there any guidelines to follow for this ?
    The listener just establishes the connection. It can establish a big bunch of connections per second. I guess it depends alot on how many connections you plan to establish per second. Usually one listener on one port on one machine is sufficient for that machine.

    You may want to use different ports/ip's to filter or balance your traffic through certain network cards.

    I generally use the newest version on the server as the listener unless there are compatibility issues (ex: 8i & 10g)

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