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 <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED] 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>
<DIV><SPAN class=160442817-03022003><FONT face="Courier New">1523 to be
web1</FONT></SPAN></DIV>
<DIV><SPAN class=160442817-03022003><FONT face="Courier New">1524 to be
test1</FONT></SPAN></DIV>
<DIV><SPAN class=160442817-03022003><FONT
face="Courier New"></FONT></SPAN> </DIV>
<DIV><SPAN class=160442817-03022003><FONT face="Courier New">Right now ports are
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>
<DIV><SPAN class=160442817-03022003><FONT face="Courier New">like it's a bunch
of small databases.</FONT></SPAN></DIV>
<DIV><SPAN class=160442817-03022003><FONT
face="Courier New"></FONT></SPAN> </DIV>
<DIV><SPAN class=160442817-03022003><FONT face="Courier New">Server is currently
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:[EMAIL PROTECTED]";><FONT
face="Courier New" size=2>[EMAIL PROTECTED]</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>
<DIV><FONT face="Courier New"></FONT> </DIV></BODY></HTML>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
