11gR1 and Older: How to Create Additional TNS listeners and Load Balance Connections Between them (Doc ID 557946.1)

Last updated on AUGUST 02, 2017

Applies to:

Oracle Net Services - Version 9.2.0.1.0 to 11.1.0.7 [Release 9.2 to 11.1]
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
document.
Use these instructions RAC 11gR1 and lower and any version standalone configuration where an additional listener might be necessary.

Goal

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>

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms