Re: Which port does SQL*Net use?

Hi,

I know Oracle uses the definition port in listener.ora. The port numbers, 1521, 1525 of /etc/services is just recommend by Oracle Co.
But you can use any port that is not using in your system.

Check point)
First, you must change sql*net port number in listener.ora   then, restart your listener.
Second, you must chage client part.That is to say, the port number   should be changed in tnsnames.ora. This is located in your client, PC or NT.

Centainly, you should use same port number listener.ora (server part) and tnsnames.ora (client part)

Good luck!

Yat-Fan wrote:

> Hello all,
>
> I am using SQL*Plus 3.3 to connect to Oracle 8.0.4 server on WinNT
> 4.0.
>
> QUESTION:
> Due to security reasons, the network traffic is restricted (through an
> IP
> gateway emulated by a Linux server), and since I used to think that
> SQL*Net
> is using
> ports 1521 or 1526, I asked the network team to release traffic
> between
> server ports 1521, 1526 and my PC ports 1024 and above.
>
> However, this did not work. We finally need to open the traffic
> between
> server ports 1024 and above and my PC port 1024 and above.
>
> INITIAL GUESS:
> Is it that SQL*Net can be set to be dynamically binded? In UNIX, we
> see that
> in /etc/services, the SQL*Net port is binded to 1521/1526, but I don't
> see
> such an entry in any of our NT installations (maybe cos' for other
> installations, we do not need to
> import traffic restrictions).
>
> Can anyone help?
>
> Many many thanks.
>
> Rgds.,
> fan.
> (Yat-Fan HO, The Kowloon-Canton Railway Corp., HONG KONG)
> ps. It's best if in addition to posting a reply, also forward one copy
> of
> the reply to
> me. Many thanks again.
Received on Thu Jul 09 1998 - 00:00:00 CDT