Re: Which port does SQL*Net use?

"Yat-Fan" <fan.ho_at_alumni.ust.hk> wrote:

> Why do we need to specify the port in UNIX /etc/services but not in NT
> SERVICES file?

You only need to specify a port in the services file if you configure the client or server software to use the name of the service and not the actual number of the port. (which is the "correct" way to configure network services anyway)

For example, instead of hardcoding a port number in a config file, you specify the name of the service. The services file is then used by the sockets API to look up the port number to use. This way, you can reconfigure the services port numbers quite easily. If the client/server services use hard coded portnumbers, you have less flexibility in re-configuring your network services.

So the answer to your question is that you do not need to touch the services file on either Unix or NT if you're using port numbers in the Oracle config files for the listener and SQL*Net services. However, if you're using service names instead, you have to define that service and the service's port number in the services file.

regards,
Billy

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Sat Jul 04 1998 - 00:00:00 CDT