ORA-00124 : MTS_DISPATCHERS specified without MTS_MAX_SERVERS

Friday, March 21st, 2008

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

ORA-00111 : no servers started because number of servers is limited to string

Friday, March 21st, 2008

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

ORA-00104 : deadlock detected; all public servers blocked waiting for resources

Friday, March 21st, 2008

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

Close
E-mail It