My Oracle Support Banner

All About the Initialization Parameter DISPATCHERS and Related Issues (Doc ID 2673196.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Information in this document applies to any platform.

Purpose

DISPATCHERS configures dispatcher processes in the shared server architecture. The parsing software supports a name-value syntax to enable the specification of attributes in a position-independent, case-insensitive manner. For example:

Attributes may be specified using the full attribute name or any substring beginning with the first 3 characters. For example, SESSIONS can be specified as SES, SESS, SESSI, and so on.

Questions and Answers

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
Purpose
Questions and Answers
 1.  How to set/modify the DISPATCHERS for the standalone database or how to solve ORA-00121 errors?
 2. How to configure DISPATCHERS for RAC environment?
 3. Related parameters in the init<SID>.ora file:
 4. How to configure multiple dispatchers?
 5. How to restrict the range of ports Oracle uses?
 6. How to solve ORA-03135 on SCAN Listener relocate with SHARED Sessions?
References

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