Complete Source for Oracle Error Code Ora-, Pl/Sql Tips and Tricks and Oracle Error Message Description
Cause : A definition for MTS_DISPATCHERS was specified in the INIT.ORA file, but MTS_MAX_SERVERS was specified as zero.
Action : Specify MTS_MAX_SERVERS to be greater than zero.
Popularity: 17% [?]
Cause : A definition for MTS_SERVERS was specified in the INIT.ORA file, but no definition for MTS_DISPATCHERS was specified. Without a value for MTS_DISPATCHERS, shared servers will never be used.
Action : Add a definition for MTS_DISPATCHERS in the INIT.ORA file (or take out the definition for MTS_SERVERS, if MTS is not being used).
Popularity: 16% [?]
Cause : The value of the MTS_DISPATCHERS parameter is incorrect.
Action : The sum of all MTS_DISPATCHERS values must be greater than or equal to 0 and less than or equal to the value of MTS_MAX_DISPATCHERS.
Popularity: 8% [?]
Cause : A protocol name specified in the MTS_DISPATCHERS initialization parameter is too long.
Action : Use a valid protocol name for the MTS_DISPATCHERS value.
Popularity: 9% [?]
Cause : An attempt was made to alter the dispatcher’s configuration network protocol that was not specified in the INIT.ORA file.
Action : Do one of the following:
- Include the network protocol in the definition for the MTS_DISPATCHERS initialization parameter and restart the system.
- Use the ALTER SYSTEM SET MTS_DISPATCHERS command with network protocol that exists in the initialization parameter file.
Popularity: 8% [?]
Cause : The syntax for the MTS_DISPATCHERS parameter is incorrect.
Action : Enter the MTS_DISPATCHERS parameter into the initialization parameter file with the correct syntax and then shut down and restart the instance.
Popularity: 8% [?]
