Multi-Threaded Server Problems
This section provides possible solutions for some common problems related to the use of multi-threaded server.
Your Instance Won’t Start
Symptom
You made some changes to the MTS parameters in your database initialization file, and now your instance won’t start. The only error message you receive is this one:
ORA-01078: failure in processing system parameters
Possible solution
Unfortunately, setting an MTS-related initialization parameter incorrectly is often enough to prevent an instance from starting. Even more unfortunately, you aren’t likely to get an error message that pinpoints the specific parameter that’s incorrect. Your only real recourse is to carefully review each and every MTS parameter to ensure that it is correct.
One specific cause of this problem that we’ve noticed involves the MTS_SERVERS parameter. If no dispatchers are configured, a nonzero setting of MTS_SERVERS causes instance startup to fail. The reason is that with no dispatchers, the instance can’t be configured with the specified minimum number of servers.
Check the MTS_DISPATCHERS parameter especially carefully. Of all the MTS parameters, MTS_DISPATCHERS is the one with the most complex syntax. Be sure that you have the correct number of parentheses and that they are nested properly.
Tip
All MTS_DISPATCHER parameters must be grouped together in your initialization parameter file. No other parameters can come between them.
If you don’t find the problem through visual inspection, and you ...