Your firewall needs a SQLNET proxy, or you must use connection pooling.
"Mr Pink" <MrPink_at_Technologist.com> wrote in message
news:3cf62819$0$10786$afc38c87_at_news.easynet.co.uk...
> 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 - 09:02:44 CDT
