Re: MTS/Dedicated

From: <banglea_at_onr.com>
Date: 1996/06/17
Message-ID: <4q2a4m$eam_at_mari.onr.com>#1/1

Here is a sample configuration for a tnsnames.ora file. Note the (SRVR=DEDICATED) in the CONNECT_DATA. This would cause a dedicated connection to mars.world. You could specify another descriptor (mars2.world) that did not have the (SRVR=DEDICATED) clause that could be used for SQL*Net V2 Shared Connections.

################
# Filename......: tnsnames.ora
# Name..........: LOCAL_REGION.world

# Date..........: 10-JUN-96 21:50:44

################

mars.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS = 


          (COMMUNITY = TCP.world)

          (PROTOCOL = TCP)

          (Host = mars)


          (Port = 1526)


        )

    )
    (CONNECT_DATA =

       (SID = orcl)
       (GLOBAL_NAME = mars.world)
       (SRVR=DEDICATED)

    )         

In article <Dst316.Iuq_at_news.hawaii.edu>, kittu_at_gis.eng.hawaii.edu says...

>
>Hi,
>Could some one let me know, how the connect
>string is given to obtain a dedicated server
>connection, in a multi threaded environment.
>
>I have a multi threaded server running
>right now.  I guess MTS_SERVERS = 0
>gives me a dedicated server, but I would
>be losing my MTS configuration.
>
>Anyway, I have gone through the documentation.
>A clause (SRVR=DEDICATED) can be used in SQL*Net 
>TNS connect string.  But no further information.
>I was directed to refer to installation or user's
>guide, but couldn't find enough info. to move on.
>
>Could some one let me know what the exact
>connect syntax is?
>
>Thanks a million!!! for your replies.
>  Kittu.
>
>

Received on Mon Jun 17 1996 - 00:00:00 CEST