Re: Oracle Ports ....

Ravi Alluru wrote:
>
> I had asked this question before and had got no reponse from this group.
> I am hoping I will get some feed back this time.
> At the time of an oracle installation (7.3.4 or 8.1.6) on a Solaris server
> (running 6 , 7 or 8) how do you know which port to use.
> By default it is port 1521 , but I have seen cases where 1522 or 1526 etc
> are also being used.
> Can you change the TCP port for Oracle installs at the time of installation.
> Also are the ports used by the listeners only and the instance is
> independent of it when connections are local.
> I am really confused. Any pointers or guidance will be greatly appreciated.
> The only places I get to know which instance is on which port is from the
> listener.ora or the tnsnames.ora files.
> But how do the ports get assigned during the install itself.
>
> Thanking you in anticipation
>

The TNS listener is a program mainly helping the instance to get connected via network protocols. Most often you will interact with the listener according to that scheme:

• listener has bound any port on any ip address
• client connects to this port (it has to know that before)
• clients asks for handing over to a specific instance
• listener fork()s a shadow process of that instance or redirects to a MTS dispatcher process
• client interacts with that process

The ports can be chosen as will as long it is > 1023 and is not used by other processes. You can even specify a number of IP address/port combinations to listen on. You can specify them at install time or later on. You can restart the listener whenever you want without interupting a client/server connection. No problem as long as your clients now the address of the listener and the correct service name of the instance.

Hope that helps.

Uwe

-- 
Uwe Schneider       | Telefon +49 7244 / 609504
Karlsdorfer Str. 31 | Mail    uwe_at_richard-schneider.de
DE-76356 Weingarten | http://www.richard-schneider.de/uwe
Linux - OS al dente!