Re: Firewall: use_shared_socket

Good Morning,
It should be of type REG_EXPAND_SZ, and it should be located in HKEY_LOCAL_MACHINE\Software\Oracle. Also, if you have more than one Oracle home, I do believe it has to be in each of those sub areas under HKEY_LOCAL_MACHINE\Software\Oracle. There is a gentleman named Victor who has experience with multiple Oracle homes who can provide the correct info if I am wrong on that last item. Also, this fix only works for Oracle 8 and later on NT, not 7x versions. Finally, don't need to do anything extra on the client. Hope it helps.

Joe Long

Sam wrote:
>
> hi
> Where do you specify this Registry entry and what is it's type ?
> Do you need to specify at the Client PC also ?
>
> Thx
> Sam
>
> Tim Kelley <tpkelley_at_winkinc.com> wrote in message
> news:380F6557.83AC95E3_at_winkinc.com...
> > Joe Long wrote:
> > >
> > > We had the same problem, but the use_shared_socket = TRUE reg setting
> > > worked fine for us. Before that however we tried to open up all the
> > > ports Oracle server used. I found in the Listener log that Oracle was
> > > cycling through a couple of THOUSAND ports in order one at a time.
> > > Obviously our security guy flat refused, with good reason. Just for
> > > comparison, we are running NT4, SP5, on a DEC Alpha. Hope the info
> > > helps.
> >
> > Unfortunately, I'm using oracle 7 and the "use_shared_socket" fix
> > is for oracle8 ... does anyone know of anything that can work
> > with oracle 7? Netstat shows me that the oracle server is using
> > all sorts of ports, it looks totally random.
> >
> > I am using a linux firewall and have total control over it. I
> > can use tnsping on the oracle server but of course can't open a
> > session.
> >
> > Isn't there some way you can tell oracle7 which ports to use?
> >
> > --
> > Tim Kelley
> > tpkelley_at_winkinc.com
> >
> > subtract "useable" from "unstable" and what's left?
Received on Fri Oct 22 1999 - 09:00:24 CDT