Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Can an Oracle database have more than one listener? If so, what's the maximum number of listeners a database can have?

share|improve this question

migrated from stackoverflow.com Nov 23 '12 at 10:17

This question came from our site for professional and enthusiast programmers.

    
Did you read the docs?docs.oracle.com/cd/B10500_01/network.920/a96580/listener.htm –  Mat Nov 23 '12 at 6:27
    
Thanks Mat, I didn't but now I'm gonna.. –  harsh Nov 23 '12 at 6:41
    
There is no practical limit to the number of listeners, as far as I know. I can't imagine a use case for more than a handful of listeners, though. –  Roy Nov 23 '12 at 11:41

1 Answer 1

To the best of my knowledge, there is no limit. Of course, it is exceptionally rare that you would have more than one listener for a database. I've seem people run two listeners just in case one listener fails but I've never heard of anyone wanting to run more than two. If you really wanted to, though, nothing stops you from running a dozen listeners on a dozen different ports or on a dozen different machines. But since the listener is virtually never the bottleneck and the listener virtually never fails, that sort of redundancy is rarely helpful.

share|improve this answer
    
Having more than one listener (local+remotes) is not rare for RAC configurations. –  Mat Nov 23 '12 at 10:38
    
Running multiple listeners is quite common in complex networks or complex solutions. You may have listeners for different client classes, different networks, scan listener, virtual ip listeners etc. –  Roy Nov 23 '12 at 11:39

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.