Skip to Main Content
Oracle Net8 Configuration and Troubleshooting
book

Oracle Net8 Configuration and Troubleshooting

by Hugo Toledo, Jonathan Gennick
December 2000
Intermediate to advanced content levelIntermediate to advanced
408 pages
12h 26m
English
O'Reilly Media, Inc.
Content preview from Oracle Net8 Configuration and Troubleshooting

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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Pro Oracle Database 11g RAC on Linux

Pro Oracle Database 11g RAC on Linux

Steve Shaw, Martin Bach
Oracle 11g

Oracle 11g

Lewis Cunningham

Publisher Resources

ISBN: 1565927532Catalog PageErrata