Setting DISPATCHERS initialization parameter - Example - Managing Oracle Database Processes

Discussion

• Nirja Shah   -Posted on 23 Sep 15
  - Some examples of setting the DISPATCHERS initialization parameter follow.
  
  - Typical - This is a typical example of setting the DISPATCHERS initialization parameter.
  
  DISPATCHERS="(PROTOCOL=TCP)(DISPATCHERS=2)"
  
  - Forcing the IP Address Used for Dispatchers - The following hypothetical example will create two dispatchers that will listen on the specified IP address. The address must be a valid IP address for the host that the instance is on. (The host may be configured with multiple IP addresses.)
  
  DISPATCHERS="(ADDRESS=(PROTOCOL=TCP)(HOST=144.25.16.201))(DISPATCHERS=2)"
  
  - Forcing the Port Used by Dispatchers - To force the dispatchers to use a specific port as the listening endpoint, add the PORT attribute as follows:
  
  DISPATCHERS="(ADDRESS=(PROTOCOL=TCP)(PORT=5000))"
  DISPATCHERS="(ADDRESS=(PROTOCOL=TCP)(PORT=5001))"

➨ Post your comment / Share knowledge