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 9.2.0.1 and laterInformation 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
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
| Goal |
| Solution |
| Adding Additional TNS Listener Standalone Database |
| Adding Additional TNS Listener RAC |
| References |