Standalone or RAC Pre-11g: How to Create Additional TNS listeners and Load Balance Connections Between them
(Doc ID 557946.1)
Last updated on AUGUST 24, 2018
Applies to:Oracle Net Services - Version 188.8.131.52.0 to 184.108.40.206 [Release 9.2 to 12.2]
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|