Re: Can I know which port that oracle client use for connection?
Date: Tue, 26 Dec 2000 11:59:31 +0100
Message-ID: <929tu6$lci$1_at_wanadoo.fr>
hi
The only way to fix a port number for a client is to configure your database
as MTS architecture, by the dispatcher. And you put this port number in your
client tnsnames.ora instead of listener port number (1521 by default).
hth.
Yang, senior DBA Oracle
Carfield Yim wrote in message <3A46E736.FB2DCAC3_at_programmer.net>...
>The problem I face is the jdbc connection broken several time a day in
>my servlet application. I think that the cause is every several hour,
>the server will ping the client tosee if it still alive . If the client
>is un-reactable, the server will disconnection it. As my client connect
>to internet through a firework so that all incoming resquest is blocked.
>Thus, oracle server can't ping the database and close the connection.
>Because of this, I would like to know is there a way that I can know the
>port of jdbc client use for connection? Is it request the OS to get a
>free port or is it same as oracle server? (1521) Please tell me how can
>I know which port oracle client use so that I can open that port, thx
Received on Tue Dec 26 2000 - 11:59:31 CET