Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Shared Sockets. 8.1.7.3
Alan,
I am currently testing this via the LAN. I haven't included the firewall into the testing yet. Is the firewall required for such testing? Would the connection pooling involve the Oracle Connection Manager? If so I cannot locate the admin program for it or any cman references.
Regards,
Lee
"Alan" <alanshein_at_erols.com> wrote in message
news:ad5be2$ubgtk$1_at_ID-114862.news.dfncis.de...
> 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 Fri May 31 2002 - 05:53:00 CDT