Re: Does any know Oracle use which TCP Port to connect

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 4 Oct 2000 15:13:35 +0200
Message-ID: <970665461.3693.1.pluto.d4ee154e@news.demon.nl>

Your question suffers from the usual problem: you don't specify which version you use.
sqlnet typically uses port 1521 or 1526, however for communication from the server to the client in version 7 and maybe 8.0 the server chooses a random return port.
In Oracle 8i you can prevent that by using use_shared_sockets = true in sqlnet.ora

Regards,

Sybrand Bakker, Oracle DBA

"Michael Wu" <kuohwawu_at_ethome.net.tw> wrote in message news:8rf9g3$rk0$1_at_news.ethome.net.tw...
> Dear All,
>
> Recently we plan to use firewall and hide our Database inside of it, but
we
> could not connect it to our web server in DMZ smoothly, I just saq the
> initial connection, then it is failed to connect.
>
> Could anyone who knows which port does Oracle use?
>
> Thank you very much.
>
> Best Regards
> Michael Wu
>
> kuohwa_at_ms21.hinet.net
>
>
>
Received on Wed Oct 04 2000 - 08:13:35 CDT