Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

One listener per server or one listener per instance? what is best practice?

2983472Oct 14 2015 — edited Oct 21 2015

I joined a new company and incumbent oracle DBA uses one listener and one port (default) per server.  We have 7 oracle database instances on one server all using the same listener.  I've always created a new listener ./netca or make entries manually per database instance ./dbca

What is the best practice?  My argument for creating a separate listener is to be able to restrict connections and throttle connections per database using the listener params and settings.  With one listener, it would seem like unable to use many of the listener parameters or settings since all dB's use this single one listener.  Also if listener failed no new connections for any of the dB's using it on the server.

What is the best practice?

This post has been answered by andrewmy on Oct 15 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 18 2015
Added on Oct 14 2015
28 comments
5,378 views