Re: Can multithreaded server and dedicated server be in one instance?

"spencer" <spencerp_at_swbell.net> writes:

> <sybrandb_at_my-deja.com> wrote in message news:8s93gd$6c3$1_at_nnrp1.deja.com...
> > You are correct
> > either add (server=dedicated) after (port=)
> > or include
> > use_dedicated_server=true
> > in sqlnet.ora
> >
> > Regards,
> >
> > Sybrand Bakker, Oracle DBA
>
> does anyone know if this works with Oracle 8.0.6 ?
> the syntax doesn't appear in the Oracle 8.0.5 docs.

I have a tns name with SRVR=DEDICATED in the CONNECT_DATA part of the tns name definition. It worked great with 8.0.5 for tunneling connections via SSH, which doesn't work with MTS connections but works fine with dedicated connections.

FOO=(DESCRIPTION=...
     (CONNECT_DATA = (SID = FOO) (SRVR=DEDICATED))     )

Incidentally, Our experience was that it worked with 8.0.5 but did not work reliably with 8.1.6. Has anyone here tried it with 8.1.6.2 or 8.1.7 ? We're hurting badly from not being able to use it.

-- 
greg