Re: HELP: CONFIG MTS SERVER ORA 8.0.4 ON WIN NT

Marc

Are you getting any errors when attempting to start the database? Or does it startup OK? Using MTS is not just a case of starting the database with the right number of dispatchers. You need other things as well (shared servers using the MTS_SERVERS parameter for example), and you need to tell Oracle you're using a multi-threaded connection via the tnsnames.ora file.

Before I'd configure it, though, I'd check the requirement to use it. MTS is really required for one of two things:

1. Memory shortfall (in which case I'd buy more memory)
2. Connection Manager / connection pooling.

HTH Pete

coopman_at_ix.netcom.com wrote:

> I am trying to configure an NT oracle server (8.0.4) to run with the
> Multi-threaded server (MTS) configuration, using the Instance Manager GUI.
>
> I am following the documented instructions, but when I fill out the
> MTS_DISPATCHERS field the app complains of an invalid syntax in that field
>
> I have tried MTS_DISPATCHERS:
>
> (PROTOCOL=TCP)(DISPATCHERS=2)
>
> as documented in the Oracle material
>
> also tried variants such as TCP,2
>
> In any case, I cannot get the server to run in MTS mode, even when directly
> editing my init.ora file
>
> Any hep would be appreciated
>
> Marc
>
> coopman_at_jumpstart-tech.com-NOSPAM

--

Regards

Pete

Received on Mon Jun 07 1999 - 11:29:57 CDT