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

Thread: Share lisener or seprate ?

  1. 01-25-2007, 07:00 PM #1
    Jiangxi
    Jiangxi is offline Junior Member
    Join Date
    Jan 2007
    Posts
    22

    Question Share lisener or seprate ?

    I installed two instance ( databases ) on the same box, now i am wondering if i should share the same listener ( port 1521 ) or separate one for each ( say port 1521 for one, and port 1522 for the other ) ? What's difference it will make? Thanks in advance.
    Reply With Quote Reply With Quote
  2. 01-25-2007, 08:46 PM #2
    KenEwald's Avatar
    KenEwald
    KenEwald is offline Senior Advisor
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    A good rule of thumb is to use the server's latest version listener.

    If your server is exposed to outside traffic, you may have some firewall port hole-poking to do (read nightmare).

    Ken
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need
    Reply With Quote Reply With Quote
  3. 01-26-2007, 06:07 AM #3
    JMac
    JMac is offline Red Boy of Differdange
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    Why two listeners?

    Do you have more than one DB on the box? Say - a Prod and a Test DB? You might want to direct test users to the test listener etc. That way you can play around with the test listener without interefering with the Prod users.

    Separating them out to separate ports could also reduce contention, I suppose.
    Reply With Quote Reply With Quote
  4. 01-26-2007, 06:56 AM #4
    Bore
    Bore is offline Advisor
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    Setting a listener on non-default port could be a bit tricky. You will probably loose the authomatic service registration and dispatcher registrations to the listener if you do not set the LOCAL_LISTENER initialization parameter.
    Also if you do not set this parameter, you will not be able to prevent both instances from registering to the listener at 1521.
    The listener tends to be easy to use and maintain, with no much space of configuration and experimenting, so you need 2 listeners ONLY in case if you have exessive login/logouts (the number of connected sessions has nothing to deal with the listener, it is operatable only trough connection)
    So I support Ken. Go with the listener of the latest version
    Reply With Quote Reply With Quote
  5. 04-12-2007, 08:50 PM #5
    Jiangxi
    Jiangxi is offline Junior Member
    Join Date
    Jan 2007
    Posts
    22
    So, are you guys saying it's OK for the two instances to share the same port number (1521) ? The two instances will be running on the same box, currently they are share the same port number, just wanna double check it's fine before it go live. thanks in advance.
    Reply With Quote Reply With Quote
  6. 04-12-2007, 11:02 PM #6
    PAVB's Avatar
    PAVB
    PAVB is offline Senior Advisor
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Jiangxi, do the right thing.

    Two instances, Two listeners.

    Is gonna take 10 minutes of your time and it will give you in return two totally independent environments.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
    Reply With Quote Reply With Quote
  7. 04-12-2007, 11:14 PM #7
    PAVB's Avatar
    PAVB
    PAVB is offline Senior Advisor
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Quote Originally Posted by KenEwald
    A good rule of thumb is to use the server's latest version listener.

    If your server is exposed to outside traffic, you may have some firewall port hole-poking to do (read nightmare).
    Ken, Tell me the truth, did you intend to answer a different question or it was just a severe case of random typing?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
    Reply With Quote Reply With Quote
  8. 04-12-2007, 11:21 PM #8
    jennifer2007
    jennifer2007 is offline Banned
    Join Date
    Feb 2007
    Posts
    212
    hi hunnies...i have 4 databases in our box, 8i,9i,10gEE,10gXE and i used
    the listener created by XE ...it is just the ease in manageability having to
    use one listener.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width