| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re:Listening on specific ports
Mike,
The listener is assigned the port, not the database. When a connection request comes in the listener receives it on the port assigned, 1521 being the default or most popular. Thereafter what happens depends on whether or not your using connection manager, multi threaded server, or dedicated server. Since I have not yet used Connection Manager, I'll talk about the other two.
With Multi threaded server, the simplest, the connection is re-directed to the nest available dispatcher which started when the database did and acquired a port at that time. It will hold onto it's port until it shuts down, typically with the database. The number of dispatchers you have dictates the number of ports, which in the truest sense are assigned to the database. Regrettably I don't know of a way to specify which port will be used by which dispatcher.
With Dedicated server, the listener behaves as above, but instead of passing off the connection to an existing process and port it, starts up a dedicated server, gets the port that server process got from the OS, and redirects the client to that port. You have no control that I know of on which port gets used for what.
The listener's port is just a constant that all clients use to connect to the database server. They always get redirected to a new port, no matter what. BTW, a listener can only listen on one port.
Dick Goulet
____________________Reply Separator____________________ Author: Michael Kline <mkline1_at_comcast.net> Date: 2/3/2003 9:43 AM
Is there an "Easy" way to assign specific tnslistener ports to a specific database?
Let's say I wanted:
1521 to be prod1
1522 to be devl1
1523 to be web1
1524 to be test1
Right now ports are basically assigned to servers which may well be adequate. But I was asked, and it seems that we give a listener ports and databases, but there is no link to make one equal the other.
Also, is there a limit on total number of ports that a listener can be assigned to? In some cases I could find that they could conceivably want to use 10 ports over 15-20 databases? I'm not sure this will be practical.
It's such an unusual concept as usually there are 2-3 "large" databases, and this one server looks like it's a bunch of small databases.
Server is currently Solaris 8, database 8.1.7 all sharing the same ORACLE_HOME.
Thanks.
Michael Alan Kline, Sr.
Principal Consultant
Business to Business Solutions, LLC
Phone: 804-744-1545 Cell: 804-314-6262
ICQ: 1009605, 975313
Email: mkline_at_b2bsol.com Web: www.b2bsol.com
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1126" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=160442817-03022003><FONT face="Courier New">Is there an "Easy"
way to assign specific tnslistener</FONT></SPAN></DIV>
<DIV><SPAN class=160442817-03022003><FONT face="Courier New">ports to a specific
database?</FONT></SPAN></DIV>
<DIV><SPAN class=160442817-03022003><FONT
face="Courier New"></FONT></SPAN> </DIV>
<DIV><SPAN class=160442817-03022003><FONT face="Courier New">Let's say I
wanted:</FONT></SPAN></DIV>
<DIV><SPAN class=160442817-03022003><FONT
face="Courier New"></FONT></SPAN> </DIV>
<DIV><SPAN class=160442817-03022003><FONT face="Courier New">1521 to be
prod1</FONT></SPAN></DIV>
<DIV><SPAN class=160442817-03022003><FONT face="Courier New">1522 to be
devl1</FONT></SPAN></DIV>
basically assigned to servers</FONT></SPAN></DIV>
<DIV><SPAN class=160442817-03022003><FONT face="Courier New">which may well be
adequate. But I was asked, and </FONT></SPAN></DIV>
<DIV><SPAN class=160442817-03022003><FONT face="Courier New">it seems that we
give a listener ports and databases,</FONT></SPAN></DIV>
<DIV><SPAN class=160442817-03022003><FONT face="Courier New">but there is no
link to make one equal the other.</FONT></SPAN></DIV>
<DIV><SPAN class=160442817-03022003><FONT
face="Courier New"></FONT></SPAN> </DIV>
<DIV><SPAN class=160442817-03022003><FONT face="Courier New">Also, is there a
limit on total number of ports</FONT></SPAN></DIV>
<DIV><SPAN class=160442817-03022003><FONT face="Courier New">that a listener can
be assigned to? In some cases</FONT></SPAN></DIV>
<DIV><SPAN class=160442817-03022003><FONT face="Courier New">I could find that
they could conceivably want to</FONT></SPAN></DIV>
<DIV><SPAN class=160442817-03022003><FONT face="Courier New">use 10 ports over
15-20 databases? I'm not sure</FONT></SPAN></DIV>
<DIV><SPAN class=160442817-03022003><FONT face="Courier New">this will be
practical.</FONT></SPAN></DIV>
<DIV><SPAN class=160442817-03022003><FONT
face="Courier New"></FONT></SPAN> </DIV>
<DIV><SPAN class=160442817-03022003><FONT face="Courier New">It's such an
unusual concept as usually there are</FONT></SPAN></DIV>
<DIV><SPAN class=160442817-03022003><FONT face="Courier New">2-3 "large"
databases, and this one server looks</FONT></SPAN></DIV>
Solaris 8, database 8.1.7 all</FONT></SPAN></DIV>
<DIV><SPAN class=160442817-03022003><FONT face="Courier New">sharing the same
ORACLE_HOME.</FONT></SPAN></DIV>
<DIV><SPAN class=160442817-03022003><FONT
face="Courier New"></FONT></SPAN> </DIV>
<DIV><SPAN class=160442817-03022003><FONT
face="Courier New">Thanks.</FONT></SPAN></DIV>
<DIV><SPAN class=160442817-03022003><FONT
face="Courier New"></FONT></SPAN> </DIV>
<DIV><FONT face="Courier New"></FONT> </DIV>
<DIV><FONT face="Courier New">Michael Alan Kline, Sr.<BR></FONT><FONT
face="Courier New" size=2>Principal Consultant<BR>Business to Business
Solutions, LLC<BR>Phone: 804-744-1545 Cell: 804-314-6262<BR>ICQ: 1009605,
975313<BR>Email: </FONT><A href="mailto:mkline_at_b2bsol.com"><FONT
face="Courier New" size=2>mkline_at_b2bsol.com</FONT></A><FONT face="Courier New" size=2> Web: </FONT><A href="http://www.b2bsol.com/"><FONT face="Courier New" size=2>www.b2bsol.com</FONT></A><BR></DIV>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: dgoulet_at_vicr.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Mon Feb 03 2003 - 12:08:53 CST
 |
 |