Re: Dedicated server as default in a multithreaded environment

"Michael Dimitriadis" <michael.dimitriadis_at_infonova.at> wrote in message news:3961dcac$0$23008_at_SSP1NO25.highway.telekom.at...
> I have the requirement to change our central database to use multithreaded
> server. I would like to do this smoothly which means I want to add some
> dispatchers on special ports (e.g. 5000,5001,..) and switch some clients
 to
> use these ports. All other clients should still use dedicated servers. As
 I
> experienced the default type of a connection (unless you specify
> (SERVER=DEDICATED) in the service-description on the client-side) is a
> MTS-connection (also for port 1521). How can I configure my
> initXXXX.ora-parameters and listener.ora-parameters to acomplish that
 task.
>
> (My configuration is Oracle 8.1.6.1 on AIX 4.3.2)
>
> Thanks in advance,
>
> _____________________________
> Dipl. Ing. Michael Dimitriadis
> INFONOVA GmbH
> Karlauergürtel 1
> A-8020 GRAZ
>
> Tel.: ++43 (0)316 715440-118
> Fax: ++43 (0)316 715440-2
> Email: michael.dimitriadis_at_infonova.at
>
>
>

You can't use dispatchers on different ports, sqlnet can use one tcp ip port *only*. For all the sessions you need to have using dedicated server you need to have the line
use_dedicated_server=on
in their sqlnet.ora. Other than that the only thing you need to do is to use an extra service name (including service=dedicated of course) in your tnsnames.ora. So in your tnsnames.ora you have two definitions for that database.
So no fiddling around with listener.ora. How you need to setup your init.ora is quite well documented in the net8 documentation.

Hth,

Sybrand Bakker, Oracle DBA Received on Tue Jul 04 2000 - 00:00:00 CDT