Yes, Oracle uses random ports. You either need a firewall proxy (supplied by
the vendor, so this is probably out of the question), or look into
"connection pooling" on the server.
"Vern" <pbfvern_at_bellsouth.net> wrote in message
news:qB5qc.22679$GV5.17959_at_bignews4.bellsouth.net...
> Hello All,
>
> I have the above DSL modem on my network along with a variety of machines
> and several different operating systems. One of the operating systems I
have
> is Novell 5.1 and on that server I am using the five user versions of
Oracle
> that ships with Novell. The Oracle version I am using is 8i. The server
> bundle works great and I do all of my business on this platform.
>
> I also have DSL, Novell (v5.0 and Oracle 8), running at home where I have
> several databases that I rely upon heavily and it works great as well. My
> dilemma is that I want to be able to access my work Oracle instance from
> home. Incidentally, I have the identical Westell at home as I do at work.
>
> I have opened up ports 1521-1526 with a base port of 1521 on the Westell
at
> work, (both udp and tcp), and managed to get a login prompt from sqlplus
but
> I'm never able to get logged in. It seems that Oracle is using a different
> port each time I try to connect for communications. I could open up all
> ports on my Westell but you know what that will do to my security.
>
> Does anyone know what I need to do to have the ability to control this? Is
> there special software I need to install to install on my Westell or is
> there a way to instruct Oracle to use specific ports?
>
> Thank you in advance for any help you may be able to provide,
>
> Vern
>
>
Received on Mon May 17 2004 - 12:02:33 CDT
