Find Oracle Error Code Ora- and Pl/SQL Tips and Tricks

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% [?]

Share This

Cause : An attempt was made to start more servers than the maximum number specified by the system parameter MTS_MAX_SERVERS.
Action : Increase the value of the MTS_MAX_SERVERS initialization parameter as needed or re-issue the ALTER SYSTEM SET MTS_SERVERS command with an appropriate number of servers.

Popularity: 12% [?]

Share This

Cause : All available public servers are servicing requests that require resources locked by a client which is unable to get a public server to release the resources.
Action : Increase the limit for the system parameter MTS_MAX_SERVERS as the system will automatically start new servers to break the deadlock until the number of servers reaches the value specified in MTS_MAX_SERVERS.

Popularity: 7% [?]

Share This