Re: Shared Sockets. 8.1.7.3

Niall,

Many thanks for this. Was added and I have now re-booted the server. No difference. Listener.log still reports a TCP port other that 1521.

Lee

"Niall Litchfield" <niall.litchfield_at_dial.pipex.com> wrote in message news:3cf60715$0$8507$cc9e4d1f_at_news.dial.pipex.com...
> you need to restart the database and the listener. I think you can also
get
> away with putting USE_SHARED_SOCKET=TRUE as a system enviroment variable.
I
> believe the firewall also has to know about sqlnet traffic.
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> "Mr Pink" <MrPink_at_Technologist.com> wrote in message
> news:3cf603de$0$10772$afc38c87_at_news.easynet.co.uk...
> > Hello,
> >
> > I am running Oracle 8.1.7.3 on Windows 2000 Advanced Server. I am trying
> to
> > force traffic down a single port as they are currently being assigned
> > randomly within the listener.log
> >
> > I have added USE_SHARED_SOCKET = TRUE into the registry at
> > \HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0 and it makes no difference. I
> have
> > also added USE_SHARED_SOCKET= TRUE within the SQLNET.ORA and still no
> > difference.
> >
> > Does anyone know why Oracle refuses to force the traffic down the one
> port?
> >
> > Many Thanks!
> >
> > Lee
> >
> >
>
>
Received on Thu May 30 2002 - 08:26:23 CDT