Xref: alice comp.databases.oracle.server:83000
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!sunqbc.risq.qc.ca!torn!news1.bellglobal.com!news20.bellglobal.com.POSTED!not-for-mail
Sender: stark@HSE-Montreal-ppp33976.qc.sympatico.ca
Newsgroups: comp.databases.oracle.server
Subject: Re: Doubts about MTS
References: <38904153.D2DD4B1D@si.unirioja.es> <87oga4rkms.fsf@HSE-Montreal-ppp33976.qc.sympatico.ca> <389597FD.FAE75020@si.unirioja.es>
From: Greg Stark <greg-spare-1@mit.edu>
Organization: The Emacs Conspiracy; member since 1992
Message-ID: <8766w8f53c.fsf@HSE-Montreal-ppp33976.qc.sympatico.ca>
Lines: 39
User-Agent: Gnus/5.070095 (Pterodactyl Gnus v0.95) Emacs/20.5
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Date: Wed, 02 Feb 2000 07:15:13 GMT
X-Trace: news20.bellglobal.com 949475713 216.209.192.133 (Wed, 02 Feb 2000 02:15:13 EST)
NNTP-Posting-Date: Wed, 02 Feb 2000 02:15:13 EST


Julio <julio.negueruela@si.unirioja.es> writes:

> Thanks for your answer, Greg, now I've got one more doubt. :-)
> 
> Greg Stark escribió:
> 
> > The client can request to be connected to a dedicated server. There are times
> > when this is useful: tunneling through firewalls, performing disk intensive
> > tasks that would tie up a shared server for a long time, etc. 
> 
> How can I indicate to start a dedicated server process ?
> 
> Thanks in advance.

By putting something like this in tnsnames.ora, note the last line. This
contacts localhost:1521 which is tunneled to the db server port 1521 over an
encrypted connection.

TUNNELLED = 
  (DESCRIPTION = 
    (ADDRESS_LIST = 
        (ADDRESS = 
          (COMMUNITY = tcp.world)
          (PROTOCOL = TCP)
          (Host = localhost)
          (Port = 1521) 
        )
    )
    (CONNECT_DATA = (SID = ORCL)
    (SRVR=DEDICATED)
    )
  )




-- 
greg