My Oracle Support Banner

Standalone or RAC Pre-11g: How to Create Additional TNS listeners and Load Balance Connections Between them (Doc ID 557946.1)

Last updated on NOVEMBER 20, 2019

Applies to:

Oracle Net Services - Version and later
Information in this document applies to any platform.
Please note that in RAC version 11gR2 and higher, the srvctl utility would be used to add and manage listeners. That information is not covered in this
Use these instructions RAC 11gR1 and lower and any version standalone configuration where an additional listener might be necessary.


How to create an additional TNS listener(s) and load balance connections between those listeners.
ie run with multiple TNS listeners. This can assist when a single TNS listener is stressed or overwhelmed with a high connection rate, particularly during peak periods or when a login storm occurs.

Increasing the value for QUEUESIZE for TNS listener can also assist. See section 5 of <Note 67983.1>


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 Adding Additional TNS Listener Standalone Database
 Adding Additional TNS Listener RAC

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.