It's true. I have 8.1.7.0.0, and when USER_SHARED_SOCKETS is TRUE, the
listener will not allow external connections. So, even though it may have
worked in 8.1.6.x.x, Oracle broke it with the first release 8.1.7.
"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
news:3c4549ba$0$8506$ed9e5944_at_reading.news.pipex.net...
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> news:7e8a4ucrmqm0btc258kbr0oofsbvkdadp9_at_4ax.com...
> > On Wed, 16 Jan 2002 13:45:00 +1300, Thomas Hesse
> > <thomas.hesse_at_team.xtra.co.nz> wrote:
> >
> > >By default on Windows NT and Windows 2000 Port Redirection is used, but
> > >it can
> > >be changed to Port Sharing with a registry key
> > >
> > >USE_SHARED_SOCKET = TRUE
> > >
> > >\\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE (Releases 8.0) or
> > >\\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME<#> (Release 8i )
> >
> > While the answer is correct you'll need to upgrade to 8.1.7.1.2 for
> > this
>
> works just fine on an 8.1.6(.3 but was .0) database server in our
> organisation. If you are doing this for firewall reasons you will probably
> also need to do some firewall config as well.
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
>
> ******************************************
>
>
Received on Thu Jan 17 2002 - 14:02:38 CST
